EGP_STRUCTURES_B

-- ============================================================
-- Table  : EGP_STRUCTURES_B — Item structure (BOM) headers — one row per manufacturing or engineering bill per named variant, identified by BILL_SEQUENCE_ID, with common-structure sharing and change-order linkage
-- Purpose: Column-selected read of EGP_STRUCTURES_B — auto-generated from field metadata
-- Grain  : One row per BILL_SEQUENCE_ID
-- 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.BILL_SEQUENCE_ID AS "Structure header surrogate key — what component rows point at",
  t.OBJ_NAME AS "Object type the structure hangs on (EGO_ITEM for item structures)",
  t.PK1_VALUE AS "The assembly item's INVENTORY_ITEM_ID — stored as text; cast before joining the item master",
  t.PK2_VALUE AS "The assembly's ORGANIZATION_ID — stored as text; cast before joining",
  t.ALTERNATE_BOM_DESIGNATOR AS "Named structure variant — the structure name",
  t.STRUCTURE_TYPE_ID AS "Structure type identifier",
  t.EFFECTIVITY_CONTROL AS "Effectivity mode — date, unit number, or serial",
  t.COMMON_BILL_SEQUENCE_ID AS "Source bill when this bill references a shared structure — equals the row's own id when not shared",
  t.COMMON_ASSEMBLY_ITEM_ID AS "Assembly item of the shared (common) bill",
  t.COMMON_ORGANIZATION_ID AS "Organization of the shared (common) bill",
  t.SOURCE_BILL_SEQUENCE_ID AS "Originating bill sequence",
  t.CHANGE_ID AS "Change order that created the bill",
  t.CHANGE_LINE_ID AS "Change-order line that created the bill",
  t.VERSION_ID AS "Structure version for version-controlled setups"
FROM <catalog>.<schema>.EGP_STRUCTURES_B t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.BILL_SEQUENCE_ID = <BILL_SEQUENCE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.BILL_SEQUENCE_ID;