WIP_ENTITIES

-- ============================================================
-- Table  : WIP_ENTITIES — The WIP identity registry — every discrete job, repetitive assembly, and flow schedule claims its id and unique name here before type-specific detail lands in child tables; the anchor outside references point at
-- Purpose: Column-selected read of WIP_ENTITIES — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + WIP_ENTITY_ID
-- 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 universal WIP key — globally unique; jobs, schedules, and outside references all carry it",
  t.ORGANIZATION_ID AS "Inventory organization",
  t.WIP_ENTITY_NAME AS "The job or schedule name users see — unique per organization",
  t.ENTITY_TYPE AS "Discrete job, repetitive assembly, or flow schedule — numeric, decode from your instance's manufacturing lookups",
  t.DESCRIPTION AS "Entity description",
  t.PRIMARY_ITEM_ID AS "The assembly item being built",
  t.GEN_OBJECT_ID AS "Genealogy object id for serialized tracking"
FROM <catalog>.<schema>.WIP_ENTITIES 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.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.WIP_ENTITY_ID;