DBA Data[Home] [Help]

APPS.WSH_WF dependencies on MTL_SYSTEM_ITEMS

Line 278: mtl_system_items msi

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')
282: AND wnd.initial_pickup_date > p_last_notif_date

Line 306: mtl_system_items msi

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
310: AND nvl(wdd.picked_quantity, wdd.requested_quantity) > 0