VIEW: APPS.MSD_DP_SCENARIOS_V

Source

View Text - Preformatted

SELECT mds.ROWID, mds.DEMAND_PLAN_ID, mdp.demand_plan_name, mds.SCENARIO_ID, mds.SCENARIO_NAME, mds.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, flv2.meaning, mds.FORECAST_BASED_ON, flv3.meaning, 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.consume_flag from fnd_lookup_values_vl flv1, fnd_lookup_values_vl flv2, fnd_lookup_values_vl flv3, msd_demand_plans mdp, msd_dp_scenarios mds 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 flv2.lookup_code (+) = mds.FORECAST_DATE_USED and flv2.lookup_type (+) = 'MSD_DATE_USED' and flv3.lookup_code (+) = mds.FORECAST_BASED_ON and flv3.lookup_type (+) = 'MSD_DATA_ELEMENT' order by mds.demand_plan_id, mds.scenario_name

View Text - HTML Formatted

SELECT MDS.ROWID
, MDS.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MDS.SCENARIO_ID
, MDS.SCENARIO_NAME
, MDS.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
, FLV2.MEANING
, MDS.FORECAST_BASED_ON
, FLV3.MEANING
, 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.CONSUME_FLAG
FROM FND_LOOKUP_VALUES_VL FLV1
, FND_LOOKUP_VALUES_VL FLV2
, FND_LOOKUP_VALUES_VL FLV3
, MSD_DEMAND_PLANS MDP
, MSD_DP_SCENARIOS MDS
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 FLV2.LOOKUP_CODE (+) = MDS.FORECAST_DATE_USED
AND FLV2.LOOKUP_TYPE (+) = 'MSD_DATE_USED'
AND FLV3.LOOKUP_CODE (+) = MDS.FORECAST_BASED_ON
AND FLV3.LOOKUP_TYPE (+) = 'MSD_DATA_ELEMENT' ORDER BY MDS.DEMAND_PLAN_ID
, MDS.SCENARIO_NAME