APPS.EAM_ASSET_MOVE_PUB dependencies on CSI_ITEM_INSTANCES

Line 56: FROM CSI_ITEM_INSTANCES

52:
53: BEGIN
54: SELECT inventory_item_id
55: INTO l_Parent_inventory_item_id
56: FROM CSI_ITEM_INSTANCES
57: WHERE instance_id=p_parent_instance_id ;
58:
59: IF (l_ulog) THEN
60: l_module := 'eam.plsql.'|| l_full_name;

Line 244: csi_item_instances cii ,

240: mp.MAINT_ORGANIZATION_ID
241: FROM mtl_serial_numbers msn ,
242: mtl_object_genealogy mog,
243: mtl_system_items_b msi ,
244: csi_item_instances cii ,
245: mtl_parameters mp
246: WHERE mog.object_id = msn.gen_object_id
247: AND msn.current_organization_id = msi.organization_id
248: --AND msn.current_organization_id = p_current_org_id

Line 279: csi_item_instances cii

275: BEGIN
276: SELECT msn.GEN_OBJECT_ID
277: INTO l_parent_object_id
278: FROM mtl_serial_numbers msn,
279: csi_item_instances cii
280: WHERE cii.instance_id =p_parent_instance_id
281: AND cii.serial_number=msn.serial_number
282: AND cii.inventory_item_id=msn.inventory_item_id; --Added for 6955393
283: EXCEPTION

Line 312: FROM CSI_ITEM_INSTANCES cii,

308: mp.MAINT_ORGANIZATION_ID ,
309: NULL ,
310: NULL
311: INTO l_parent_inf_rec
312: FROM CSI_ITEM_INSTANCES cii,
313: MTL_PARAMETERS mp ,
314: MTL_SERIAL_NUMBERS msn,
315: MTL_SYSTEM_ITEMS_B msi
316: WHERE cii.instance_id =p_parent_instance_id

Line 540: l_Item_Revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;

536: l_txn_if_id NUMBER;
537: l_SERIAL_NUMBER VARCHAR2(30);
538: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;
539: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;
540: l_Item_Revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;
541: l_Transaction_Quantity NUMBER;
542: x_Message VARCHAR2(240);
543: x_Status VARCHAR2(30);
544: l_lot_control_code NUMBER;

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

737: l_transaction_type_id:=p_transaction_type_id;
738:
739: BEGIN
740: select INV_LOCATOR_ID INTO l_current_locator_id
741: from csi_item_instances where INSTANCE_ID=validAssets_rec.instance_id;
742: EXCEPTION
743: WHEN NO_DATA_FOUND THEN
744: l_current_locator_id:=NULL;
745: END;

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

780: WHEN NO_DATA_FOUND THEN
781: l_Transaction_UOM:='Ea';
782: --Dbms_Output.put_line('ecxeption occured while selecting');
783: END;
784: -- SELECT INVENTORY_REVISION INTO l_Item_Revision FROM CSI_ITEM_INSTANCES WHERE INVENTORY_ITEM_ID=p_inventory_item_id ;
785: SELECT mtl_material_transactions_s.nextval
786: INTO l_temp_header_id
787: FROM dual;
788: --dbms_output.put_line('l_serial_number_control_code IS'||' '||l_serial_number_control_code);

Line 791: FROM csi_item_instances

787: FROM dual;
788: --dbms_output.put_line('l_serial_number_control_code IS'||' '||l_serial_number_control_code);
789: Begin
790: SELECT inventory_item_id INTO l_inventory_item_id
791: FROM csi_item_instances
792: WHERE instance_id = validAssets_rec.instance_id;
793: exception
794: when no_data_found then
795: raise no_data_found;