APPS.OE_VALIDATE_LINE dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 791: FROM wsh_delivery_assignments wda, wsh_new_deliveries wnd

787: AND wdd.source_code = 'OE'
788: AND wdd.source_header_id = p_line_rec.header_id
789: AND ((wdd.released_status = 'C')
790: OR EXISTS (select wda.delivery_detail_id
791: FROM wsh_delivery_assignments wda, wsh_new_deliveries wnd
792: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
793: AND wda.delivery_id = wnd.delivery_id
794: AND wnd.status_code in ('CO', 'IT', 'CL', 'SA')))
795: AND rownum = 1;