DBA Data[Home] [Help]

APPS.RCV_LOT_SERIAL_SV dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 13: serial forms which insert into the mtl_transaction_lots_temp and

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
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

Line 93: mtl_transaction_lots_temp mtlt

89: mtlt.secondary_quantity,
90: mtlt.sublot_num
91: --End of Modification for Bug # 1548597.
92: FROM rcv_transactions_interface rti,
93: mtl_transaction_lots_temp mtlt
94: WHERE rti.interface_transaction_id = interface_trx_id
95: AND mtlt.transaction_temp_id = rti.interface_transaction_id;
96:
97: END IF;

Line 207: mtl_transaction_lots_temp mtlt,

203: rti.vendor_lot_num,
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 =