eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_MDC_PVT dependencies on WSH_DELIVERY_LEGS

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

902: AND NOT exists (SELECT 1
903: FROM wms_lpn_contents wlc
904: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
905: AND wda.delivery_id IN (SELECT l2.delivery_id
906: FROM wsh_delivery_legs l1, --_ob_grp_v l1,
907: wsh_delivery_legs l2 --_ob_grp_v l2
908: WHERE l1.delivery_id = l_from_delivery_id
909: AND l1.parent_delivery_leg_id = l2.parent_delivery_leg_id)
910: --- above sub query: that this del is a prt of a consol

Line 907: wsh_delivery_legs l2 --_ob_grp_v l2

903: FROM wms_lpn_contents wlc
904: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
905: AND wda.delivery_id IN (SELECT l2.delivery_id
906: FROM wsh_delivery_legs l1, --_ob_grp_v l1,
907: wsh_delivery_legs l2 --_ob_grp_v l2
908: WHERE l1.delivery_id = l_from_delivery_id
909: AND l1.parent_delivery_leg_id = l2.parent_delivery_leg_id)
910: --- above sub query: that this del is a prt of a consol
911: ORDER BY wdth.creation_date DESC)

Line 953: FROM wsh_delivery_legs_ob_grp_v l1

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

Line 954: , wsh_delivery_legs_ob_grp_v l2

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

Line 1072: FROM wsh_delivery_legs --_ob_grp_v

1068: l_part_of_consol_delivery := NULL;
1069: BEGIN
1070: SELECT 'Y'
1071: INTO l_part_of_consol_delivery
1072: FROM wsh_delivery_legs --_ob_grp_v
1073: WHERE delivery_id = p_delivery_id
1074: AND PARENT_DELIVERY_LEG_ID IS NOT NULL
1075: AND ROWNUM = 1;
1076: EXCEPTION