BOM_BILL_OF_MATERIALS

-- ============================================================
-- Table  : BOM_BILL_OF_MATERIALS — The compatibility view legacy queries know BOM headers by — a window onto the structures table under the familiar 11i name
-- Purpose: Column-selected read of BOM_BILL_OF_MATERIALS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + BILL_SEQUENCE_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. APPS-schema view — land its base tables for extraction; see the table notes.
-- ============================================================
SELECT
  t.BILL_SEQUENCE_ID AS "The bill id — identical to the base table's key",
  t.ASSEMBLY_ITEM_ID AS "The assembly item",
  t.ORGANIZATION_ID AS "Owning inventory organization",
  t.ALTERNATE_BOM_DESIGNATOR AS "NULL for the primary bill",
  t.ASSEMBLY_TYPE AS "Manufacturing vs engineering bill",
  t.COMMON_BILL_SEQUENCE_ID AS "The shared bill pointer"
FROM <catalog>.<schema>.BOM_BILL_OF_MATERIALS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.BILL_SEQUENCE_ID = <BILL_SEQUENCE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.BILL_SEQUENCE_ID;