HR_ALL_ORGANIZATION_UNITS

-- ============================================================
-- Table  : HR_ALL_ORGANIZATION_UNITS — The master list of every organization unit of every classification — business groups, legal entities, operating units, inventory organizations, HR organizations — across all business groups; classification detail lives in HR_ORGANIZATION_INFORMATION
-- Purpose: Column-selected read of HR_ALL_ORGANIZATION_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.
-- ============================================================
SELECT
  t.ORGANIZATION_ID AS "The organization unit's key — the id every org-shaped reference in EBS ultimately resolves to",
  t.BUSINESS_GROUP_ID AS "The business group the org belongs to",
  t.NAME AS "Organization name",
  t.DATE_FROM AS "Effectivity start date",
  t.DATE_TO AS "Effectivity end date — NULL while active",
  t.LOCATION_ID AS "The org's physical location record",
  t.TYPE AS "User-defined organization type code",
  t.INTERNAL_EXTERNAL_FLAG AS "Internal vs external organization"
FROM <catalog>.<schema>.HR_ALL_ORGANIZATION_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;