WIE_WO_OPERATION_RESOURCES

-- ============================================================
-- Table  : WIE_WO_OPERATION_RESOURCES — Labor and equipment requirements for each work order operation — usage rate, required and actual usage, assigned units, and charge behavior
-- Purpose: Column-selected read of WIE_WO_OPERATION_RESOURCES — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + WO_OPERATION_RESOURCE_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_OPERATION_RESOURCE_ID AS "Surrogate key of the resource assignment",
  t.WO_OPERATION_ID AS "Parent operation — there is NO work-order column here; hop through the operation",
  t.ORGANIZATION_ID AS "Plant",
  t.RESOURCE_SEQ_NUMBER AS "Sequence resources work in — equal numbers run parallel",
  t.RESOURCE_ID AS "The labor/equipment resource assigned",
  t.WORK_CENTER_ID AS "Work center the resource belongs to",
  t.REQUIRED_USAGE AS "Total required usage (rate × basis × order quantity)",
  t.USAGE_RATE AS "Usage per unit of assembly",
  t.ACTUAL_RESOURCE_USAGE AS "Actual charged usage — a maintained rollup of the resource ledger",
  t.UOM_CODE AS "UOM of the usage (typically hours)",
  t.BASIS_TYPE AS "Fixed vs variable usage basis",  -- decode t.BASIS_TYPE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'EGP_BOM_BASIS_TYPE', LANGUAGE-filtered)
  t.ASSIGNED_UNITS AS "Number of resource units assigned",
  t.CHARGE_TYPE AS "Manual vs automatic charging point",  -- decode t.CHARGE_TYPE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'ORA_WIS_CHARGE_TYPE', LANGUAGE-filtered)
  t.PRINCIPAL_FLAG AS "Exactly one principal resource among parallel resources"
FROM <catalog>.<schema>.WIE_WO_OPERATION_RESOURCES t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.WO_OPERATION_RESOURCE_ID = <WO_OPERATION_RESOURCE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.WO_OPERATION_RESOURCE_ID;