[Home] [Help]
651: , NULL
652: , rti.vendor_lot_num
653: , rti.item_id
654: , rti.to_organization_id
655: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp mtst
656: WHERE rti.interface_transaction_id = p_interface_transaction_id
657: AND mtlt.transaction_temp_id = rti.interface_transaction_id
658: AND mtlt.serial_transaction_temp_id = mtst.transaction_temp_id;
659: END IF;
705: , NULL
706: , rti.vendor_lot_num
707: , rti.item_id
708: , rti.to_organization_id
709: FROM rcv_transactions_interface rti, mtl_serial_numbers_temp mtst
710: WHERE rti.interface_transaction_id = p_interface_transaction_id
711: AND mtst.transaction_temp_id = rti.interface_transaction_id;
712: END IF;
713: END IF;
1451: g_interface_transaction_id := l_interface_transaction_id;
1452:
1453: -- Create the necessary rcv_lots_interface and rcv_serials_interface
1454: -- rows based on the rows created in the mtl_transactions_lots_temp
1455: -- and the mtl_serial_numbers_temp table.
1456: -- There is an issue here between v10 and 10sc.
1457: -- In 10 we inserted rows into the rcv_lots_interface
1458: -- and rcv_serials_interface tables through the
1459: -- lot and serial forms. In 10sc we are using the Inventory lot and
1457: -- In 10 we inserted rows into the rcv_lots_interface
1458: -- and rcv_serials_interface tables through the
1459: -- lot and serial forms. In 10sc we are using the Inventory lot and
1460: -- serial forms which insert into the mtl_transaction_lots_temp and
1461: -- the mtl_serial_numbers_temp table. The issue here is that if the
1462: -- transaction_interface row was created by a 10 client then we want
1463: -- to continue to insert into the mtl_ tables. If this trx was
1464: -- generated through a 10sc client then we need to insert into the
1465: -- 10sc tables. We are adding a flag use_mtl_lot_serial that is null
3332: IF (p_lot_control_code > 1 AND p_serial_control_code = 6) THEN
3333: BEGIN
3334: SELECT count(1)
3335: INTO l_msni_count
3336: FROM mtl_serial_numbers_interface
3337: WHERE product_transaction_id = p_transaction_temp_id
3338: AND product_code = 'RCV';
3339:
3340: IF (l_debug = 1) THEN
5392:
5393: --Get the serial status
5394: SELECT status_id
5395: INTO l_serial_status_id
5396: FROM mtl_serial_numbers
5397: WHERE serial_number = p_serial_number
5398: AND inventory_item_id = p_item_id;
5399:
5400: --Call the insert_msni API
5485: rcv_transactions rt,
5486: rcv_serials_supply rss,
5487: rcv_shipment_lines rsl,
5488: rcv_shipment_headers rsh,
5489: mtl_serial_numbers_interface msni
5490: WHERE rs.item_id = p_item_id
5491: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5492: AND (p_revision is null or rs.item_revision = p_revision)
5493: AND rs.to_organization_id = p_organization_id