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.GMP_DESPATCH_LOAD_RPT_PKG dependencies on MSC_DEPARTMENT_RESOURCES

Line 511: ' msc_department_resources dr '||

507: ' ORDER BY 1,4 '||
508: ' ) DETAIL ' ||
509: ' FROM ' ||
510: ' msc_dept_res_instances mri, '||
511: ' msc_department_resources dr '||
512: ' WHERE dr.sr_instance_id = '|| inst_id ||
513: ' AND dr.sr_instance_id = mri.sr_instance_id (+) '||
514: ' AND dr.plan_id = '|| plan_id ||
515: ' AND dr.plan_id = mri.plan_id (+)'||

Line 693: SELECT distinct substr(resource_description,1,40) FROM msc_department_resources

689:
690: BEGIN
691: -- B7669553 Select 40 characters for resource_description Rajesh Patangya
692: OPEN cur_res_desc FOR
693: SELECT distinct substr(resource_description,1,40) FROM msc_department_resources
694: WHERE plan_id = plan_id
695: AND resource_id = p_resource_id
696: AND sr_instance_id = inst_id;
697: