BOM_OPERATIONAL_ROUTINGS

-- ============================================================
-- Table  : BOM_OPERATIONAL_ROUTINGS — The routing header — one routing per assembly item, organization, and alternate designator, with the common-routing pointer and the completion subinventory finished assemblies land in
-- Purpose: Column-selected read of BOM_OPERATIONAL_ROUTINGS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + ROUTING_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.
-- ============================================================
SELECT
  t.ROUTING_SEQUENCE_ID AS "Surrogate key of the routing — what operations hang off",
  t.ASSEMBLY_ITEM_ID AS "The assembly the routing builds",
  t.ORGANIZATION_ID AS "Owning inventory organization",
  t.ALTERNATE_ROUTING_DESIGNATOR AS "NULL for the primary routing",
  t.ROUTING_TYPE AS "1 = manufacturing, 2 = engineering (per the data dictionary's own comment)",
  t.COMMON_ROUTING_SEQUENCE_ID AS "The shared routing the operations actually live under — equals the own id when not common",
  t.COMPLETION_SUBINVENTORY AS "Where completed assemblies land by default",
  t.COMPLETION_LOCATOR_ID AS "Default completion locator",
  t.CFM_ROUTING_FLAG AS "Flow-manufacturing routing marker",
  t.PRIORITY AS "Routing priority among alternates",
  t.TOTAL_PRODUCT_CYCLE_TIME AS "Total product cycle time for flow routings"
FROM <catalog>.<schema>.BOM_OPERATIONAL_ROUTINGS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.ROUTING_SEQUENCE_ID = <ROUTING_SEQUENCE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.ROUTING_SEQUENCE_ID;