WIS_WORK_DEFINITIONS

-- ============================================================
-- Table  : WIS_WORK_DEFINITIONS — The work definition header — one row per item + definition-name combination in a plant, binding the produced item, the item structure supplying material requirements, and the work method; the Fusion successor to the routing
-- Purpose: Column-selected read of WIS_WORK_DEFINITIONS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + WORK_DEFINITION_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.WORK_DEFINITION_ID AS "Surrogate key of the work definition header",
  t.ORGANIZATION_ID AS "Manufacturing plant (inventory org) owning the definition",
  t.INVENTORY_ITEM_ID AS "The produced assembly item",
  t.WORK_DEFINITION_NAME_ID AS "The reusable definition-name dimension row (Main, Alternate…)",
  t.WORK_DEFINITION_HEADER_NAME AS "Unique header name; the process name in process manufacturing",
  t.WORK_DEFINITION_TYPE AS "Kind of work definition",  -- decode t.WORK_DEFINITION_TYPE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'ORA_WIS_WORK_DEFINITION_TYPE', LANGUAGE-filtered)
  t.WORK_METHOD_ID AS "Discrete vs process work method",
  t.STATUS_CODE AS "Header status",  -- decode t.STATUS_CODE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'ORA_WIS_WD_STATUS', LANGUAGE-filtered)
  t.INACTIVE_DATE AS "When the definition stopped being usable — NULL while active",
  t.PRODUCTION_PRIORITY AS "Rank among the item's definitions — 1 is the primary",
  t.COSTING_PRIORITY AS "Which definition standard cost rollup uses",
  t.BILL_SEQUENCE_ID AS "The item structure supplying material requirements",
  t.QUANTITY AS "Output quantity the definition is stated for; the batch quantity in process manufacturing",
  t.UOM_CODE AS "UOM of that quantity"
FROM <catalog>.<schema>.WIS_WORK_DEFINITIONS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.WORK_DEFINITION_ID = <WORK_DEFINITION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.WORK_DEFINITION_ID;