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 WSH_DELIVERY_DETAILS

Line 248: AND NOT EXISTS (select 1 from wsh_delivery_details wdd

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
248: AND NOT EXISTS (select 1 from wsh_delivery_details wdd
249: where wdd.delivery_detail_id = rti.interface_source_line_id
250: and wdd.source_code = 'RTV'
251: and rti.transaction_type = 'RETURN TO VENDOR'
252: and rti.processing_status_code = 'PENDING');