DBA Data[Home] [Help]

APPS.RCV_RETURN_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 242: FROM rcv_transactions_interface rti

238: rti.primary_quantity * -1,
239: rti.primary_quantity )
240: ),0)
241: INTO x_primary_interface_qty
242: FROM rcv_transactions_interface rti
243: WHERE rti.parent_transaction_id = x_transaction_id
244: AND rti.processing_status_code = 'PENDING'
245: AND rti.transaction_status_code = 'PENDING';
246: /*

Line 278: FROM rcv_transactions_interface rti

274: ** Determine the sum of the transactions in the interface table
275: */
276: SELECT nvl(sum(rti.primary_quantity),0)
277: INTO x_primary_interface_qty
278: FROM rcv_transactions_interface rti
279: WHERE rti.parent_transaction_id = x_transaction_id
280: AND rti.processing_status_code = 'PENDING'
281: AND rti.transaction_status_code = 'PENDING';
282: /*