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_HIERARCHY_LEVELS

Line 229: msd_hierarchy_levels_v hl

225: SELECT DISTINCT dp_dimension_code,
226: hl. hierarchy_name,
227: level_name
228: FROM msd_dp_hierarchies_v dh,
229: msd_hierarchy_levels_v hl
230: WHERE demand_plan_id = p_demand_plan_id
231: AND dp_dimension_code <> 'TIM'
232: AND dh.hierarchy_id = hl.hierarchy_id
233: AND level_id NOT IN

Line 361: from msd_hierarchy_levels b,

357: AND a.scenario_id = scen.scenario_id
358: AND scen.enable_flag = 'Y'
359: AND a.level_id not in
360: ( select b.level_id
361: from msd_hierarchy_levels b,
362: msd_dp_hierarchies_v c
363: where b.hierarchy_id = c.hierarchy_id
364: and c.demand_plan_id = p_demand_plan_id
365: union

Line 367: from msd_hierarchy_levels b,

363: where b.hierarchy_id = c.hierarchy_id
364: and c.demand_plan_id = p_demand_plan_id
365: union
366: select b.parent_level_id
367: from msd_hierarchy_levels b,
368: msd_dp_hierarchies_v c
369: where b.hierarchy_id = c.hierarchy_id
370: and c.demand_plan_id = p_demand_plan_id
371: );

Line 445: from msd_hierarchy_levels b,

441: AND mcdd.cs_definition_id = mcd.cs_definition_id
442: AND mcd.name = mdp.parameter_type
443: AND nvl(mcdd.collect_level_id, 0) not in
444: ( select b.level_id
445: from msd_hierarchy_levels b,
446: msd_dp_hierarchies_v c
447: where b.hierarchy_id = c.hierarchy_id
448: and c.demand_plan_id = p_demand_plan_id
449: and mcdd.dimension_code <> 'TIM'

Line 452: from msd_hierarchy_levels b,

448: and c.demand_plan_id = p_demand_plan_id
449: and mcdd.dimension_code <> 'TIM'
450: union
451: select b.parent_level_id
452: from msd_hierarchy_levels b,
453: msd_dp_hierarchies_v c
454: where b.hierarchy_id = c.hierarchy_id
455: and c.demand_plan_id = p_demand_plan_id
456: and mcdd.dimension_code <> 'TIM'

Line 462: from msd_hierarchy_levels b,

458:
459: -- Determine whether level is contain in Dp Hierarchies.
460: CURSOR get_inv_hier_lvl_prms (p_demand_plan_id IN NUMBER, p_lvl_id in NUMBER) is
461: select 1
462: from msd_hierarchy_levels b,
463: msd_dp_hierarchies_v c
464: where b.hierarchy_id = c.hierarchy_id
465: and c.demand_plan_id = p_demand_plan_id
466: and (b.level_id = p_lvl_id