APPS.WSH_AUTO_MANIFEST dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 214: , wsh_delivery_assignments_v wdav

210: ,wnd.carrier_id
211: ,wnd.customer_id
212: ,wnd.ultimate_dropoff_location_id ship_to_id
213: FROM wsh_new_deliveries wnd
214: , wsh_delivery_assignments_v wdav
215: , wsh_delivery_details wdd
216: WHERE nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')
217: AND wdav.delivery_id = wnd.delivery_id
218: AND wdd.delivery_detail_id = wdav.delivery_detail_id

Line 265: , wsh_delivery_assignments_v wdav

261: ,wnd.customer_id
262: ,wnd.ultimate_dropoff_location_id ship_to_id
263: FROM wsh_new_deliveries wnd
264: , wsh_transactions_history wth
265: , wsh_delivery_assignments_v wdav
266: , wsh_delivery_details wdd
267: WHERE nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')
268: AND wdav.delivery_id = wnd.delivery_id
269: AND wdd.delivery_detail_id = wdav.delivery_detail_id

Line 320: wsh_delivery_assignments_v wda,

316: ,wnd.carrier_id
317: ,wnd.customer_id
318: ,wnd.ultimate_dropoff_location_id ship_to_id
319: FROM wsh_delivery_details wdd,
320: wsh_delivery_assignments_v wda,
321: wsh_new_deliveries wnd,
322: mtl_parameters mtl,
323: wsh_carriers wc
324: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 369: wsh_delivery_assignments_v wda,

365: ,wnd.carrier_id
366: ,wnd.customer_id
367: ,wnd.ultimate_dropoff_location_id ship_to_id
368: FROM wsh_delivery_details wdd,
369: wsh_delivery_assignments_v wda,
370: wsh_new_deliveries wnd,
371: mtl_parameters mtl
372: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
373: AND wda.delivery_id = wnd.delivery_id

Line 1103: wsh_delivery_assignments_v wda,

1099:
1100: CURSOR c_lock_delivery IS
1101: SELECT wnd.delivery_id, wnd.status_code
1102: FROM wsh_delivery_details wdd,
1103: wsh_delivery_assignments_v wda,
1104: wsh_new_deliveries wnd
1105: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1106: AND wda.delivery_id = wnd.delivery_id
1107: AND wdd.container_flag = 'N'

Line 1179: wsh_delivery_assignments_v wda

1175: l_count NUMBER;
1176: CURSOR c1 IS
1177: SELECT count(*)
1178: FROM wsh_delivery_details wdd,
1179: wsh_delivery_assignments_v wda
1180: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1181: AND wda.delivery_id = p_delivery_id
1182: AND wdd.container_flag = 'N'
1183: AND wdd.released_status in ('X','Y')

Line 1190: wsh_delivery_assignments_v wda

1186:
1187: CURSOR c2 IS
1188: SELECT count(*)
1189: FROM wsh_delivery_details wdd,
1190: wsh_delivery_assignments_v wda
1191: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1192: AND wda.delivery_id = p_delivery_id
1193: AND wdd.container_flag = 'N'
1194: AND wdd.released_status in ('X','Y')

Line 1201: wsh_delivery_assignments_v wda

1197:
1198: CURSOR c3 IS
1199: SELECT count(*)
1200: FROM wsh_delivery_details wdd,
1201: wsh_delivery_assignments_v wda
1202: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1203: AND wda.delivery_id = p_delivery_id
1204: AND wdd.container_flag = 'N'
1205: AND wdd.released_status in ('X','Y')