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 operating unit (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. This object does not project LAST_UPDATE_DATE; use a full refresh or a verified base-table watermark strategy. 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 = <operating_unit_id>  -- operating unit id exposed under ORGANIZATION_ID by this view
ORDER BY t.ORGANIZATION_ID;