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.WSH_SHIPMENT_REQUEST_PKG dependencies on WSH_NEW_DELIVERIES

Line 3223: wsh_new_deliveries wnd

3219: IS
3220: select wdd.*
3221: from wsh_delivery_details wdd,
3222: wsh_delivery_assignments wda,
3223: wsh_new_deliveries wnd
3224: where wnd.status_code in ( 'CL', 'IT', 'CO' )
3225: and wnd.delivery_id = wda.delivery_id
3226: and wda.delivery_detail_id = wdd.delivery_detail_id
3227: and source_code = 'OE'

Line 5766: wsh_new_deliveries wnd

5762: select 'x'
5763: into l_tmp
5764: from wsh_delivery_details wdd,
5765: wsh_delivery_assignments wda,
5766: wsh_new_deliveries wnd
5767: where wnd.status_code in ( 'CO', 'IT', 'CL' )
5768: and wnd.delivery_id = wda.delivery_id
5769: and wda.delivery_detail_id = wdd.delivery_detail_id
5770: and wdd.source_code = 'OE'

Line 7138: wsh_new_deliveries wnd

7134: and released_status in ( 'Y', 'C' )
7135: and exists
7136: ( select 'y'
7137: from wsh_delivery_assignments wda,
7138: wsh_new_deliveries wnd
7139: where wnd.status_code in ( 'CO', 'IT', 'CL' )
7140: and wnd.delivery_id = wda.delivery_id
7141: and wda.delivery_detail_id = wdd.delivery_detail_id )
7142: and rownum = 1;