[Home] [Help]
602: , mtlt.lot_expiration_date
603: , mtlt.primary_quantity
604: , rti.item_id
605: , rti.shipment_line_id
606: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt
607: WHERE rti.interface_transaction_id = p_interface_transaction_id
608: AND mtlt.transaction_temp_id = rti.interface_transaction_id;
609:
610: -- Bug 2458540
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;
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
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