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_RESOURCE_PKG dependencies on MSC_PLANS

Line 97: msc_plans mp

93: to_number(null) resource_cost,
94: to_number(null) resource_cost2
95: from msc_resource_requirements mrr,
96: msc_department_resources mdr,
97: msc_plans mp
98: where mp.plan_id = p_plan_id
99: and mrr.plan_id = mp.plan_id
100: and mdr.plan_id = mrr.plan_id
101: and mdr.sr_instance_id = mrr.sr_instance_id

Line 145: msc_plans mp

141: to_number(null) resource_cost,
142: to_number(null) resource_cost2
143: from msc_net_resource_avail mra,
144: msc_department_resources mdr,
145: msc_plans mp
146: where mp.plan_id = p_plan_id
147: and mra.plan_id = mp.plan_id
148: and mdr.plan_id = mra.plan_id
149: and mdr.sr_instance_id = mra.sr_instance_id

Line 195: msc_plans mp

191: from
192: msc_resource_requirements mrr,
193: msc_supplies ms ,
194: msc_department_resources mdr,
195: msc_plans mp
196: where mp.plan_id = p_plan_id
197: and mrr.plan_id = mp.plan_id
198: and mrr.parent_id = 2
199: and nvl(mrr.schedule_flag,2) = 1

Line 264: msc_plans mp

260: from
261: msc_bis_res_summary mdrs,
262: msc_department_resources mdr,
263: msc_trading_partners mtp,
264: msc_plans mp
265: where mdrs.plan_id = p_plan_id
266: and mp.plan_id = mdrs.plan_id
267: and mp.plan_type = 6
268: and nvl(mdrs.period_type, 0) = 1