MRP_FORECAST_DESIGNATORS

-- ============================================================
-- Table  : MRP_FORECAST_DESIGNATORS — The forecast name and forecast set master per organization — consumption behavior (consume flag, forward/backward time fences, outlier cap) lives at this level
-- Purpose: Column-selected read of MRP_FORECAST_DESIGNATORS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + FORECAST_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.FORECAST_DESIGNATOR AS "The forecast (or forecast set) name — key together with the organization",
  t.ORGANIZATION_ID AS "Inventory organization — part of the key",
  t.DESCRIPTION AS "Forecast description",
  t.FORECAST_SET AS "The parent set — NULL when this row IS a set",
  t.CONSUME_FORECAST AS "Whether sales orders consume the forecast",
  t.UPDATE_TYPE AS "Consumption update behavior",
  t.BUCKET_TYPE AS "Set-level bucket — daily, weekly, or periodic",
  t.FOREWARD_UPDATE_TIME_FENCE AS "Forward consumption window in days (the column name really is spelled FOREWARD)",
  t.BACKWARD_UPDATE_TIME_FENCE AS "Backward consumption window in days",
  t.OUTLIER_UPDATE_PERCENTAGE AS "Cap on how much of the forecast one order may consume",
  t.DEMAND_CLASS AS "Demand class the forecast serves",
  t.DISABLE_DATE AS "When the forecast was disabled — NULL while active"
FROM <catalog>.<schema>.MRP_FORECAST_DESIGNATORS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.FORECAST_DESIGNATOR = '<FORECAST_DESIGNATOR>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.FORECAST_DESIGNATOR;