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 325: msd_dp_scenario_output_levels mdsol,

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

Line 340: msd_dp_scenario_output_levels mdsol,

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

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

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