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_DISP_UTIL_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 1958: FROM AHL_WORKORDER_OPERATIONS

1954:
1955: --Fetch the 1st open workorder operation (not complete) for workorder
1956: CURSOR get_workorder_oper_csr (p_workorder_id IN NUMBER) IS
1957: SELECT workorder_operation_id
1958: FROM AHL_WORKORDER_OPERATIONS
1959: WHERE workorder_id = p_workorder_id
1960: AND status_code <> G_WO_STATUS_COMPLETE
1961: ORDER BY operation_sequence_num asc;
1962:

Line 2497: ahl_workorder_operations wop

2493: CURSOR get_inst_pc_dtls(c_workorder_id IN NUMBER, c_relationship_id IN NUMBER, c_min_date IN DATE) IS
2494: SELECT pc.creation_date,
2495: pc.installed_instance_id
2496: FROM ahl_part_changes pc,
2497: ahl_workorder_operations wop
2498: WHERE pc.workorder_operation_id = wop.workorder_operation_id
2499: AND wop.workorder_id = c_workorder_id
2500: AND pc.mc_relationship_id = c_relationship_id
2501: AND pc.part_change_type = 'I'