eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_RETURN_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 243: FROM rcv_transactions_interface rti

239: rti.primary_quantity * -1,
240: rti.primary_quantity )
241: ),0)
242: INTO x_primary_interface_qty
243: FROM rcv_transactions_interface rti
244: WHERE rti.parent_transaction_id = x_transaction_id
245: AND rti.processing_status_code in ('PENDING' , 'WSH_INTERFACED') -- rtv vidya
246: AND rti.transaction_status_code = 'PENDING'
247: -- rtv project : start

Line 286: FROM rcv_transactions_interface rti

282: ** Determine the sum of the transactions in the interface table
283: */
284: SELECT nvl(sum(rti.primary_quantity),0)
285: INTO x_primary_interface_qty
286: FROM rcv_transactions_interface rti
287: WHERE rti.parent_transaction_id = x_transaction_id
288: AND rti.processing_status_code = 'PENDING'
289: AND rti.transaction_status_code = 'PENDING';
290: /*