MTL_DEMAND

-- ============================================================
-- Table  : MTL_DEMAND — The legacy demand picture used by ATP and planning — summary demand, open demand, and pre-R12 reservation rows for an item in an org, keyed to the order document that generated them
-- Purpose: Column-selected read of MTL_DEMAND — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + DEMAND_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.DEMAND_ID AS "Surrogate key of the demand row",
  t.ORGANIZATION_ID AS "Inventory organization",
  t.INVENTORY_ITEM_ID AS "Item id",
  t.DEMAND_SOURCE_TYPE AS "What kind of document generated the demand",
  t.DEMAND_SOURCE_HEADER_ID AS "The demand document's header id",
  t.DEMAND_SOURCE_LINE AS "The demand document's line reference — a VARCHAR2, so numeric line-id joins need a cast",
  t.UOM_CODE AS "UOM the demand is expressed in",
  t.LINE_ITEM_QUANTITY AS "Demand quantity in the document UOM",
  t.PRIMARY_UOM_QUANTITY AS "Demand quantity in the item's primary UOM",
  t.REQUIREMENT_DATE AS "When the demand needs the material",
  t.RESERVATION_TYPE AS "Row flavor — summary demand, open demand, or a legacy reservation",
  t.COMPLETED_QUANTITY AS "How much of the demand has been satisfied"
FROM <catalog>.<schema>.MTL_DEMAND t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.DEMAND_ID = <DEMAND_ID>
  -- AND t.REQUIREMENT_DATE >= DATE '<DATE_FROM>'
  -- AND t.REQUIREMENT_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.DEMAND_ID;