WIP_DISCRETE_JOBS

-- ============================================================
-- Table  : WIP_DISCRETE_JOBS — Discrete job detail — status, start/completed/scrapped quantities, scheduled vs actual dates, accounting class, and the BOM/routing the job was built from; the workhorse of job-level manufacturing analytics
-- Purpose: Column-selected read of WIP_DISCRETE_JOBS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + WIP_ENTITY_ID
-- Caution: Open quantity is arithmetic — START_QUANTITY − QUANTITY_COMPLETED − QUANTITY_SCRAPPED; there is no stored open column
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. 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.WIP_ENTITY_ID AS "The job id — key together with the organization",
  t.ORGANIZATION_ID AS "Inventory organization — part of the key",
  t.STATUS_TYPE AS "Job status — numeric; Oracle documents the statuses by name only (unreleased, released, complete, closed…), so the codes ship undecoded",
  t.PRIMARY_ITEM_ID AS "The assembly item the job builds",
  t.CLASS_CODE AS "The WIP accounting class — joins with the org",
  t.JOB_TYPE AS "Standard vs non-standard job",
  t.FIRM_PLANNED_FLAG AS "Whether planning may reschedule the job",
  t.WIP_SUPPLY_TYPE AS "Default supply method for the job's components",
  t.START_QUANTITY AS "Job start quantity",
  t.QUANTITY_COMPLETED AS "Quantity completed to date",
  t.QUANTITY_SCRAPPED AS "Quantity scrapped to date",
  t.NET_QUANTITY AS "The quantity planning nets as supply",
  t.SCHEDULED_START_DATE AS "Scheduled start — the plan-side analysis date",
  t.SCHEDULED_COMPLETION_DATE AS "Scheduled completion of the last unit",
  t.DATE_RELEASED AS "Actual release date",
  t.DATE_COMPLETED AS "Actual last-unit completion",
  t.DATE_CLOSED AS "When the job closed",
  t.COMPLETION_SUBINVENTORY AS "Where completed assemblies land",
  t.COMMON_BOM_SEQUENCE_ID AS "The bill the job was built against",
  t.COMMON_ROUTING_SEQUENCE_ID AS "The routing the job was built against"
FROM <catalog>.<schema>.WIP_DISCRETE_JOBS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.WIP_ENTITY_ID = <WIP_ENTITY_ID>
  -- AND t.SCHEDULED_START_DATE >= DATE '<DATE_FROM>'
  -- AND t.SCHEDULED_START_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.WIP_ENTITY_ID;