APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on WIP_ENTITIES

Line 625: from wip_entities

621: -- Fix for bug# 6993283
622: --select location_type_code
623: select cii.wip_job_id,
624: (select wip_entity_name
625: from wip_entities
626: where wip_entity_id = cii.wip_job_id) wip_job_name
627: from csi_item_instances cii
628: where cii.instance_id= l_item_instance_id
629: --and location_type_code NOT IN ('PO','IN-TRANSIT','PROJECT','INVENTORY')

Line 673: l_wip_job_name WIP_ENTITIES.wip_entity_name%TYPE;

669: --
670:
671: -- Fix for bug# 6993283
672: l_inst_job_id NUMBER;
673: l_wip_job_name WIP_ENTITIES.wip_entity_name%TYPE;
674:
675: BEGIN
676:
677: -- Initialize API return status to success

Line 2697: --FROM ahl_workorders_v AHL, wip_entities WIP

2693:
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:

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