VIEW: APPS.MSD_DP_SCENARIOS_VL

Source

View Text - Preformatted

SELECT mds.rowid row_id, mds.demand_plan_id, mdp.demand_plan_name, mds.scenario_id, mds.scenario_name, mds_tl.description, mds.output_period_type, flv1.meaning, mds.history_start_date, mds.history_end_date, mds.publish_flag, mds.enable_flag, mds.horizon_start_date, mds.horizon_end_date, mds.forecast_date_used, mcid.description, mds.forecast_based_on, decode(csd.description, null, '', csd.description || ':' ) || mds.parameter_name , mds.parameter_name, mds.price_list_name, mds.last_update_date, mds.last_updated_by, mds.creation_date, mds.created_by, mds.last_update_login, mds.request_id, mds.program_application_id, mds.program_id, mds.program_update_date, mds.attribute_category, mds.attribute1, mds.attribute2, mds.attribute3, mds.attribute4, mds.attribute5, mds.attribute6, mds.attribute7, mds.attribute8, mds.attribute9, mds.attribute10, mds.attribute11, mds.attribute12, mds.attribute13, mds.attribute14, mds.attribute15, mds.error_type, mds.consume_flag , mds.supply_plan_id, mds.supply_plan_name, mds.deleteable_flag, mds.supply_plan_flag, mds.enable_nonseed_flag, mds.scenario_designator, mds.last_revision, mds.status, mds.dmd_priority_scenario_id, mds.sc_type, mds.associate_parameter, mds.scenario_type from fnd_lookup_values_vl flv1, msd_cs_clmn_identifiers_vl mcid, msd_demand_plans mdp, msd_dp_scenarios mds, msd_cs_definitions_vl csd, msd_dp_scenarios_tl mds_tl WHERE mdp.demand_plan_id = mds.demand_plan_id and flv1.lookup_code(+) = mds.output_period_type and flv1.lookup_type(+) = 'MSD_PERIOD_TYPE' and csd.name(+) = mds.FORECAST_BASED_ON and mcid.column_identifier(+) = mds.FORECAST_DATE_USED and mds.demand_plan_id = mds_tl.demand_plan_id and mds.scenario_id = mds_tl.scenario_id and mds_tl.language = userenv('LANG')

View Text - HTML Formatted

SELECT MDS.ROWID ROW_ID
, MDS.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MDS.SCENARIO_ID
, MDS.SCENARIO_NAME
, MDS_TL.DESCRIPTION
, MDS.OUTPUT_PERIOD_TYPE
, FLV1.MEANING
, MDS.HISTORY_START_DATE
, MDS.HISTORY_END_DATE
, MDS.PUBLISH_FLAG
, MDS.ENABLE_FLAG
, MDS.HORIZON_START_DATE
, MDS.HORIZON_END_DATE
, MDS.FORECAST_DATE_USED
, MCID.DESCRIPTION
, MDS.FORECAST_BASED_ON
, DECODE(CSD.DESCRIPTION
, NULL
, ''
, CSD.DESCRIPTION || ':' ) || MDS.PARAMETER_NAME
, MDS.PARAMETER_NAME
, MDS.PRICE_LIST_NAME
, MDS.LAST_UPDATE_DATE
, MDS.LAST_UPDATED_BY
, MDS.CREATION_DATE
, MDS.CREATED_BY
, MDS.LAST_UPDATE_LOGIN
, MDS.REQUEST_ID
, MDS.PROGRAM_APPLICATION_ID
, MDS.PROGRAM_ID
, MDS.PROGRAM_UPDATE_DATE
, MDS.ATTRIBUTE_CATEGORY
, MDS.ATTRIBUTE1
, MDS.ATTRIBUTE2
, MDS.ATTRIBUTE3
, MDS.ATTRIBUTE4
, MDS.ATTRIBUTE5
, MDS.ATTRIBUTE6
, MDS.ATTRIBUTE7
, MDS.ATTRIBUTE8
, MDS.ATTRIBUTE9
, MDS.ATTRIBUTE10
, MDS.ATTRIBUTE11
, MDS.ATTRIBUTE12
, MDS.ATTRIBUTE13
, MDS.ATTRIBUTE14
, MDS.ATTRIBUTE15
, MDS.ERROR_TYPE
, MDS.CONSUME_FLAG
, MDS.SUPPLY_PLAN_ID
, MDS.SUPPLY_PLAN_NAME
, MDS.DELETEABLE_FLAG
, MDS.SUPPLY_PLAN_FLAG
, MDS.ENABLE_NONSEED_FLAG
, MDS.SCENARIO_DESIGNATOR
, MDS.LAST_REVISION
, MDS.STATUS
, MDS.DMD_PRIORITY_SCENARIO_ID
, MDS.SC_TYPE
, MDS.ASSOCIATE_PARAMETER
, MDS.SCENARIO_TYPE
FROM FND_LOOKUP_VALUES_VL FLV1
, MSD_CS_CLMN_IDENTIFIERS_VL MCID
, MSD_DEMAND_PLANS MDP
, MSD_DP_SCENARIOS MDS
, MSD_CS_DEFINITIONS_VL CSD
, MSD_DP_SCENARIOS_TL MDS_TL
WHERE MDP.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND FLV1.LOOKUP_CODE(+) = MDS.OUTPUT_PERIOD_TYPE
AND FLV1.LOOKUP_TYPE(+) = 'MSD_PERIOD_TYPE'
AND CSD.NAME(+) = MDS.FORECAST_BASED_ON
AND MCID.COLUMN_IDENTIFIER(+) = MDS.FORECAST_DATE_USED
AND MDS.DEMAND_PLAN_ID = MDS_TL.DEMAND_PLAN_ID
AND MDS.SCENARIO_ID = MDS_TL.SCENARIO_ID
AND MDS_TL.LANGUAGE = USERENV('LANG')