VIEW: APPS.MSD_DP_SCENARIOS_CS_V

Source

View Text - Preformatted

SELECT mdsv.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.history_start_date , mdsv.history_end_date , mdsv.publish_flag , mdsv.enable_flag , 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.parameter_name , mdsv.price_list_name , mdsv.last_update_date , mdsv.last_updated_by , mdsv.creation_date , mdsv.created_by , mdsv.last_update_login , mdsv.request_id , mdsv.program_application_id , mdsv.program_id , mdsv.program_update_date , mdsv.attribute_category , mdsv.attribute1 , mdsv.attribute2 , mdsv.attribute3 , mdsv.attribute4 , mdsv.attribute5 , mdsv.attribute6 , mdsv.attribute7 , mdsv.attribute8 , mdsv.attribute9 , mdsv.attribute10 , mdsv.attribute11 , mdsv.attribute12 , mdsv.attribute13 , mdsv.attribute14 , mdsv.attribute15 , mdsv.error_type , mdsv.consume_flag , mdsv.supply_plan_id , mdsv.supply_plan_name , mdsv.deleteable_flag ,mdsv.supply_plan_flag , mdsv.enable_nonseed_flag , mdsv.scenario_designator , mdsv.last_revision , mdsv.status , dmd_priority_scenario_id , (select mds1.scenario_name FROM msd_dp_scenarios mds1 WHERE mds1.scenario_id= mdsv.dmd_priority_scenario_id and mds1.demand_plan_id = mdsv.demand_plan_id) dmd_priority_scenario_name, mdsv.associate_parameter, mdsv.sc_type from msd_dp_scenarios_vl mdsv

View Text - HTML Formatted

SELECT MDSV.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.HISTORY_START_DATE
, MDSV.HISTORY_END_DATE
, MDSV.PUBLISH_FLAG
, MDSV.ENABLE_FLAG
, 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.PARAMETER_NAME
, MDSV.PRICE_LIST_NAME
, MDSV.LAST_UPDATE_DATE
, MDSV.LAST_UPDATED_BY
, MDSV.CREATION_DATE
, MDSV.CREATED_BY
, MDSV.LAST_UPDATE_LOGIN
, MDSV.REQUEST_ID
, MDSV.PROGRAM_APPLICATION_ID
, MDSV.PROGRAM_ID
, MDSV.PROGRAM_UPDATE_DATE
, MDSV.ATTRIBUTE_CATEGORY
, MDSV.ATTRIBUTE1
, MDSV.ATTRIBUTE2
, MDSV.ATTRIBUTE3
, MDSV.ATTRIBUTE4
, MDSV.ATTRIBUTE5
, MDSV.ATTRIBUTE6
, MDSV.ATTRIBUTE7
, MDSV.ATTRIBUTE8
, MDSV.ATTRIBUTE9
, MDSV.ATTRIBUTE10
, MDSV.ATTRIBUTE11
, MDSV.ATTRIBUTE12
, MDSV.ATTRIBUTE13
, MDSV.ATTRIBUTE14
, MDSV.ATTRIBUTE15
, MDSV.ERROR_TYPE
, MDSV.CONSUME_FLAG
, MDSV.SUPPLY_PLAN_ID
, MDSV.SUPPLY_PLAN_NAME
, MDSV.DELETEABLE_FLAG
, MDSV.SUPPLY_PLAN_FLAG
, MDSV.ENABLE_NONSEED_FLAG
, MDSV.SCENARIO_DESIGNATOR
, MDSV.LAST_REVISION
, MDSV.STATUS
, DMD_PRIORITY_SCENARIO_ID
, (SELECT MDS1.SCENARIO_NAME
FROM MSD_DP_SCENARIOS MDS1
WHERE MDS1.SCENARIO_ID= MDSV.DMD_PRIORITY_SCENARIO_ID
AND MDS1.DEMAND_PLAN_ID = MDSV.DEMAND_PLAN_ID) DMD_PRIORITY_SCENARIO_NAME
, MDSV.ASSOCIATE_PARAMETER
, MDSV.SC_TYPE
FROM MSD_DP_SCENARIOS_VL MDSV