WIP_TRANSACTIONS

-- ============================================================
-- Table  : WIP_TRANSACTIONS — The WIP resource ledger — one row per resource charge (labor, machine, outside processing) with operation, resource, rates, and the purchasing/receiving references that drive outside-processing charges
-- Purpose: Column-selected read of WIP_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 resource charge",
  t.ORGANIZATION_ID AS "Inventory organization",
  t.WIP_ENTITY_ID AS "The job or schedule charged",
  t.LINE_ID AS "The repetitive production line, for repetitive charges",
  t.ACCT_PERIOD_ID AS "Accounting period of the charge",
  t.OPERATION_SEQ_NUM AS "The operation charged",
  t.RESOURCE_SEQ_NUM AS "The resource sequence within the operation",
  t.RESOURCE_ID AS "The resource charged",
  t.DEPARTMENT_ID AS "The department charged",
  t.TRANSACTION_DATE AS "When the charge happened — the primary analysis date",
  t.TRANSACTION_TYPE AS "The charge kind — numeric, undecoded; this column exists here, not on the move ledger",
  t.TRANSACTION_QUANTITY AS "Charged quantity in the transaction UOM",
  t.TRANSACTION_UOM AS "UOM of the charge",
  t.PRIMARY_QUANTITY AS "Quantity in the primary UOM",
  t.ACTUAL_RESOURCE_RATE AS "The actual rate charged",
  t.STANDARD_RESOURCE_RATE AS "The standard rate — variance analysis pairs it with the actual",
  t.PO_HEADER_ID AS "The outside-processing PO behind the charge, when OSP-driven",
  t.RCV_TRANSACTION_ID AS "The receiving transaction that triggered the OSP charge — the cross-ledger link to receiving"
FROM <catalog>.<schema>.WIP_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;