DBA Data[Home] [Help]

APPS.WSH_CUSTOM_PUB dependencies on MTL_SYSTEM_ITEMS

Line 176: mtl_system_items msi

172: FROM
173: wsh_delivery_details wdd,
174: wsh_delivery_assignments wda,
175: wsh_new_deliveries wnd,
176: mtl_system_items msi
177: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
178: AND wda.delivery_id = wnd.delivery_id
179: AND wnd.status_code in ('IT','CL')
180: AND wnd.initial_pickup_date > p_last_notif_date

Line 276: mtl_system_items msi

272: FROM
273: wsh_delivery_details wdd,
274: wsh_delivery_assignments wda,
275: wsh_new_deliveries wnd,
276: mtl_system_items msi
277: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
278: AND wdd.date_scheduled < sysdate
279: --AND wdd.date_scheduled > p_last_notif_date
280: --AND wdd.released_status != 'C'