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_BIS_RES_SUMMARY

Line 155: from msc_bis_res_summary mbrs,

151: cursor c_util_details is
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

Line 217: from msc_bis_res_summary mbrs,

213:
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