WIP_MOVE_TRANSACTIONS

-- ============================================================
-- Table  : WIP_MOVE_TRANSACTIONS — The shop-floor move ledger — one row per move event with from/to operation and intraoperation step, quantity, and date; the throughput, cycle-time, and WIP-aging fact behind the operation counters
-- Purpose: Column-selected read of WIP_MOVE_TRANSACTIONS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + TRANSACTION_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.TRANSACTION_ID AS "Surrogate key of the move event",
  t.ORGANIZATION_ID AS "Inventory organization",
  t.WIP_ENTITY_ID AS "The job or schedule moved",
  t.PRIMARY_ITEM_ID AS "The assembly item",
  t.LINE_ID AS "The repetitive production line, for repetitive moves — there is no repetitive-schedule column on this ledger",
  t.TRANSACTION_DATE AS "When the move happened — the primary analysis date",
  t.GROUP_ID AS "Transaction group the move was processed in",
  t.ACCT_PERIOD_ID AS "Accounting period of the move",
  t.FM_OPERATION_SEQ_NUM AS "The operation moved FROM",
  t.FM_INTRAOPERATION_STEP_TYPE AS "The step moved from (queue, run, to-move, reject, scrap) — numeric, undecoded; direction derives from the from/to pair",
  t.TO_OPERATION_SEQ_NUM AS "The operation moved TO",
  t.TO_INTRAOPERATION_STEP_TYPE AS "The step moved to",
  t.FM_DEPARTMENT_ID AS "Department moved from",
  t.TO_DEPARTMENT_ID AS "Department moved to",
  t.TRANSACTION_QUANTITY AS "Quantity moved, in the transaction UOM",
  t.TRANSACTION_UOM AS "UOM of the move",
  t.PRIMARY_QUANTITY AS "Quantity in the assembly's primary UOM — the column to aggregate",
  t.REASON_ID AS "Reason code on the move"
FROM <catalog>.<schema>.WIP_MOVE_TRANSACTIONS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.TRANSACTION_ID = <TRANSACTION_ID>
  -- AND t.TRANSACTION_DATE >= DATE '<DATE_FROM>'
  -- AND t.TRANSACTION_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.TRANSACTION_ID;