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 3476: FROM AHL_OPERATIONS_VL OP,

3472: RO.step,
3473: OP.concatenated_segments,
3474: OP.operation_type_code,
3475: OP.description
3476: FROM AHL_OPERATIONS_VL OP,
3477: AHL_ROUTE_OPERATIONS RO
3478: WHERE OP.operation_id=RO.operation_id
3479: -- AND OP.revision_status_code='COMPLETE'
3480: AND RO.route_id=c_route_id

Line 4660: FROM AHL_OPERATIONS_VL OP

4656:
4657: CURSOR get_operation_details(p_operation_code VARCHAR2)
4658: IS
4659: SELECT OP.operation_id
4660: FROM AHL_OPERATIONS_VL OP
4661: WHERE OP.concatenated_segments=p_operation_code
4662: AND OP.revision_number IN
4663: ( SELECT MAX(OP1.revision_number)
4664: FROM AHL_OPERATIONS_B_KFV OP1