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_AMP_WORKBENCH_PVT dependencies on AHL_SPACE_ASSIGNMENTS

Line 772: FROM AHL_SPACE_ASSIGNMENTS ASA,

768: SELECT ASA.SPACE_ID,
769: AVL.visit_id ,
770: NVL2(ASA.START_FROM , ASA.START_FROM , AVL.START_DATE_TIME) START_DATE_TIME ,
771: NVL2(ASA.END_TO , ASA.END_TO , AVL.CLOSE_DATE_TIME) CLOSE_DATE_TIME
772: FROM AHL_SPACE_ASSIGNMENTS ASA,
773: AHL_VISITS_VL AVL
774: WHERE ASA.visit_id = AVL.visit_id
775: AND ASA.SPACE_ID = c_space_id
776: AND AVL.department_id = c_dept_id

Line 797: FROM AHL_SPACE_ASSIGNMENTS ASA,

793: AVL.CLOSE_DATE_TIME
794: FROM AHL_VISITS_VL AVL
795: WHERE AVL.visit_id NOT IN
796: (SELECT DISTINCT ASA.VISIT_ID
797: FROM AHL_SPACE_ASSIGNMENTS ASA,
798: AHL_VISITS_VL AVL
799: WHERE TRUNC(c_loop_date) BETWEEN TRUNC(NVL2(ASA.START_FROM, ASA.START_FROM , AVL.START_DATE_TIME))
800: AND TRUNC(NVL2(ASA.END_TO, ASA.END_TO , NVL(AVL.CLOSE_DATE_TIME, c_loop_date)))
801: )