APPS.EAM_ASSET_MOVE_PUB dependencies on CSI_ITEM_INSTANCES

Line 62: FROM CSI_ITEM_INSTANCES

58: END IF;
59:
60: SELECT inventory_item_id
61: INTO l_Parent_inventory_item_id
62: FROM CSI_ITEM_INSTANCES
63: WHERE instance_id=p_parent_instance_id ;
64:
65: IF (l_ulog) THEN
66: l_module := 'eam.plsql.'|| l_full_name;

Line 252: csi_item_instances cii ,

248: mp.MAINT_ORGANIZATION_ID
249: FROM mtl_serial_numbers msn ,
250: mtl_object_genealogy mog,
251: mtl_system_items_b msi ,
252: csi_item_instances cii ,
253: mtl_parameters mp
254: WHERE mog.object_id = msn.gen_object_id
255: AND msn.current_organization_id = msi.organization_id
256: --AND msn.current_organization_id = p_current_org_id

Line 292: csi_item_instances cii

288: BEGIN
289: SELECT msn.GEN_OBJECT_ID
290: INTO l_parent_object_id
291: FROM mtl_serial_numbers msn,
292: csi_item_instances cii
293: WHERE cii.instance_id =p_parent_instance_id
294: AND cii.serial_number=msn.serial_number
295: AND cii.inventory_item_id=msn.inventory_item_id; --Added for 6955393
296: EXCEPTION

Line 325: FROM CSI_ITEM_INSTANCES cii,

321: mp.MAINT_ORGANIZATION_ID ,
322: NULL ,
323: NULL
324: INTO l_parent_inf_rec
325: FROM CSI_ITEM_INSTANCES cii,
326: MTL_PARAMETERS mp ,
327: MTL_SERIAL_NUMBERS msn,
328: MTL_SYSTEM_ITEMS_B msi
329: WHERE cii.instance_id =p_parent_instance_id

Line 554: l_Item_Revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;

550: l_txn_if_id NUMBER;
551: l_SERIAL_NUMBER VARCHAR2(30);
552: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;
553: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;
554: l_Item_Revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;
555: l_Transaction_Quantity NUMBER;
556: x_Message VARCHAR2(240);
557: x_Status VARCHAR2(30);
558: l_lot_control_code NUMBER;

Line 755: from csi_item_instances where INSTANCE_ID=validAssets_rec.instance_id;

751: l_transaction_type_id:=p_transaction_type_id;
752:
753: BEGIN
754: select INV_LOCATOR_ID INTO l_current_locator_id
755: from csi_item_instances where INSTANCE_ID=validAssets_rec.instance_id;
756: EXCEPTION
757: WHEN NO_DATA_FOUND THEN
758: l_current_locator_id:=NULL;
759: END;

Line 802: -- SELECT INVENTORY_REVISION INTO l_Item_Revision FROM CSI_ITEM_INSTANCES WHERE INVENTORY_ITEM_ID=p_inventory_item_id ;

798: END IF;
799: -- l_Transaction_UOM:='Ea';
800: --Dbms_Output.put_line('ecxeption occured while selecting');
801: END;
802: -- SELECT INVENTORY_REVISION INTO l_Item_Revision FROM CSI_ITEM_INSTANCES WHERE INVENTORY_ITEM_ID=p_inventory_item_id ;
803: SELECT mtl_material_transactions_s.nextval
804: INTO l_temp_header_id
805: FROM dual;
806: --dbms_output.put_line('l_serial_number_control_code IS'||' '||l_serial_number_control_code);

Line 809: FROM csi_item_instances

805: FROM dual;
806: --dbms_output.put_line('l_serial_number_control_code IS'||' '||l_serial_number_control_code);
807: Begin
808: SELECT inventory_item_id INTO l_inventory_item_id
809: FROM csi_item_instances
810: WHERE instance_id = validAssets_rec.instance_id;
811: exception
812: when no_data_found then
813: raise no_data_found;