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_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DP_DIMENSIONS

Line 3923: from msd_dp_dimensions

3919:
3920: l_coll_dim := 0;
3921:
3922: select count(*) into l_coll_dim
3923: from msd_dp_dimensions
3924: where demand_plan_id=p_demand_plan_id
3925: and dimension_code = l_dimension_code
3926: and dp_dimension_code=l_dimension_code;
3927:

Line 7474: from msd_dp_dimensions mdd,

7470: cursor c_rep_hierarchy_id(p_demand_plan_id in number, p_hierarchy_id in number) is
7471:
7472: select min(mdh.hierarchy_id)
7473:
7474: from msd_dp_dimensions mdd,
7475:
7476: msd_dp_hierarchies mdh,
7477:
7478: msd_hierarchies mh

Line 7570: from msd_dp_dimensions mdd,

7566: cursor c_rep_level_id(p_demand_plan_id varchar2, p_level_id varchar2) is
7567:
7568: select min(ml.level_id)
7569:
7570: from msd_dp_dimensions mdd,
7571:
7572: msd_dp_hierarchies mdh,
7573:
7574: msd_hierarchies mh,

Line 7680: from msd_dp_dimensions

7676: cursor c1(p_demand_plan_id number, p_dimension_code varchar2) is
7677:
7678: select count(*)
7679:
7680: from msd_dp_dimensions
7681:
7682: where dimension_code=p_dimension_code and
7683:
7684: demand_plan_id=p_demand_plan_id;

Line 7736: from msd_dp_dimensions

7732: cursor c1(p_demand_plan_id number, p_dimension_code varchar2) is
7733:
7734: select count(*)
7735:
7736: from msd_dp_dimensions
7737:
7738: where dimension_code=p_dimension_code and
7739:
7740: demand_plan_id=p_demand_plan_id;