[Home] [Help]
2: /* $Header: RCVTXLSB.pls 120.2 2005/06/21 18:57:50 wkunz noship $*/
3:
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
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
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
42: IF (use_mtl_lot = 2 OR use_mtl_serial = 2) THEN
43:
44: X_progress := '010';
45:
46: INSERT INTO rcv_lots_interface (
47: INTERFACE_TRANSACTION_ID,
48: LAST_UPDATE_DATE,
49: LAST_UPDATED_BY,
50: CREATION_DATE,
61: PRIMARY_QUANTITY,
62: ITEM_ID,
63: SHIPMENT_LINE_ID,
64: --Bug Fix # 1548597.
65: --Added the following Columns to Insert them into RCV_LOTS_INTERFACE.
66: SECONDARY_QUANTITY,
67: SUBLOT_NUM
68: --End of Modification for Bug # 1548597.
69: )
84: mtlt.primary_quantity,
85: rti.item_id,
86: rti.shipment_line_id,
87: --Bug Fix # 1548597.
88: --Added the following Columns to Insert into RCV_LOTS_INTERFACE table.
89: mtlt.secondary_quantity,
90: mtlt.sublot_num
91: --End of Modification for Bug # 1548597.
92: FROM rcv_transactions_interface rti,