BOM_DEPARTMENTS

-- ============================================================
-- Table  : BOM_DEPARTMENTS — The department (work center) master per inventory organization — the places operations happen, with class, location, and the scrap account
-- Purpose: Column-selected read of BOM_DEPARTMENTS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + DEPARTMENT_ID
-- 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.DEPARTMENT_ID AS "Surrogate key of the department — globally unique",
  t.DEPARTMENT_CODE AS "The department code users see — unique only per organization",
  t.ORGANIZATION_ID AS "Inventory organization",
  t.DESCRIPTION AS "Department description",
  t.DEPARTMENT_CLASS_CODE AS "Department class grouping",
  t.LOCATION_ID AS "Physical location record",
  t.DISABLE_DATE AS "When the department was disabled — NULL while active",
  t.SCRAP_ACCOUNT AS "The GL account (CCID) scrap at this department charges to"
FROM <catalog>.<schema>.BOM_DEPARTMENTS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.DEPARTMENT_ID = <DEPARTMENT_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.DEPARTMENT_ID;