APPS.EAM_ASSET_MOVE_PUB dependencies on MTL_SERIAL_NUMBERS

Line 241: FROM mtl_serial_numbers msn ,

237: cii.INV_SUBINVENTORY_NAME ,
238: cii.maintainable_flag ,
239: msi.eam_item_type ,
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

Line 278: FROM mtl_serial_numbers msn,

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

Line 314: MTL_SERIAL_NUMBERS msn,

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
317: AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER
318: AND mp.organization_id =cii.last_vld_organization_id

Line 471: --AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)

467: AND START_DATE_ACTIVE<=SYSDATE
468: AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate
469: AND PARENT_OBJECT_TYPE = 2; --Added for the bug 7721062
470: --can use the below statement as well for filtering out the records
471: --AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)
472: IF (l_slog) then
473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'parent objectId for validating the child assest is '||l_parent_object_id);
474: END IF;
475:

Line 1265: INSERT INTO mtl_serial_numbers_interface

1261: p_batch_transaction_id,
1262: 1
1263: );
1264:
1265: INSERT INTO mtl_serial_numbers_interface
1266: (transaction_interface_id,
1267: SOURCE_CODE,
1268: SOURCE_LINE_ID,
1269: last_update_date,