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.

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_DP_SCENARIO_OUTPUT_LEVELS

Line 321: msd_dp_scenario_output_levels mdsol,

317: --
318: CURSOR get_output_levels_org( p_demand_plan_id NUMBER, p_scenario_id NUMBER) IS
319: select count( distinct decode(mlv.level_id, 3, 1, mlv.level_id))
320: from msd_levels mlv,
321: msd_dp_scenario_output_levels mdsol,
322: msd_demand_plans mdp
323: where mdsol.demand_plan_id = p_demand_plan_id
324: and mdsol.demand_plan_id = mdp.demand_plan_id
325: and nvl(mlv.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)

Line 336: msd_dp_scenario_output_levels mdsol,

332: --
333: CURSOR get_output_levels( p_demand_plan_id NUMBER, p_scenario_id NUMBER) IS
334: select count( distinct decode(mlv.level_id, 3, 1, mlv.level_id))
335: from msd_levels mlv,
336: msd_dp_scenario_output_levels mdsol,
337: msd_demand_plans mdp
338: where mdsol.demand_plan_id = p_demand_plan_id
339: and mdsol.demand_plan_id = mdp.demand_plan_id
340: and nvl(mlv.plan_type,'DP') = decode(mdp.plan_type,'SOP','DP','','DP',mdp.plan_type)

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 806: from msd_dp_scenario_output_levels

802: LEAD(level_id,5) over (partition by scenario_id order by level_id) as dim6,
803: LEAD(level_id,6) over (partition by scenario_id order by level_id) as dim7,
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