APPS.WSH_WF dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 276: wsh_delivery_assignments_v wda,

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
280: AND wda.delivery_id = wnd.delivery_id

Line 304: wsh_delivery_assignments_v wda,

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
308: AND wdd.date_scheduled < sysdate

Line 500: wsh_delivery_assignments_v wda,

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 (+)
504: AND nvl(wnd.status_code,'XX') not in ('IT','CL')

Line 955: wsh_delivery_assignments_v wda

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
959: AND wdd.source_code = 'OE';