[Home] [Help]
627: , NULL
628: , rti.vendor_lot_num
629: , rti.item_id
630: , rti.to_organization_id
631: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp mtst
632: WHERE rti.interface_transaction_id = p_interface_transaction_id
633: AND mtlt.transaction_temp_id = rti.interface_transaction_id
634: AND mtlt.serial_transaction_temp_id = mtst.transaction_temp_id;
635: END IF;
681: , NULL
682: , rti.vendor_lot_num
683: , rti.item_id
684: , rti.to_organization_id
685: FROM rcv_transactions_interface rti, mtl_serial_numbers_temp mtst
686: WHERE rti.interface_transaction_id = p_interface_transaction_id
687: AND mtst.transaction_temp_id = rti.interface_transaction_id;
688: END IF;
689: END IF;
1417: g_interface_transaction_id := l_interface_transaction_id;
1418:
1419: -- Create the necessary rcv_lots_interface and rcv_serials_interface
1420: -- rows based on the rows created in the mtl_transactions_lots_temp
1421: -- and the mtl_serial_numbers_temp table.
1422: -- There is an issue here between v10 and 10sc.
1423: -- In 10 we inserted rows into the rcv_lots_interface
1424: -- and rcv_serials_interface tables through the
1425: -- lot and serial forms. In 10sc we are using the Inventory lot and
1423: -- In 10 we inserted rows into the rcv_lots_interface
1424: -- and rcv_serials_interface tables through the
1425: -- lot and serial forms. In 10sc we are using the Inventory lot and
1426: -- serial forms which insert into the mtl_transaction_lots_temp and
1427: -- the mtl_serial_numbers_temp table. The issue here is that if the
1428: -- transaction_interface row was created by a 10 client then we want
1429: -- to continue to insert into the mtl_ tables. If this trx was
1430: -- generated through a 10sc client then we need to insert into the
1431: -- 10sc tables. We are adding a flag use_mtl_lot_serial that is null
3236: IF (p_lot_control_code > 1 AND p_serial_control_code = 6) THEN
3237: BEGIN
3238: SELECT count(1)
3239: INTO l_msni_count
3240: FROM mtl_serial_numbers_interface
3241: WHERE product_transaction_id = p_transaction_temp_id
3242: AND product_code = 'RCV';
3243:
3244: IF (l_debug = 1) THEN
5270:
5271: --Get the serial status
5272: SELECT status_id
5273: INTO l_serial_status_id
5274: FROM mtl_serial_numbers
5275: WHERE serial_number = p_serial_number
5276: AND inventory_item_id = p_item_id;
5277:
5278: --Call the insert_msni API
5363: rcv_transactions rt,
5364: rcv_serials_supply rss,
5365: rcv_shipment_lines rsl,
5366: rcv_shipment_headers rsh,
5367: mtl_serial_numbers_interface msni
5368: WHERE rs.item_id = p_item_id
5369: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5370: AND (p_revision is null or rs.item_revision = p_revision)
5371: AND rs.to_organization_id = p_organization_id