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

Line 2681: FROM AHL_OPERATIONS_B_KFV OP1

2677: -- AND OP.revision_status_code='COMPLETE'
2678: AND RO.route_id=c_route_id
2679: AND OP.revision_number IN
2680: ( SELECT MAX(OP1.revision_number)
2681: FROM AHL_OPERATIONS_B_KFV OP1
2682: WHERE OP1.concatenated_segments=OP.concatenated_segments
2683: AND OP1.revision_status_code='COMPLETE'
2684: AND TRUNC(SYSDATE) BETWEEN TRUNC(OP1.start_date_active) AND
2685: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))

Line 3541: FROM AHL_OPERATIONS_B_KFV OP1

3537: FROM AHL_OPERATIONS_VL OP
3538: WHERE OP.concatenated_segments=p_operation_code
3539: AND OP.revision_number IN
3540: ( SELECT MAX(OP1.revision_number)
3541: FROM AHL_OPERATIONS_B_KFV OP1
3542: WHERE OP1.concatenated_segments=OP.concatenated_segments
3543: AND TRUNC(SYSDATE) BETWEEN TRUNC(OP1.start_date_active) AND
3544: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))
3545: AND OP1.revision_status_code='COMPLETE'