eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSD_DP_ASCP_SCENARIOS_V

Source

View Text - Preformatted


SELECT ds.demand_plan_id, dp.demand_plan_name, ds.scenario_id, ds.scenario_name, dp.organization_id, dp.sr_instance_id, mdsr.error_type, ds.consume_flag, msd_common_utilities.is_global_scenario(ds.demand_plan_id,ds.scenario_id,dp.use_org_specific_bom_flag), ds.last_revision, ds.return_forecast return_forecast FROM msd_dp_scenarios ds, msd_demand_plans dp, msd_dp_scenario_revisions mdsr WHERE ds.demand_plan_id = dp.demand_plan_id AND mdsr.scenario_id(+) = ds.scenario_id AND mdsr.revision(+) = ds.last_revision /* item or product family level */ AND EXISTS (SELECT 1 FROM msd_dp_scenario_output_levels ol WHERE ol.demand_plan_id = dp.demand_plan_id AND ol.scenario_id = ds.scenario_id AND ol.level_id IN (1,3) ) AND ( (NVL(dp.USE_ORG_SPECIFIC_BOM_FLAG,'N')='N') OR (EXISTS (SELECT 1 FROM msd_dp_scenario_output_levels ol WHERE ol.demand_plan_id = dp.demand_plan_id AND ol.scenario_id = ds.scenario_id AND ol.level_id = 7 ))) AND NVL(dp.plan_type,'DP') <> 'LIABILITY' AND ds.associate_parameter IS NULL UNION ALL SELECT 5555555 demand_plan_id, SUBSTRB(tl.name, 1, 30) demand_plan_name, tq.id + 5555555 scenario_id, SUBSTRB(tq.query_name, 1, 30) scenario_name, -23453 organization_id, msd_dem_upload_forecast.get_sr_instance_id_for_profile(tq.id) sr_instance_id, msd_dem_upload_forecast.get_error_type(tq.id) error_type, 'Y' consume_flag, msd_dem_upload_forecast.is_global_scenario(tq.id) global_scenario_flag, '1' last_revision, NULL return_forecast FROM msd_dem_transfer_list tl, msd_dem_transfer_query tq WHERE tl.id = tq.transfer_id AND tq.integration_type <> 1 AND tq.export_type = 1 AND tq.presentation_type = 1 AND msd_dem_upload_forecast.is_valid_scenario(tq.id) = 1 UNION ALL SELECT mds.demand_plan_id demand_plan_id, SUBSTRB(mds.forecast_based_on, 1, 30) demand_plan_name, MDS.SCENARIO_ID SCENARIO_ID, mds.scenario_name scenario_name, -23453 organization_id, msd_dem_upload_forecast.get_sr_instance_id_for_profile(tq.id) sr_instance_id, mds.error_type error_type, 'Y' consume_flag, mds.sc_type global_scenario_flag, '1' last_revision, NULL return_forecast FROM msd_dp_scenarios mds, msd_dem_transfer_query tq WHERE mds.forecast_based_on =SUBSTRB( tq.query_name,1,30)

View Text - HTML Formatted

SELECT DS.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, DS.SCENARIO_ID
, DS.SCENARIO_NAME
, DP.ORGANIZATION_ID
, DP.SR_INSTANCE_ID
, MDSR.ERROR_TYPE
, DS.CONSUME_FLAG
, MSD_COMMON_UTILITIES.IS_GLOBAL_SCENARIO(DS.DEMAND_PLAN_ID
, DS.SCENARIO_ID
, DP.USE_ORG_SPECIFIC_BOM_FLAG)
, DS.LAST_REVISION
, DS.RETURN_FORECAST RETURN_FORECAST
FROM MSD_DP_SCENARIOS DS
, MSD_DEMAND_PLANS DP
, MSD_DP_SCENARIO_REVISIONS MDSR
WHERE DS.DEMAND_PLAN_ID = DP.DEMAND_PLAN_ID
AND MDSR.SCENARIO_ID(+) = DS.SCENARIO_ID
AND MDSR.REVISION(+) = DS.LAST_REVISION /* ITEM OR PRODUCT FAMILY LEVEL */
AND EXISTS (SELECT 1
FROM MSD_DP_SCENARIO_OUTPUT_LEVELS OL
WHERE OL.DEMAND_PLAN_ID = DP.DEMAND_PLAN_ID
AND OL.SCENARIO_ID = DS.SCENARIO_ID
AND OL.LEVEL_ID IN (1
, 3) )
AND ( (NVL(DP.USE_ORG_SPECIFIC_BOM_FLAG
, 'N')='N') OR (EXISTS (SELECT 1
FROM MSD_DP_SCENARIO_OUTPUT_LEVELS OL
WHERE OL.DEMAND_PLAN_ID = DP.DEMAND_PLAN_ID
AND OL.SCENARIO_ID = DS.SCENARIO_ID
AND OL.LEVEL_ID = 7 )))
AND NVL(DP.PLAN_TYPE
, 'DP') <> 'LIABILITY'
AND DS.ASSOCIATE_PARAMETER IS NULL UNION ALL SELECT 5555555 DEMAND_PLAN_ID
, SUBSTRB(TL.NAME
, 1
, 30) DEMAND_PLAN_NAME
, TQ.ID + 5555555 SCENARIO_ID
, SUBSTRB(TQ.QUERY_NAME
, 1
, 30) SCENARIO_NAME
, -23453 ORGANIZATION_ID
, MSD_DEM_UPLOAD_FORECAST.GET_SR_INSTANCE_ID_FOR_PROFILE(TQ.ID) SR_INSTANCE_ID
, MSD_DEM_UPLOAD_FORECAST.GET_ERROR_TYPE(TQ.ID) ERROR_TYPE
, 'Y' CONSUME_FLAG
, MSD_DEM_UPLOAD_FORECAST.IS_GLOBAL_SCENARIO(TQ.ID) GLOBAL_SCENARIO_FLAG
, '1' LAST_REVISION
, NULL RETURN_FORECAST
FROM MSD_DEM_TRANSFER_LIST TL
, MSD_DEM_TRANSFER_QUERY TQ
WHERE TL.ID = TQ.TRANSFER_ID
AND TQ.INTEGRATION_TYPE <> 1
AND TQ.EXPORT_TYPE = 1
AND TQ.PRESENTATION_TYPE = 1
AND MSD_DEM_UPLOAD_FORECAST.IS_VALID_SCENARIO(TQ.ID) = 1 UNION ALL SELECT MDS.DEMAND_PLAN_ID DEMAND_PLAN_ID
, SUBSTRB(MDS.FORECAST_BASED_ON
, 1
, 30) DEMAND_PLAN_NAME
, MDS.SCENARIO_ID SCENARIO_ID
, MDS.SCENARIO_NAME SCENARIO_NAME
, -23453 ORGANIZATION_ID
, MSD_DEM_UPLOAD_FORECAST.GET_SR_INSTANCE_ID_FOR_PROFILE(TQ.ID) SR_INSTANCE_ID
, MDS.ERROR_TYPE ERROR_TYPE
, 'Y' CONSUME_FLAG
, MDS.SC_TYPE GLOBAL_SCENARIO_FLAG
, '1' LAST_REVISION
, NULL RETURN_FORECAST
FROM MSD_DP_SCENARIOS MDS
, MSD_DEM_TRANSFER_QUERY TQ
WHERE MDS.FORECAST_BASED_ON =SUBSTRB( TQ.QUERY_NAME
, 1
, 30)