[Home] [Help]
245: cii.INV_SUBINVENTORY_NAME ,
246: cii.maintainable_flag ,
247: msi.eam_item_type ,
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
287:
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
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
330: AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER
331: AND mp.organization_id =cii.last_vld_organization_id
480: AND START_DATE_ACTIVE<=SYSDATE
481: AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate
482: AND PARENT_OBJECT_TYPE = 2; --Added for the bug 7721062
483: --can use the below statement as well for filtering out the records
484: --AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)
485: IF (l_slog) then
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'parent objectId for validating the child assest is '||l_parent_object_id);
487: END IF;
488:
1401: p_batch_transaction_id,
1402: 1
1403: );
1404:
1405: INSERT INTO mtl_serial_numbers_interface
1406: (transaction_interface_id,
1407: SOURCE_CODE,
1408: SOURCE_LINE_ID,
1409: last_update_date,
1464: l_txn_action_id := 1;
1465: l_txn_SOURCE_TYPE_ID := 13 ;
1466: l_TRANSACTION_BATCH_SEQ := 3;
1467:
1468: -- Please add your code to insert the values into mtl_transactions_interface and mtl_serial_numbers_interface
1469: -- for performing the miscellaneous Issue Transaction
1470:
1471: --****** Important****
1472: