APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_DP_SCENARIOS

Line 300: FROM msd_dp_scenarios mds,

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

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

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

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

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

Line 808: msd_dp_scenarios scen

804: LEAD(level_id,7) over (partition by scenario_id order by level_id) as dim8,
805: row_number() over (partition by scenario_id order by level_id) as rno
806: from msd_dp_scenario_output_levels
807: ) a,
808: msd_dp_scenarios scen
809: where a.rno=1
810: and a.scenario_id = scen.scenario_id
811: and a.demand_plan_id = scen.demand_plan_id
812: and scen.demand_plan_id = p_demand_plan_id

Line 836: from msd_dp_scenarios a,

832: Procedure chk_priority_scen_levels ( p_demand_plan_id in number) is
833:
834: cursor c1(p_demand_plan_id number) is
835: select a.scenario_id ,a.scenario_name fcst_scenario_name,a.dmd_priority_scenario_id,b.scenario_name pri_scenario_name
836: from msd_dp_scenarios a,
837: msd_dp_scenarios b
838: where a.demand_plan_id = p_demand_plan_id
839: and a.dmd_priority_scenario_id is not null
840: and b.scenario_id = a.dmd_priority_scenario_id

Line 837: msd_dp_scenarios b

833:
834: cursor c1(p_demand_plan_id number) is
835: select a.scenario_id ,a.scenario_name fcst_scenario_name,a.dmd_priority_scenario_id,b.scenario_name pri_scenario_name
836: from msd_dp_scenarios a,
837: msd_dp_scenarios b
838: where a.demand_plan_id = p_demand_plan_id
839: and a.dmd_priority_scenario_id is not null
840: and b.scenario_id = a.dmd_priority_scenario_id
841: and b.demand_plan_id = p_demand_plan_id;

Line 1522: from msd_dp_scenarios md

1518: 3, 3,
1519: 2, 2,
1520: 1, 2,
1521: 4)
1522: from msd_dp_scenarios md
1523: where md.scenario_id = p_sc_id;
1524:
1525: cursor c2 is
1526: select count(1)

Line 2498: from msd_dp_scenario_events mdse, msd_dp_scenarios b

2494: select mev.event_name, mev.event_id, mep.product_lvl_id, mep.product_lvl_name, mep.product_lvl_val
2495: from msd_event_products_v mep, msd_events_v mev
2496: where
2497: mep.event_id in ((select mdse.event_id
2498: from msd_dp_scenario_events mdse, msd_dp_scenarios b
2499: where mdse.demand_plan_id = p_demand_plan_id
2500: and mdse.scenario_id = b.scenario_id
2501: and b.enable_flag = 'Y')
2502: union

Line 3253: msd_dp_scenarios

3249: horizon_start_date,
3250: horizon_end_date,
3251: price_list_name
3252: FROM
3253: msd_dp_scenarios
3254: WHERE
3255: demand_plan_id = p_demand_plan_id
3256: AND price_list_name IS NOT NULL;
3257: