View: MSD_DP_SCENARIO_EVENTS_V

Product:	MSD - Demand Planning
Description:	This view provides all the Events except for New Product Introduction Event - i.e., Promotion, Cannibalization, Product Phase Out, and Miscellaneous Events that are associated with a Demand Plan Scenario.
Implementation/DBA Data:	APPS.MSD_DP_SCENARIO_EVENTS_V

View Text

SELECT MDSE.ROWID ROW_ID
, MDSV.DEMAND_PLAN_ID
, MDSV.DEMAND_PLAN_NAME
, MDSV.SCENARIO_ID
, MDSV.SCENARIO_NAME
, MDSV.DESCRIPTION
, MDSV.OUTPUT_PERIOD_TYPE_ID
, MDSV.OUTPUT_PERIOD_TYPE
, MDSV.HORIZON_START_DATE
, MDSV.HORIZON_END_DATE
, MDSV.FORECAST_DATE_USED_ID
, MDSV.FORECAST_DATE_USED
, MDSV.FORECAST_BASED_ON_ID
, MDSV.FORECAST_BASED_ON
, MDSV.PRICE_LIST_NAME
, MEV.EVENT_ID
, MEV.EVENT_NAME
, MEV.EVENT_DESCRIPTION
, MEV.EVENT_TYPE_ID
, MEV.EVENT_TYPE
, MEV.INTRODUCTION_TYPE_ID
, MEV.INTRODUCTION_TYPE
, MDSE.EVENT_ASSOCIATION_PRIORITY
, MEV.EVENT_PRIORITY DEFAULT_EVENT_PRIORITY
, MDSE.LAST_UPDATE_DATE
, MDSE.LAST_UPDATED_BY
, MDSE.CREATION_DATE
, MDSE.CREATED_BY
, MDSE.LAST_UPDATE_LOGIN
, MDSE.REQUEST_ID
, MDSE.PROGRAM_APPLICATION_ID
, MDSE.PROGRAM_ID
, MDSE.PROGRAM_UPDATE_DATE
FROM MSD_EVENTS_V MEV
, MSD_DP_SCENARIOS_V MDSV
, MSD_DP_SCENARIO_EVENTS MDSE
WHERE MDSV.DEMAND_PLAN_ID = MDSE.DEMAND_PLAN_ID
AND MDSV.SCENARIO_ID = MDSE.SCENARIO_ID
AND MEV.EVENT_ID = MDSE.EVENT_ID

Columns