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_CRP_HORIZONTAL_PLAN dependencies on MSC_DEPT_RES_INSTANCES

Line 811: msc_dept_res_instances mdri,

807: mrir.serial_number
808: FROM
809: msc_resource_requirements crp,
810: msc_department_resources cpr,
811: msc_dept_res_instances mdri,
812: msc_resource_instance_reqs mrir,
813: msc_form_query list
814: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
815: AND cpr.resource_id = list.number3

Line 902: msc_dept_res_instances mdri,

898: mrir.serial_number
899: FROM
900: msc_resource_requirements crp,
901: msc_department_resources cpr,
902: msc_dept_res_instances mdri,
903: msc_resource_instance_reqs mrir,
904: msc_form_query list
905: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
906: AND cpr.resource_id = list.number3

Line 2580: 'FROM msc_dept_res_instances '||

2576: 'res_instance_id, ' ||
2577: '-1, '||
2578: 'serial_number, '||
2579: 'serial_number '||
2580: 'FROM msc_dept_res_instances '||
2581: 'WHERE department_id in ('||p_dept_list||') ' ||
2582: 'AND resource_id in ('||p_res_list||') ' ||
2583: 'AND res_instance_id in ('||p_inst_list||') ' ||
2584: -- 'AND serial_number in ('''||p_serial_num_list||''' ) ' ||