DBA Data[Home] [Help]

APPS.WSH_CUSTOM_PUB dependencies on MTL_SYSTEM_ITEMS

Line 182: mtl_system_items msi

178: FROM
179: wsh_delivery_details wdd,
180: wsh_delivery_assignments wda,
181: wsh_new_deliveries wnd,
182: mtl_system_items msi
183: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
184: AND wda.delivery_id = wnd.delivery_id
185: AND wnd.status_code in ('IT','CL')
186: AND wnd.initial_pickup_date > p_last_notif_date

Line 282: mtl_system_items msi

278: FROM
279: wsh_delivery_details wdd,
280: wsh_delivery_assignments wda,
281: wsh_new_deliveries wnd,
282: mtl_system_items msi
283: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
284: AND wdd.date_scheduled < sysdate
285: --AND wdd.date_scheduled > p_last_notif_date
286: --AND wdd.released_status != 'C'