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_VL

Line 2769: FROM ahl_route_operations ro, AHL_OPERATIONS_VL OP

2765:
2766: -- get only operations with latest revision
2767: CURSOR l_get_ops_count(p_route_id IN NUMBER) IS
2768: SELECT COUNT(ro.operation_id)
2769: FROM ahl_route_operations ro, AHL_OPERATIONS_VL OP
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)

Line 2789: FROM ahl_route_operations ro, AHL_OPERATIONS_VL OP

2785:
2786: -- get only operations with latest revision
2787: CURSOR l_get_rt_oper_csr(p_route_id IN NUMBER) IS
2788: SELECT RO.OPERATION_ID, RO.STEP
2789: FROM ahl_route_operations ro, AHL_OPERATIONS_VL OP
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)