[Home] [Help]
541: , p_serial_control_code);
542:
543: IF p_lot_control_code = 2 THEN
544: -- it is lot controlled so lots must be inserted into lots temp table
545: INSERT INTO rcv_lots_interface
546: (
547: interface_transaction_id
548: , last_update_date
549: , last_updated_by
1415: --Store the interface_transaction_id in a global variable which would later
1416: --be used for splitting lots and serials
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
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
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