[Home] [Help]
4: /*=============================================================================
5: Name: create_rcv_lotserial
6: Desc: Create the necessary rcv_lots_interface and rcv_serials_interface
7: rows based on the rows created in the mtl_transactions_lots_temp
8: and the mtl_serial_numbers_temp table.
9: There is an issue here between v10 and 10sc.
10: In 10 we inserted rows into the rcv_lots_interface
11: and rcv_serials_interface tables through the
12: lot and serial forms. In 10sc we are using the Inventory lot and
10: In 10 we inserted rows into the rcv_lots_interface
11: and rcv_serials_interface tables through the
12: lot and serial forms. In 10sc we are using the Inventory lot and
13: serial forms which insert into the mtl_transaction_lots_temp and
14: the mtl_serial_numbers_temp table. The issue here is that if the
15: transaction_interface row was created by a 10 client then we want
16: to continue to insert into the mtl_ tables. If this trx was
17: generated through a 10sc client then we need to insert into the
18: 10sc tables. We are adding a flag use_mtl_lot_serial that is null
147: rti.vendor_lot_num,
148: rti.item_id,
149: rti.to_organization_id
150: FROM rcv_transactions_interface rti,
151: mtl_serial_numbers_temp mtst
152: WHERE rti.interface_transaction_id = interface_trx_id
153: AND mtst.transaction_temp_id = rti.interface_transaction_id;
154:
155: /*
204: rti.item_id,
205: rti.to_organization_id
206: FROM rcv_transactions_interface rti,
207: mtl_transaction_lots_temp mtlt,
208: mtl_serial_numbers_temp mtst
209: WHERE rti.interface_transaction_id = interface_trx_id
210: AND mtlt.transaction_temp_id = rti.interface_transaction_id
211: AND mtlt.SERIAL_TRANSACTION_TEMP_ID =
212: mtst.transaction_temp_id;