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_DELIVERY_DETAILS

Line 275: wsh_delivery_details wdd,

271: p_last_notif_date in date) is
272: SELECT
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

Line 303: wsh_delivery_details wdd,

299: p_last_notif_date in date) is
300: SELECT
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

Line 499: wsh_delivery_details wdd,

495: p_contact_type in varchar2,
496: p_contact_id in number) is
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 (+)

Line 954: wsh_delivery_details wdd,

950: 'SOLD_TO'),
951: 'SHIP_TO') contact_type,
952: nvl(wdd.ship_to_contact_id,nvl(wdd.sold_to_contact_id,wdd.customer_id)) contact_id
953: FROM
954: wsh_delivery_details wdd,
955: wsh_delivery_assignments_v wda
956: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
957: AND wda.delivery_id = p_delivery_id
958: AND wda.delivery_id IS NOT NULL