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_PARTS_CHANGE_PVT dependencies on AHL_SEARCH_WORKORDERS_V

Line 2698: FROM ahl_search_workorders_v AHL, wip_entities WIP

2694: -- For wip_entity_id for the workorder
2695: CURSOR ahl_wip_entity_csr(p_wo_id in Number) IS
2696: Select AHL.wip_entity_id, WIP.entity_type
2697: --FROM ahl_workorders_v AHL, wip_entities WIP
2698: FROM ahl_search_workorders_v AHL, wip_entities WIP
2699: WHERE AHL.workorder_id = p_wo_id
2700: and WIP.wip_entity_id = AHL.wip_entity_id;
2701:
2702: --For the updated object_version number from csi_item_isntances

Line 3626: FROM ahl_search_workorders_v AHL

3622: l_api_name CONSTANT VARCHAR2(30) := 'get_dest_instance_rec';
3623: -- For wip_entity_id for the workorder
3624: CURSOR wip_entity_woid_csr(p_wo_id IN NUMBER) IS
3625: Select AHL.wip_entity_id,job_status_code
3626: FROM ahl_search_workorders_v AHL
3627: WHERE AHL.workorder_id = p_wo_id;
3628:
3629: CURSOR wip_entity_wonum_csr(p_wo_number IN VARCHAR2) IS
3630: Select AHL.wip_entity_id,job_status_code

Line 3631: FROM ahl_search_workorders_v AHL

3627: WHERE AHL.workorder_id = p_wo_id;
3628:
3629: CURSOR wip_entity_wonum_csr(p_wo_number IN VARCHAR2) IS
3630: Select AHL.wip_entity_id,job_status_code
3631: FROM ahl_search_workorders_v AHL
3632: WHERE AHL.JOB_NUMBER = p_wo_number;
3633:
3634: --For the updated object_version number from csi_item_isntances
3635: CURSOR csi_item_instance_id_csr(p_instance_id IN NUMBER) IS