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_WF dependencies on WSH_NEW_DELIVERIES

Line 277: wsh_new_deliveries wnd,

273: wdd.delivery_detail_id
274: FROM
275: wsh_delivery_details wdd,
276: wsh_delivery_assignments_v wda,
277: wsh_new_deliveries wnd,
278: mtl_system_items msi
279: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
280: AND wda.delivery_id = wnd.delivery_id
281: AND wnd.status_code in ('IT','CL')

Line 305: wsh_new_deliveries wnd,

301: wdd.delivery_detail_id
302: FROM
303: wsh_delivery_details wdd,
304: wsh_delivery_assignments_v wda,
305: wsh_new_deliveries wnd,
306: mtl_system_items msi
307: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
308: AND wdd.date_scheduled < sysdate
309: --AND wdd.date_scheduled > p_last_notif_date

Line 501: wsh_new_deliveries wnd

497: SELECT wdd.delivery_detail_id
498: FROM
499: wsh_delivery_details wdd,
500: wsh_delivery_assignments_v wda,
501: wsh_new_deliveries wnd
502: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
503: AND wda.delivery_id = wnd.delivery_id (+)
504: AND nvl(wnd.status_code,'XX') not in ('IT','CL')
505: AND wdd.source_header_id = p_source_header_id