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_VL

Line 2674: FROM AHL_OPERATIONS_VL OP,

2670: RO.step,
2671: OP.concatenated_segments,
2672: OP.operation_type_code,
2673: OP.description
2674: FROM AHL_OPERATIONS_VL OP,
2675: AHL_ROUTE_OPERATIONS RO
2676: WHERE OP.operation_id=RO.operation_id
2677: -- AND OP.revision_status_code='COMPLETE'
2678: AND RO.route_id=c_route_id

Line 3537: FROM AHL_OPERATIONS_VL OP

3533:
3534: CURSOR get_operation_details(p_operation_code VARCHAR2)
3535: IS
3536: SELECT OP.operation_id
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