APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_HIERARCHIES

Line 2468: (select hierarchy_id from msd_hierarchies

2464: where demand_plan_id = p_new_dp_id
2465:
2466: and hierarchy_id in
2467:
2468: (select hierarchy_id from msd_hierarchies
2469:
2470: where dimension_code = p_dimension_code
2471:
2472: and nvl(plan_type,'DP') = decode(p_plan_type,null,'DP','SOP','DP','EOL','DP',p_plan_type))

Line 2604: from msd_hierarchies

2600: -- check if the seeded hierarchy exists or has been removed
2601:
2602: select count(*) into l_count
2603:
2604: from msd_hierarchies
2605:
2606: where hierarchy_id = c3_cur.selection_value
2607:
2608: and nvl(plan_type,'DP') = decode(l_plan_type,null,'DP','SOP','DP','EOL','DP',l_plan_type);

Line 2946: (select distinct hierarchy_id from msd_hierarchies

2942: and ((selection_type = 'H'
2943:
2944: and selection_value in
2945:
2946: (select distinct hierarchy_id from msd_hierarchies
2947:
2948: where dimension_code = p_dp_dimension_code))
2949:
2950: or (selection_type = 'L'

Line 3520: (select distinct hierarchy_id from msd_hierarchies

3516: and ((selection_type = 'H'
3517:
3518: and selection_value in
3519:
3520: (select distinct hierarchy_id from msd_hierarchies
3521:
3522: where dimension_code = p_dp_dimension_code))
3523:
3524: or (selection_type = 'L'

Line 7478: msd_hierarchies mh

7474: from msd_dp_dimensions mdd,
7475:
7476: msd_dp_hierarchies mdh,
7477:
7478: msd_hierarchies mh
7479:
7480: where mdd.dimension_code =
7481:
7482: (select dimension_code

Line 7484: from msd_hierarchies

7480: where mdd.dimension_code =
7481:
7482: (select dimension_code
7483:
7484: from msd_hierarchies
7485:
7486: where hierarchy_id = p_hierarchy_id) and
7487:
7488: mdh.dp_dimension_code=mdd.dp_dimension_code and

Line 7574: msd_hierarchies mh,

7570: from msd_dp_dimensions mdd,
7571:
7572: msd_dp_hierarchies mdh,
7573:
7574: msd_hierarchies mh,
7575:
7576: msd_hierarchy_levels mhl,
7577:
7578: msd_levels ml

Line 7584: from msd_hierarchies

7580: where mdd.dimension_code =
7581:
7582: (select dimension_code
7583:
7584: from msd_hierarchies
7585:
7586: where hierarchy_id = mh.hierarchy_id) and
7587:
7588: mdh.dp_dimension_code=mdd.dp_dimension_code and