APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_DP_SCENARIOS

Line 304: FROM msd_dp_scenarios mds,

300: mdp.end_date prm_end_date,
301: nvl(mdp.view_name, nvl(csd.planning_server_view_name,'MSD_CS_DATA_V')) view_name,
302: msd_cs_dfn_utl.get_planning_server_clmn(csd.cs_definition_id, mdp.FORECAST_DATE_USED) date_planning_view_clmn,
303: cdd.collect_level_id
304: FROM msd_dp_scenarios mds,
305: msd_dp_parameters mdp,
306: msd_cs_definitions csd,
307: msd_cs_defn_dim_dtls cdd
308: WHERE mds.demand_plan_id = p_demand_plan_id

Line 356: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp

352: CURSOR get_inv_output_levels ( p_demand_plan_id IN NUMBER) IS
353: SELECT scen.scenario_name,
354: ml.level_name,
355: ml.dimension_code
356: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp
357: WHERE a.demand_plan_id = p_demand_plan_id
358: and a.demand_plan_id = mdp.demand_plan_id
359: and nvl(ml.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
360: AND a.level_id = ml.level_id

Line 384: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp

380: -- get duplicate dimensions in output parameters.
381: --
382: CURSOR get_dup_dim_output_levels ( p_demand_plan_id IN NUMBER) IS
383: SELECT scen.scenario_name,ml.dimension_code, count(*)
384: FROM msd_dp_scenario_output_levels a, msd_levels ml, msd_dp_scenarios scen, msd_demand_plans mdp
385: WHERE a.level_id = ml.level_id
386: and a.demand_plan_id = mdp.demand_plan_id
387: and nvl(ml.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)
388: AND a.scenario_id = scen.scenario_id

Line 813: msd_dp_scenarios scen

809: LEAD(level_id,7) over (partition by scenario_id order by level_id) as dim8,
810: row_number() over (partition by scenario_id order by level_id) as rno
811: from msd_dp_scenario_output_levels
812: ) a,
813: msd_dp_scenarios scen
814: where a.rno=1
815: and a.scenario_id = scen.scenario_id
816: and a.demand_plan_id = scen.demand_plan_id
817: and scen.demand_plan_id = p_demand_plan_id

Line 841: from msd_dp_scenarios a,

837: Procedure chk_priority_scen_levels ( p_demand_plan_id in number) is
838:
839: cursor c1(p_demand_plan_id number) is
840: select a.scenario_id ,a.scenario_name fcst_scenario_name,a.dmd_priority_scenario_id,b.scenario_name pri_scenario_name
841: from msd_dp_scenarios a,
842: msd_dp_scenarios b
843: where a.demand_plan_id = p_demand_plan_id
844: and a.dmd_priority_scenario_id is not null
845: and b.scenario_id = a.dmd_priority_scenario_id

Line 842: msd_dp_scenarios b

838:
839: cursor c1(p_demand_plan_id number) is
840: select a.scenario_id ,a.scenario_name fcst_scenario_name,a.dmd_priority_scenario_id,b.scenario_name pri_scenario_name
841: from msd_dp_scenarios a,
842: msd_dp_scenarios b
843: where a.demand_plan_id = p_demand_plan_id
844: and a.dmd_priority_scenario_id is not null
845: and b.scenario_id = a.dmd_priority_scenario_id
846: and b.demand_plan_id = p_demand_plan_id;

Line 1507: from msd_dp_scenarios md

1503: 3, 3,
1504: 2, 2,
1505: 1, 2,
1506: 4)
1507: from msd_dp_scenarios md
1508: where md.scenario_id = p_sc_id;
1509:
1510: cursor c2 is
1511: select count(1)

Line 2631: from msd_dp_scenario_events mdse, msd_dp_scenarios b

2627: select mev.event_name, mev.event_id, mep.product_lvl_id, mep.product_lvl_name, mep.product_lvl_val
2628: from msd_event_products_v mep, msd_events_v mev
2629: where
2630: mep.event_id in ((select mdse.event_id
2631: from msd_dp_scenario_events mdse, msd_dp_scenarios b
2632: where mdse.demand_plan_id = p_demand_plan_id
2633: and mdse.scenario_id = b.scenario_id
2634: and b.enable_flag = 'Y')
2635: union

Line 3386: msd_dp_scenarios

3382: horizon_start_date,
3383: horizon_end_date,
3384: price_list_name
3385: FROM
3386: msd_dp_scenarios
3387: WHERE
3388: demand_plan_id = p_demand_plan_id
3389: AND price_list_name IS NOT NULL;
3390: