View: MSD_DP_SCENARIO_ALL_EVENTS_V

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

View Text

SELECT DEMAND_PLAN_ID
, DEMAND_PLAN_NAME
, SCENARIO_ID
, SCENARIO_NAME
, DESCRIPTION
, OUTPUT_PERIOD_TYPE_ID
, OUTPUT_PERIOD_TYPE
, HORIZON_START_DATE
, HORIZON_END_DATE
, FORECAST_DATE_USED_ID
, FORECAST_DATE_USED
, FORECAST_BASED_ON_ID
, FORECAST_BASED_ON
, PRICE_LIST_NAME
, EVENT_ID
, EVENT_NAME
, EVENT_DESCRIPTION
, EVENT_TYPE_ID
, EVENT_TYPE
, INTRODUCTION_TYPE_ID
, INTRODUCTION_TYPE
, EVENT_ASSOCIATION_PRIORITY
, DEFAULT_EVENT_PRIORITY
FROM MSD_DP_SCENARIO_EVENTS_V /* UNION SELECT DEMAND_PLAN_ID
, DEMAND_PLAN_NAME
, SCENARIO_ID
, SCENARIO_NAME
, DESCRIPTION
, OUTPUT_PERIOD_TYPE_ID
, OUTPUT_PERIOD_TYPE
, HORIZON_START_DATE
, HORIZON_END_DATE
, FORECAST_DATE_USED_ID
, FORECAST_DATE_USED
, FORECAST_BASED_ON_ID
, FORECAST_BASED_ON
, PRICE_LIST_NAME
, EVENT_ID
, EVENT_NAME
, EVENT_DESCRIPTION
, EVENT_TYPE_ID
, EVENT_TYPE
, INTRODUCTION_TYPE_ID
, INTRODUCTION_TYPE
, EVENT_PRIORITY EVENT_ASSOCIATION_PRIORITY
, EVENT_PRIORITY DEFAULT_EVENT_PRIORITY
FROM MSD_DP_SCN_INTRO_EVENTS_V */

Columns