MSC_DEMANDS

-- ============================================================
-- Table  : MSC_DEMANDS — Every demand row a plan considered — sales orders, forecasts, and the dependent demand exploded from supplies, each with its due date, quantity, and origin
-- Purpose: Column-selected read of MSC_DEMANDS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + DEMAND_ID + PLAN_ID + SR_INSTANCE_ID
-- Caution: Independent AND dependent demand share the table — segment ORIGINATION_TYPE or exploded component demand mixes into top-level order counts; always filter one PLAN_ID; rate-based rows carry rates, not discrete quantities
-- 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 "The demand row id — plan-scoped",
  t.PLAN_ID AS "The plan — every query filters one",
  t.SR_INSTANCE_ID AS "The collected source instance — part of the key",
  t.ORGANIZATION_ID AS "Planning-instance copy of the org id",
  t.INVENTORY_ITEM_ID AS "Planning-instance copy of the demanded item",
  t.USING_ASSEMBLY_ITEM_ID AS "The parent assembly generating dependent demand",
  t.USING_ASSEMBLY_DEMAND_DATE AS "The demand due date — the analysis date",
  t.USING_REQUIREMENT_QUANTITY AS "The required quantity",
  t.DISPOSITION_ID AS "The generating supply (dependent demand) or the schedule entry behind independent demand — the pegging thread",
  t.ORIGINATION_TYPE AS "Where the demand came from — sales order, forecast, dependent…; numeric, undecoded",
  t.DEMAND_TYPE AS "1 = discrete demand, 2 = rate-based (per the data dictionary's own comment) — rate rows carry rates, not quantities",
  t.DEMAND_PRIORITY AS "Priority input to plan scheduling",
  t.ASSEMBLY_DEMAND_COMP_DATE AS "The using assembly's completion date",
  t.PLANNING_GROUP AS "Planning group of the demand",
  t.DAILY_DEMAND_RATE AS "The daily rate on rate-based rows"
FROM <catalog>.<schema>.MSC_DEMANDS 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.PLAN_ID = <PLAN_ID>
  -- AND t.SR_INSTANCE_ID = <SR_INSTANCE_ID>
  -- AND t.USING_ASSEMBLY_DEMAND_DATE >= DATE '<DATE_FROM>'
  -- AND t.USING_ASSEMBLY_DEMAND_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;