WIE_WO_OPERATIONS_B

-- ============================================================
-- Table  : WIE_WO_OPERATIONS_B — Work order operations — one row per execution step with its sequence, work center, count-point behavior, and the quantity balances sitting at each dispatch state
-- Purpose: Column-selected read of WIE_WO_OPERATIONS_B — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + WO_OPERATION_ID
-- Caution: READY/COMPLETED/SCRAPPED quantities are state balances maintained from the operation ledger — position, not history
-- 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.WO_OPERATION_ID AS "Surrogate key of the operation",
  t.WORK_ORDER_ID AS "Parent work order",
  t.ORGANIZATION_ID AS "Plant (denormalized)",
  t.OPERATION_SEQ_NUMBER AS "User-visible operation sequence (10, 20…)",
  t.STANDARD_OPERATION_ID AS "The standard operation this step was created from",
  t.WORK_CENTER_ID AS "Work center performing the step",
  t.OPERATION_TYPE AS "In-house vs supplier operation",  -- decode t.OPERATION_TYPE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'ORA_WIS_OPERATION_TYPE', LANGUAGE-filtered)
  t.COUNT_POINT_OPERATION_FLAG AS "Completion must be explicitly reported here",
  t.AUTO_TRANSACT_FLAG AS "Materials and resources auto-charge on completion",
  t.READY_QUANTITY AS "Quantity currently in the Ready (queue) state — a balance",
  t.COMPLETED_QUANTITY AS "Quantity completed at this operation — a counter",
  t.SCRAPPED_QUANTITY AS "Quantity scrapped here",
  t.PLANNED_START_DATE AS "Scheduled step start",
  t.PLANNED_COMPLETION_DATE AS "Scheduled step finish"
FROM <catalog>.<schema>.WIE_WO_OPERATIONS_B t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.WO_OPERATION_ID = <WO_OPERATION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.WO_OPERATION_ID;