BOM_INVENTORY_COMPONENTS

-- ============================================================
-- Table  : BOM_INVENTORY_COMPONENTS — The compatibility view legacy queries know BOM components by — an APPS-schema access layer over the physical components table
-- Purpose: Column-selected read of BOM_INVENTORY_COMPONENTS — auto-generated from field metadata
-- Grain  : One row per COMPONENT_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.COMPONENT_SEQUENCE_ID AS "The component row id — identical to the base table's key",
  t.BILL_SEQUENCE_ID AS "The bill the component belongs to",
  t.COMPONENT_ITEM_ID AS "The component item",
  t.OPERATION_SEQ_NUM AS "The consuming routing operation",
  t.COMPONENT_QUANTITY AS "Usage quantity per assembly",
  t.EFFECTIVITY_DATE AS "Effectivity start",
  t.DISABLE_DATE AS "Effectivity end — NULL while active",
  t.IMPLEMENTATION_DATE AS "NULL on unimplemented ECO rows",
  t.WIP_SUPPLY_TYPE AS "Supply method — numeric, undecoded"
FROM <catalog>.<schema>.BOM_INVENTORY_COMPONENTS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.COMPONENT_SEQUENCE_ID = <COMPONENT_SEQUENCE_ID>
  -- AND t.EFFECTIVITY_DATE >= DATE '<DATE_FROM>'
  -- AND t.EFFECTIVITY_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.COMPONENT_SEQUENCE_ID;