APPS.WIP_EAM_GENEALOGY_PVT dependencies on CSI_ITEM_INSTANCES

Line 287: FROM csi_item_instances cii, mtl_parameters mp

283: begin
284:
285: SELECT cii.instance_id, mp.maint_organization_id,cii.instance_number
286: INTO l_parent_instance_id , l_maint_orgid,l_parent_instance_number
287: FROM csi_item_instances cii, mtl_parameters mp
288: WHERE cii.serial_number = l_parent_serial_number
289: AND cii.inventory_item_id = l_parent_inventory_item_id
290: AND cii.last_vld_organization_id = mp.organization_id
291: AND cii.last_vld_organization_id= l_organization_id ;

Line 295: FROM csi_item_instances cii

291: AND cii.last_vld_organization_id= l_organization_id ;
292:
293: SELECT cii.instance_number, cii.instance_id
294: INTO l_reference, l_instance_id
295: FROM csi_item_instances cii
296: WHERE cii.serial_number = l_serial_number
297: AND cii.inventory_item_id = l_inventory_item_id
298: AND cii.last_vld_organization_id = l_organization_id;
299:

Line 736: FROM csi_item_instances cii, mtl_parameters mp

732: --Remove Parent Instance from Child Instance - 17
733: begin
734: SELECT cii.instance_id, mp.maint_organization_id
735: INTO l_instance_id , l_maint_orgid
736: FROM csi_item_instances cii, mtl_parameters mp
737: WHERE cii.serial_number = l_serial_number
738: AND cii.inventory_item_id = l_inventory_item_id
739: AND cii.last_vld_organization_id = mp.organization_id
740: AND cii.last_vld_organization_id= l_organization_id ;

Line 744: FROM csi_item_instances cii, mtl_serial_numbers msn

740: AND cii.last_vld_organization_id= l_organization_id ;
741:
742: SELECT cii.instance_number ,cii.instance_id
743: INTO l_reference, l_parent_instance_id
744: FROM csi_item_instances cii, mtl_serial_numbers msn
745: WHERE cii.serial_number = msn.serial_number
746: AND cii.inventory_item_id = msn.inventory_item_id
747: AND cii.last_vld_organization_id = msn.current_organization_id
748: AND msn.gen_object_id= l_parent_object_id ;

Line 783: FROM csi_item_instances cii, mtl_serial_numbers msn

779: --Remove Child Event from parent - 16
780: begin
781: SELECT cii.instance_id, cii.instance_number
782: INTO l_parent_instance_id, l_parent_instance_number
783: FROM csi_item_instances cii, mtl_serial_numbers msn
784: WHERE cii.serial_number = msn.serial_number
785: AND cii.inventory_item_id = msn.inventory_item_id
786: AND msn.gen_object_id = l_parent_object_id;
787:

Line 790: FROM csi_item_instances cii

786: AND msn.gen_object_id = l_parent_object_id;
787:
788: SELECT cii.instance_number
789: INTO l_reference
790: FROM csi_item_instances cii
791: WHERE cii.instance_id = l_instance_id
792: -- AND cii.inventory_item_id = l_inventory_item_id
793: AND cii.last_vld_organization_id = l_organization_id;
794: