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_DS_SCHEDULE dependencies on MSC_DEPARTMENT_RESOURCES

Line 156: msc_department_resources mdr

152: select mbrs.resource_date detail_date,
153: round(avg(nvl(mbrs.utilization,0)),p_round_val) run_util,
154: round(avg(nvl(mbrs.utilization,0)),p_round_val) setup_util -- pabram..need to change later
155: from msc_bis_res_summary mbrs,
156: msc_department_resources mdr
157: where mbrs.plan_id = mdr.plan_id
158: and mbrs.sr_instance_id = mdr.sr_instance_id
159: and mbrs.organization_id = mdr.organization_id
160: and mbrs.department_id = mdr.department_id

Line 218: msc_department_resources mdr

214: cursor c_util_summary is
215: select round(avg(nvl(mbrs.utilization,0)),p_round_val) actual_util,
216: round(avg(nvl(mbrs.utilization,0)),p_round_val) setup_util -- pabram..need to change later
217: from msc_bis_res_summary mbrs,
218: msc_department_resources mdr
219: where mbrs.plan_id = mdr.plan_id
220: and mbrs.sr_instance_id = mdr.sr_instance_id
221: and mbrs.organization_id = mdr.organization_id
222: and mbrs.department_id = mdr.department_id