APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on WIP_ENTITIES

Line 592: from wip_entities

588: -- Fix for bug# 6993283
589: --select location_type_code
590: select cii.wip_job_id,
591: (select wip_entity_name
592: from wip_entities
593: where wip_entity_id = cii.wip_job_id) wip_job_name
594: from csi_item_instances cii
595: where cii.instance_id= l_item_instance_id
596: --and location_type_code NOT IN ('PO','IN-TRANSIT','PROJECT','INVENTORY')

Line 640: l_wip_job_name WIP_ENTITIES.wip_entity_name%TYPE;

636: --
637:
638: -- Fix for bug# 6993283
639: l_inst_job_id NUMBER;
640: l_wip_job_name WIP_ENTITIES.wip_entity_name%TYPE;
641:
642: BEGIN
643:
644: -- Initialize API return status to success

Line 2640: --FROM ahl_workorders_v AHL, wip_entities WIP

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

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