APPS.OE_SET_UTIL dependencies on WSH_NEW_DELIVERIES

Line 162: FROM wsh_delivery_assignments wda, wsh_new_deliveries wnd

158: AND wdd.source_code = 'OE'
159: AND wdd.source_header_id = p_line_rec.header_id
160: AND ((wdd.released_status = 'C')
161: OR EXISTS (select wda.delivery_detail_id
162: FROM wsh_delivery_assignments wda, wsh_new_deliveries wnd
163: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
164: AND wda.delivery_id = wnd.delivery_id
165: AND wnd.status_code in ('CO', 'IT', 'CL', 'SA')))
166: AND rownum = 1;