ORG_ORGANIZATION_DEFINITIONS

-- ============================================================
-- Table  : ORG_ORGANIZATION_DEFINITIONS — The delivered view that presents inventory organizations with their operating unit, legal entity, ledger, and chart of accounts in one row — the org-mapping backbone of most inventory reporting
-- Purpose: Column-selected read of ORG_ORGANIZATION_DEFINITIONS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) — see the Fields section for the full key
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts. APPS-schema view — land its base tables for extraction; see the table notes.
-- ============================================================
SELECT
  t.ORGANIZATION_ID AS "The inventory organization's id",
  t.ORGANIZATION_CODE AS "The short org code users see (from the inventory parameters)",
  t.ORGANIZATION_NAME AS "Organization name",
  t.BUSINESS_GROUP_ID AS "The business group",
  t.OPERATING_UNIT AS "The operating unit (ORG_ID) this inventory org rolls up to — the org-mapping join",
  t.SET_OF_BOOKS_ID AS "The ledger — legacy column name kept from 11i; carries the R12 ledger id",
  t.LEGAL_ENTITY AS "The legal entity the org belongs to",
  t.CHART_OF_ACCOUNTS_ID AS "The chart of accounts behind the org's ledger",
  t.INVENTORY_ENABLED_FLAG AS "Whether the org is inventory-enabled",
  t.DISABLE_DATE AS "When the org was end-dated — NULL while active"
FROM <catalog>.<schema>.ORG_ORGANIZATION_DEFINITIONS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.ORGANIZATION_ID;