DBA Data[Home] [Help]

APPS.WMS_MDC_PVT dependencies on WSH_DELIVERY_LEGS_OB_GRP_V

Line 990: FROM wsh_delivery_legs_ob_grp_v l1

986: AND NOT exists (SELECT 1
987: FROM wms_lpn_contents wlc
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

Line 991: , wsh_delivery_legs_ob_grp_v l2

987: FROM wms_lpn_contents wlc
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