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 233: msd_hierarchy_levels_v hl

229: SELECT DISTINCT dp_dimension_code,
230: hl. hierarchy_name,
231: level_name
232: FROM msd_dp_hierarchies_v dh,
233: msd_hierarchy_levels_v hl
234: WHERE demand_plan_id = p_demand_plan_id
235: AND dp_dimension_code <> 'TIM'
236: AND dh.hierarchy_id = hl.hierarchy_id
237: AND level_id NOT IN

Line 365: from msd_hierarchy_levels b,

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

Line 371: from msd_hierarchy_levels b,

367: where b.hierarchy_id = c.hierarchy_id
368: and c.demand_plan_id = p_demand_plan_id
369: union
370: select b.parent_level_id
371: from msd_hierarchy_levels b,
372: msd_dp_hierarchies_v c
373: where b.hierarchy_id = c.hierarchy_id
374: and c.demand_plan_id = p_demand_plan_id
375: );

Line 449: from msd_hierarchy_levels b,

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

Line 456: from msd_hierarchy_levels b,

452: and c.demand_plan_id = p_demand_plan_id
453: and mcdd.dimension_code <> 'TIM'
454: union
455: select b.parent_level_id
456: from msd_hierarchy_levels b,
457: msd_dp_hierarchies_v c
458: where b.hierarchy_id = c.hierarchy_id
459: and c.demand_plan_id = p_demand_plan_id
460: and mcdd.dimension_code <> 'TIM'

Line 466: from msd_hierarchy_levels b,

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