DBA Data[Home] [Help]

APPS.WMS_MDC_PVT dependencies on WSH_TRIP_STOPS_OB_GRP_V

Line 955: , wsh_trip_stops_ob_grp_v s

951: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
952: AND wda.delivery_id IN (SELECT l2.delivery_id
953: FROM wsh_delivery_legs_ob_grp_v l1
954: , wsh_delivery_legs_ob_grp_v l2
955: , wsh_trip_stops_ob_grp_v s
956: , wsh_new_deliveries_ob_grp_v d
957: WHERE d.delivery_id = l_from_delivery_id
958: AND d.initial_pickup_location_id = s.stop_location_id
959: AND d.delivery_id = l1.delivery_id