APPS.OE_VALIDATE_LINE dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 815: FROM wsh_delivery_assignments wda, wsh_new_deliveries wnd

811: AND wdd.source_code = 'OE'
812: AND wdd.source_header_id = p_line_rec.header_id
813: AND ((wdd.released_status = 'C')
814: OR EXISTS (select wda.delivery_detail_id
815: FROM wsh_delivery_assignments wda, wsh_new_deliveries wnd
816: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
817: AND wda.delivery_id = wnd.delivery_id
818: AND wnd.status_code in ('CO', 'IT', 'CL', 'SA')))
819: AND rownum = 1;