WIE_RESOURCE_TRANSACTIONS

-- ============================================================
-- Table  : WIE_RESOURCE_TRANSACTIONS — The resource charge ledger — labor and equipment usage charged (or reversed) against work order operation resources, with full lineage down to the resource assignment
-- Purpose: Column-selected read of WIE_RESOURCE_TRANSACTIONS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + WO_RESOURCE_TRANSACTION_ID
-- 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_RESOURCE_TRANSACTION_ID AS "Surrogate key of the resource charge",
  t.TRANSACTION_TYPE_CODE AS "Charge vs reversal event type",  -- decode t.TRANSACTION_TYPE_CODE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'ORA_WIE_TRANSACTION_TYPE', LANGUAGE-filtered)
  t.TRANSACTION_DATE AS "When the usage was charged",
  t.TRANSACTION_QUANTITY AS "Usage charged by this event",
  t.TRANSACTION_UOM_CODE AS "UOM of the usage",
  t.ORGANIZATION_ID AS "Plant",
  t.WORK_ORDER_ID AS "Work order — carried directly on this ledger, unlike the requirement table",
  t.WO_OPERATION_ID AS "Operation charged",
  t.WO_OPERATION_RESOURCE_ID AS "The resource assignment charged",
  t.RESOURCE_ID AS "The resource used",
  t.WORK_CENTER_ID AS "Work center context",
  t.INVENTORY_ITEM_ID AS "The work order's product (denormalized)",
  t.CST_INTERFACED_FLAG AS "Whether the charge has been handed to cost management"
FROM <catalog>.<schema>.WIE_RESOURCE_TRANSACTIONS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.WO_RESOURCE_TRANSACTION_ID = <WO_RESOURCE_TRANSACTION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.WO_RESOURCE_TRANSACTION_ID;