WIE_WO_OPERATION_MATERIALS

-- ============================================================
-- Table  : WIE_WO_OPERATION_MATERIALS — Component requirements of each work order operation — one row per material line with per-assembly usage, total requirement, supply method, and running issued/allocated/picked counters
-- Purpose: Column-selected read of WIE_WO_OPERATION_MATERIALS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + WO_OPERATION_MATERIAL_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_MATERIAL_ID AS "Surrogate key of the material line",
  t.WO_OPERATION_ID AS "Parent operation",
  t.WORK_ORDER_ID AS "Parent work order (denormalized)",
  t.ORGANIZATION_ID AS "Plant",
  t.MATERIAL_SEQ_NUMBER AS "Order of consumption within the operation",
  t.INVENTORY_ITEM_ID AS "Component item required",
  t.QUANTITY_PER_PRODUCT AS "Usage per unit of assembly, from the work definition",
  t.QUANTITY AS "Total requirement for the operation — plainly QUANTITY, there is no REQUIRED_QUANTITY",
  t.ISSUED_QUANTITY AS "Quantity issued so far — a counter; issue events are inventory transactions",
  t.ALLOCATED_QUANTITY AS "Quantity allocated by component picking",
  t.PICKED_QUANTITY AS "Pick-confirmed quantity from move orders",
  t.UOM_CODE AS "UOM of the requirement",
  t.REQUIRED_DATE AS "When the material is needed at the operation",
  t.SUPPLY_TYPE AS "Push, operation pull, or assembly pull supply",
  t.MATERIAL_TYPE AS "Input material classification",  -- decode t.MATERIAL_TYPE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'ORA_WIS_WD_INPUT_MATERIAL', LANGUAGE-filtered)
  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)
FROM <catalog>.<schema>.WIE_WO_OPERATION_MATERIALS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.WO_OPERATION_MATERIAL_ID = <WO_OPERATION_MATERIAL_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.WO_OPERATION_MATERIAL_ID;