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_LTP_RESRC_LEVL_PVT dependencies on AHL_OPERATIONS_B_KFV

Line 2774: FROM AHL_OPERATIONS_B_KFV OP1

2770: WHERE OP.operation_id=RO.operation_id
2771: AND ro.ROUTE_ID = p_route_id
2772: AND OP.revision_number IN
2773: ( SELECT MAX(OP1.revision_number)
2774: FROM AHL_OPERATIONS_B_KFV OP1
2775: WHERE OP1.concatenated_segments=OP.concatenated_segments
2776: AND OP1.revision_status_code='COMPLETE'
2777: AND TRUNC(SYSDATE) BETWEEN TRUNC(OP1.start_date_active) AND
2778: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))

Line 2794: FROM AHL_OPERATIONS_B_KFV OP1

2790: WHERE OP.operation_id=RO.operation_id
2791: AND ro.ROUTE_ID = p_route_id
2792: AND OP.revision_number IN
2793: ( SELECT MAX(OP1.revision_number)
2794: FROM AHL_OPERATIONS_B_KFV OP1
2795: WHERE OP1.concatenated_segments=OP.concatenated_segments
2796: AND OP1.revision_status_code='COMPLETE'
2797: AND TRUNC(SYSDATE) BETWEEN TRUNC(OP1.start_date_active) AND
2798: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))