VIEW: APPS.MSD_DP_SCENARIO_EVENTS_V

Source

View Text - Preformatted

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, mev.forecast_basis_id, mev.forecast_basis, 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, mdse.DELETEABLE_FLAG, mdse.ENABLE_NONSEED_FLAG from msd_events_v mev, msd_dp_scenarios_cs_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

View Text - HTML Formatted

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
, MEV.FORECAST_BASIS_ID
, MEV.FORECAST_BASIS
, 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
, MDSE.DELETEABLE_FLAG
, MDSE.ENABLE_NONSEED_FLAG
FROM MSD_EVENTS_V MEV
, MSD_DP_SCENARIOS_CS_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