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_RES_PLAN_PKG dependencies on MSC_RESOURCE_REQUIREMENTS

Line 152: msc_resource_requirements mrr

148: mrr.department_id,
149: mrr.resource_id
150: from
151: msc_full_pegging mfp2,
152: msc_resource_requirements mrr
153: where mfp2.plan_id = p_plan_id
154: and mfp2.plan_id = mrr.plan_id
155: and mfp2.sr_instance_id = mrr.sr_instance_id
156: --and mfp2.organization_id = mrr.organization_id

Line 326: msc_resource_requirements mrr,

322: to_number(null) planned_order,
323: to_number(null) work_order,
324: to_number(null) total_resource_cost
325: from
326: msc_resource_requirements mrr,
327: msc_department_resources mdr,
328: msc_hp_col_dtls b,
329: msc_hp_row_dtls h
330: where h.query_id = p_query_id

Line 365: msc_resource_requirements mrr,

361: to_number(null) planned_order,
362: to_number(null) work_order,
363: to_number(null) total_resource_cost
364: from
365: msc_resource_requirements mrr,
366: msc_department_resources mdr,
367: msc_hp_col_dtls b,
368: msc_hp_row_dtls h
369: where h.query_id = p_query_id

Line 498: msc_resource_requirements mrr,

494: (case when mrr.supply_type in (3,4,5,7,27,60) then mrr.resource_hours end)) *
495: mdr.resource_cost * (1 + nvl(mdr2.dept_overhead_cost,0)) end)
496: total_resource_cost
497: from
498: msc_resource_requirements mrr,
499: msc_department_resources mdr,
500: msc_department_resources mdr2,
501: msc_supplies ms,
502: msc_hp_col_dtls b,