APPS.WMS_MDC_PVT dependencies on WSH_TRIP_STOPS_OB_GRP_V

Line 992: , wsh_trip_stops_ob_grp_v s

988: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
989: AND wda.delivery_id IN (SELECT l2.delivery_id
990: FROM wsh_delivery_legs_ob_grp_v l1
991: , wsh_delivery_legs_ob_grp_v l2
992: , wsh_trip_stops_ob_grp_v s
993: , wsh_new_deliveries_ob_grp_v d
994: WHERE d.delivery_id = l_from_delivery_id
995: AND d.initial_pickup_location_id = s.stop_location_id
996: AND d.delivery_id = l1.delivery_id