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 2641: FROM ahl_search_workorders_v AHL, wip_entities WIP

2637: -- For wip_entity_id for the workorder
2638: CURSOR ahl_wip_entity_csr(p_wo_id in Number) IS
2639: Select AHL.wip_entity_id, WIP.entity_type
2640: --FROM ahl_workorders_v AHL, wip_entities WIP
2641: FROM ahl_search_workorders_v AHL, wip_entities WIP
2642: WHERE AHL.workorder_id = p_wo_id
2643: and WIP.wip_entity_id = AHL.wip_entity_id;
2644:
2645: --For the updated object_version number from csi_item_isntances

Line 3569: FROM ahl_search_workorders_v AHL

3565: l_api_name CONSTANT VARCHAR2(30) := 'get_dest_instance_rec';
3566: -- For wip_entity_id for the workorder
3567: CURSOR wip_entity_woid_csr(p_wo_id IN NUMBER) IS
3568: Select AHL.wip_entity_id,job_status_code
3569: FROM ahl_search_workorders_v AHL
3570: WHERE AHL.workorder_id = p_wo_id;
3571:
3572: CURSOR wip_entity_wonum_csr(p_wo_number IN VARCHAR2) IS
3573: Select AHL.wip_entity_id,job_status_code

Line 3574: FROM ahl_search_workorders_v AHL

3570: WHERE AHL.workorder_id = p_wo_id;
3571:
3572: CURSOR wip_entity_wonum_csr(p_wo_number IN VARCHAR2) IS
3573: Select AHL.wip_entity_id,job_status_code
3574: FROM ahl_search_workorders_v AHL
3575: WHERE AHL.JOB_NUMBER = p_wo_number;
3576:
3577: --For the updated object_version number from csi_item_isntances
3578: CURSOR csi_item_instance_id_csr(p_instance_id IN NUMBER) IS