DBA Data[Home] [Help]

APPS.WSH_EXCEPTIONS_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 567: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

563:
564: -- cursor to validate delivery_detail_id
565: CURSOR C2(c_delivery_id NUMBER) IS
566: SELECT wdd.delivery_detail_id, wda.delivery_id, wda.delivery_assignment_id
567: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
568: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
569: AND ((c_delivery_id is null) or (wda.delivery_id =c_delivery_id))
570: AND wdd.delivery_detail_id = p_exception_rec.delivery_detail_id
571: AND wdd.container_flag IN ('N', 'Y'); -- R12 MDC