[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