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.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 7780: FROM ahl_visit_tasks_vl avt, ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

7776: -- Added this cursor to validate if any of the children UEs for a given visit is in EXCEPTION status
7777: -- and if yes, return the MR title corresponding to one of the UEs in EXCEPTION status
7778: CURSOR c_validate_ue_status (x_id IN NUMBER) IS
7779: SELECT mr.title
7780: FROM ahl_visit_tasks_vl avt, ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
7781: WHERE avt.visit_id = x_id
7782: AND NVL(avt.status_code, 'X') = 'PLANNING'
7783: AND (avt.task_type_code <> 'SUMMARY' OR
7784: (avt.task_type_code = 'SUMMARY' AND