WIE_WORK_ORDERS_B

-- ============================================================
-- Table  : WIE_WORK_ORDERS_B — The work order header — the primary product being built, the work definition version it was created from, the build quantity, status, and planned/actual execution dates
-- Purpose: Column-selected read of WIE_WORK_ORDERS_B — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + WORK_ORDER_ID + WORK_ORDER_NUMBER
-- Caution: COMPLETED/SCRAPPED/REJECTED quantities are maintained counters, not events — event history lives in the two transaction ledgers
-- 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.WORK_ORDER_ID AS "Surrogate key of the work order",
  t.WORK_ORDER_NUMBER AS "User-facing work order number",
  t.ORGANIZATION_ID AS "Manufacturing plant owning the work order",
  t.INVENTORY_ITEM_ID AS "The assembly / primary product item",
  t.WORK_DEFINITION_ID AS "The work definition used",
  t.WORK_DEFINITION_VERSION_ID AS "The specific version the order was created from",
  t.WORK_ORDER_STATUS_ID AS "The user-definable status row — join through it, don't filter literals",
  t.WORK_ORDER_TYPE AS "Standard vs nonstandard work",  -- decode t.WORK_ORDER_TYPE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'ORA_WIE_WO_TYPE', LANGUAGE-filtered)
  t.PLANNED_START_QUANTITY AS "Planned build quantity",
  t.COMPLETED_QUANTITY AS "Running total completed — a maintained counter, not events",
  t.SCRAPPED_QUANTITY AS "Running total scrapped",
  t.UOM_CODE AS "UOM the assembly is produced in",
  t.PLANNED_START_DATE AS "Scheduled start",
  t.PLANNED_COMPLETION_DATE AS "Scheduled finish",
  t.ACTUAL_START_DATE AS "Actual start",
  t.ACTUAL_COMPLETION_DATE AS "Actual finish",
  t.RELEASED_DATE AS "When released to the shop floor"
FROM <catalog>.<schema>.WIE_WORK_ORDERS_B t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.WORK_ORDER_ID = <WORK_ORDER_ID>
  -- AND t.WORK_ORDER_NUMBER = '<WORK_ORDER_NUMBER>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.WORK_ORDER_ID;