MRP_SCHEDULE_DESIGNATORS

-- ============================================================
-- Table  : MRP_SCHEDULE_DESIGNATORS — The MDS/MPS schedule name master per organization — schedule type, relief behavior, and whether the schedule supplies ATP
-- Purpose: Column-selected read of MRP_SCHEDULE_DESIGNATORS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + SCHEDULE_DESIGNATOR
-- 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.SCHEDULE_DESIGNATOR AS "The MDS/MPS schedule name — key together with the organization",
  t.ORGANIZATION_ID AS "Inventory organization — part of the key",
  t.SCHEDULE_TYPE AS "MDS vs MPS — numeric, undecoded",
  t.MPS_RELIEF AS "Whether the planning manager relieves (consumes) the schedule as orders execute",
  t.INVENTORY_ATP_FLAG AS "Whether the schedule supplies ATP — always no for an MDS",
  t.DESCRIPTION AS "Schedule description",
  t.DISABLE_DATE AS "When the schedule was disabled — NULL while active",
  t.DEMAND_CLASS AS "Demand class the schedule serves",
  t.ORGANIZATION_SELECTION AS "Single-org vs multi-org schedule scope",
  t.PRODUCTION AS "Auto-release flag for the schedule"
FROM <catalog>.<schema>.MRP_SCHEDULE_DESIGNATORS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.SCHEDULE_DESIGNATOR = '<SCHEDULE_DESIGNATOR>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.SCHEDULE_DESIGNATOR;