APPS.RCV_LOT_SERIAL_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 27: Algr: update rcv_transactions_interface to set new status

23: IN: status - New status of the transaction
24: Reqs:
25: Mods:
26: Err : return(FALSE) on error. Error messages returned on AOL message stack
27: Algr: update rcv_transactions_interface to set new status
28: Note:
29: =============================================================================*/
30: PROCEDURE create_rcv_lotserial(interface_trx_id IN NUMBER,
31: use_mtl_lot IN NUMBER,

Line 92: FROM rcv_transactions_interface rti,

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

Line 150: FROM rcv_transactions_interface rti,

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

Line 206: FROM rcv_transactions_interface rti,

202: null,
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