EGP_COMPONENTS_B

-- ============================================================
-- Table  : EGP_COMPONENTS_B — Item structure component lines — one row per component per operation per effectivity window, child of the structure header, with quantity, yield, and WIP supply behavior
-- Purpose: Column-selected read of EGP_COMPONENTS_B — auto-generated from field metadata
-- Grain  : One row per COMPONENT_SEQUENCE_ID + BILL_SEQUENCE_ID
-- Caution: Component rows are effectivity slices — filter EFFECTIVITY_DATE/DISABLE_DATE to the window you mean or component counts multiply
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. 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.COMPONENT_SEQUENCE_ID AS "Component line surrogate key",
  t.BILL_SEQUENCE_ID AS "Parent structure header — the join back to the bill",
  t.OBJ_NAME AS "Object type of the component reference (EGO_ITEM)",
  t.PK1_VALUE AS "The component item's INVENTORY_ITEM_ID — stored as text; cast before joining the item master",
  t.PK2_VALUE AS "The component's ORGANIZATION_ID — stored as text",
  t.ITEM_NUM AS "Line/sort sequence of the component on the structure",
  t.OPERATION_SEQ_NUM AS "Operation the component is consumed at",
  t.COMPONENT_QUANTITY AS "Quantity of the component per assembly",
  t.COMPONENT_YIELD_FACTOR AS "Yield multiplier applied to the required quantity",
  t.PLANNING_FACTOR AS "Multiplier for planning quantity on option components",
  t.PRIMARY_UOM_CODE AS "Unit of measure for the component quantity",
  t.EFFECTIVITY_DATE AS "Start of the component's effectivity window",
  t.DISABLE_DATE AS "End of the component's effectivity window",
  t.IMPLEMENTATION_DATE AS "Change-order implementation date — NULL while pending",
  t.OPTIONAL AS "Whether the component is optional (model/option structures)",
  t.WIP_SUPPLY_TYPE AS "How the component is issued to work in process",
  t.SUPPLY_SUBINVENTORY AS "Default supply subinventory for the component",
  t.COMPONENT_ITEM_REVISION_ID AS "Item revision of the component, when revision-pinned"
FROM <catalog>.<schema>.EGP_COMPONENTS_B 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.BILL_SEQUENCE_ID = <BILL_SEQUENCE_ID>
  -- AND t.EFFECTIVITY_DATE >= DATE '<DATE_FROM>'
  -- AND t.EFFECTIVITY_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.COMPONENT_SEQUENCE_ID;