[Home] [Help]
565: , p_serial_control_code);
566:
567: IF p_lot_control_code = 2 THEN
568: -- it is lot controlled so lots must be inserted into lots temp table
569: INSERT INTO rcv_lots_interface
570: (
571: interface_transaction_id
572: , last_update_date
573: , last_updated_by
1449: --Store the interface_transaction_id in a global variable which would later
1450: --be used for splitting lots and serials
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
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
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