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_DELIVERY_ASSIGNMENTS

Line 3222: wsh_delivery_assignments wda,

3218: CURSOR c_delivery_line_info(c_line_id NUMBER)
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

Line 5765: wsh_delivery_assignments wda,

5761: BEGIN
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

Line 7137: from wsh_delivery_assignments wda,

7133: and source_line_id = l_line_id
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 )