APPS.WMS_MDC_PVT dependencies on WSH_DELIVERY_LEGS

Line 943: FROM wsh_delivery_legs l1, --_ob_grp_v l1,

939: AND NOT exists (SELECT 1
940: FROM wms_lpn_contents wlc
941: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
942: AND wda.delivery_id IN (SELECT l2.delivery_id
943: FROM wsh_delivery_legs l1, --_ob_grp_v l1,
944: wsh_delivery_legs l2 --_ob_grp_v l2
945: WHERE l1.delivery_id = l_from_delivery_id
946: AND l1.parent_delivery_leg_id = l2.parent_delivery_leg_id)
947: --- above sub query: that this del is a prt of a consol

Line 944: wsh_delivery_legs l2 --_ob_grp_v l2

940: FROM wms_lpn_contents wlc
941: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
942: AND wda.delivery_id IN (SELECT l2.delivery_id
943: FROM wsh_delivery_legs l1, --_ob_grp_v l1,
944: wsh_delivery_legs l2 --_ob_grp_v l2
945: WHERE l1.delivery_id = l_from_delivery_id
946: AND l1.parent_delivery_leg_id = l2.parent_delivery_leg_id)
947: --- above sub query: that this del is a prt of a consol
948: ORDER BY wdth.creation_date DESC)

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

Line 1109: FROM wsh_delivery_legs --_ob_grp_v

1105: l_part_of_consol_delivery := NULL;
1106: BEGIN
1107: SELECT 'Y'
1108: INTO l_part_of_consol_delivery
1109: FROM wsh_delivery_legs --_ob_grp_v
1110: WHERE delivery_id = p_delivery_id
1111: AND PARENT_DELIVERY_LEG_ID IS NOT NULL
1112: AND ROWNUM = 1;
1113: EXCEPTION