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_VISITS_VL

Line 773: AHL_VISITS_VL AVL

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
777: AND AVL.organization_id = c_org_id

Line 794: FROM AHL_VISITS_VL AVL

790: IS
791: SELECT AVL.visit_id,
792: AVL.START_DATE_TIME,
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

Line 798: AHL_VISITS_VL AVL

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: )
802: AND AVL.department_id = c_dept_id

Line 1289: FROM ahl_visits_vl AVL,

1285: AVL.START_DATE_TIME,
1286: AVL.CLOSE_DATE_TIME,
1287: UCH.UNIT_CONFIG_HEADER_ID,
1288: TRUNC((AVL.CLOSE_DATE_TIME - AVL.START_DATE_TIME)*24) visit_duration
1289: FROM ahl_visits_vl AVL,
1290: AHL_UNIT_CONFIG_HEADERS UCH
1291: WHERE AVL.status_code IN ('PLANNING','RELEASED','PARTIALLY RELEASED')
1292: AND AVL.template_flag = 'N'
1293: AND UCH.csi_item_instance_id = AVL.Item_Instance_id