BOM_OPERATION_SEQUENCES

-- ============================================================
-- Table  : BOM_OPERATION_SEQUENCES — Routing operations — one row per operation per routing per effectivity window, department-assigned, with the count-point and backflush controls that decide where work is recorded
-- Purpose: Column-selected read of BOM_OPERATION_SEQUENCES — auto-generated from field metadata
-- Grain  : One row per OPERATION_SEQUENCE_ID
-- Caution: Date-effective operation rows — the same operation number reappears per revision window; as-of filtering applies here just like components
-- 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.OPERATION_SEQUENCE_ID AS "Surrogate key of the operation — what operation resources hang off",
  t.ROUTING_SEQUENCE_ID AS "The routing the operation belongs to — also where the organization resolves from",
  t.OPERATION_SEQ_NUM AS "The operation number practitioners see — what components and jobs reference by value",
  t.DEPARTMENT_ID AS "The department (work center) the operation runs in",
  t.EFFECTIVITY_DATE AS "When the operation row becomes effective — the as-of filter column",
  t.DISABLE_DATE AS "Effectivity end — NULL while active",
  t.IMPLEMENTATION_DATE AS "NULL on unimplemented engineering changes",
  t.STANDARD_OPERATION_ID AS "The standard operation this one was created from",
  t.OPERATION_DESCRIPTION AS "Operation description",
  t.COUNT_POINT_TYPE AS "Count-point/autocharge behavior — where work must be recorded",
  t.BACKFLUSH_FLAG AS "Whether moves backflush pull components here",
  t.OPTION_DEPENDENT_FLAG AS "Whether the operation appears only when its option is chosen",
  t.MINIMUM_TRANSFER_QUANTITY AS "Minimum quantity moved between operations",
  t.YIELD AS "Operation yield"
FROM <catalog>.<schema>.BOM_OPERATION_SEQUENCES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.OPERATION_SEQUENCE_ID = <OPERATION_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.OPERATION_SEQUENCE_ID;