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.MSC_PHUB_UTIL dependencies on MSC_PLANS

Line 130: msc_plans mp

126: l_plan_constrained number;
127: begin
128: select count(1) into l_plan_constrained
129: from
130: msc_plans mp
131: where
132: mp.plan_id = p_plan_id
133: and( nvl(mp.daily_resource_constraints,0 ) = 1
134: or nvl(mp.weekly_resource_constraints,0) = 1

Line 153: msc_plans

149: begin
150: select CURR_PLAN_TYPE
151: into l_plan_type
152: from
153: msc_plans
154: where
155: plan_id = p_plan_id;
156: return l_plan_type;
157: end get_plan_type;

Line 163: (select distinct plan_id, plan_type from msc_plans

159: FUNCTION get_default_plan_id(p_scenario_id number, p_plan_type number, p_plan_run_name varchar2) return number is
160: cursor c_default_plan_id(p_scenario_id varchar2) is
161: select distinct p.plan_id
162: from msc_scenario_plans sp, msc_scenarios s,
163: (select distinct plan_id, plan_type from msc_plans
164: union all
165: select distinct scenario_id, to_number(10)
166: from msd_dp_ascp_scenarios_v
167: where demand_plan_id=5555555) p