APPS.WMS_SHIPPING_PUB dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 38: FROM wsh_delivery_assignments_v

34:
35: CURSOR get_delivery_detail_id (l_delivery_id NUMBER)
36: IS
37: SELECT delivery_detail_id
38: FROM wsh_delivery_assignments_v
39: WHERE delivery_id = l_delivery_id;
40: CURSOR get_lpn_id (l_delivery_detail_id NUMBER)
41: IS
42: SELECT DISTINCT outermost_lpn_id

Line 117: wsh_delivery_assignments_v wda

113: AND transfer_lpn_id IN
114: (SELECT wlpn.outermost_lpn_id
115: FROM wms_license_plate_numbers wlpn,
116: wsh_delivery_details wdd,
117: wsh_delivery_assignments_v wda
118: WHERE wda.delivery_detail_id = l_delivery_detail_id
119: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
120: AND wdd.lpn_id = wlpn.lpn_id);
121: IF l_debug = 1 THEN debug('Deleted Staging move WDTs ' || l_delivery_detail_id); END IF;

Line 135: wsh_delivery_assignments_v wda

131: AND content_lpn_id IN
132: ( SELECT wlpn.outermost_lpn_id
133: FROM wms_license_plate_numbers wlpn,
134: wsh_delivery_details wdd,
135: wsh_delivery_assignments_v wda
136: WHERE wda.delivery_detail_id = l_delivery_detail_id
137: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
138: AND wdd.lpn_id = wlpn.lpn_id);
139: IF l_debug = 1 THEN debug('Deleted Staging move MMTT ' || l_delivery_detail_id); END IF;