HR_OPERATING_UNITS

-- ============================================================
-- Table  : HR_OPERATING_UNITS — The delivered view that enumerates operating units — the ORG_ID domain — with their business group, ledger, and legal context; the standard way to turn the ORG_ID on an _ALL table into a name
-- Purpose: Column-selected read of HR_OPERATING_UNITS — 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 operating unit's org id — the value ORG_ID columns on _ALL tables carry",
  t.NAME AS "Operating unit name",
  t.SHORT_CODE AS "Operating unit short code",
  t.BUSINESS_GROUP_ID AS "The business group the operating unit belongs to",
  t.DATE_FROM AS "Effectivity start date",
  t.DATE_TO AS "Effectivity end date — NULL while active",
  t.SET_OF_BOOKS_ID AS "The ledger id — comes back as text (read from a generic attribute column), so cast with TO_NUMBER before joining GL_LEDGERS",
  t.DEFAULT_LEGAL_CONTEXT_ID AS "The default legal entity context — text for the same reason; cast before joining",
  t.USABLE_FLAG AS "Whether the operating unit is usable"
FROM <catalog>.<schema>.HR_OPERATING_UNITS 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;