APPS.WSH_AUTO_MANIFEST dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 191: , wsh_delivery_assignments_v wdav

187: ,wnd.customer_id
188: ,wnd.ultimate_dropoff_location_id ship_to_id
189: FROM wsh_new_deliveries wnd
190: , wsh_transactions_history wth
191: , wsh_delivery_assignments_v wdav
192: , wsh_delivery_details wdd
193: WHERE nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')
194: AND wdav.delivery_id = wnd.delivery_id
195: AND wdd.delivery_detail_id = wdav.delivery_detail_id

Line 235: wsh_delivery_assignments_v wda,

231: ,wnd.carrier_id
232: ,wnd.customer_id
233: ,wnd.ultimate_dropoff_location_id ship_to_id
234: FROM wsh_delivery_details wdd,
235: wsh_delivery_assignments_v wda,
236: wsh_new_deliveries wnd,
237: mtl_parameters mtl,
238: wsh_carriers wc
239: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 275: wsh_delivery_assignments_v wda,

271: ,wnd.carrier_id
272: ,wnd.customer_id
273: ,wnd.ultimate_dropoff_location_id ship_to_id
274: FROM wsh_delivery_details wdd,
275: wsh_delivery_assignments_v wda,
276: wsh_new_deliveries wnd,
277: mtl_parameters mtl
278: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
279: AND wda.delivery_id = wnd.delivery_id

Line 930: wsh_delivery_assignments_v wda,

926:
927: CURSOR c_lock_delivery IS
928: SELECT wnd.delivery_id, wnd.status_code
929: FROM wsh_delivery_details wdd,
930: wsh_delivery_assignments_v wda,
931: wsh_new_deliveries wnd
932: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
933: AND wda.delivery_id = wnd.delivery_id
934: AND wdd.container_flag = 'N'

Line 1006: wsh_delivery_assignments_v wda

1002: l_count NUMBER;
1003: CURSOR c1 IS
1004: SELECT count(*)
1005: FROM wsh_delivery_details wdd,
1006: wsh_delivery_assignments_v wda
1007: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1008: AND wda.delivery_id = p_delivery_id
1009: AND wdd.container_flag = 'N'
1010: AND wdd.released_status in ('X','Y')

Line 1017: wsh_delivery_assignments_v wda

1013:
1014: CURSOR c2 IS
1015: SELECT count(*)
1016: FROM wsh_delivery_details wdd,
1017: wsh_delivery_assignments_v wda
1018: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1019: AND wda.delivery_id = p_delivery_id
1020: AND wdd.container_flag = 'N'
1021: AND wdd.released_status in ('X','Y')

Line 1028: wsh_delivery_assignments_v wda

1024:
1025: CURSOR c3 IS
1026: SELECT count(*)
1027: FROM wsh_delivery_details wdd,
1028: wsh_delivery_assignments_v wda
1029: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1030: AND wda.delivery_id = p_delivery_id
1031: AND wdd.container_flag = 'N'
1032: AND wdd.released_status in ('X','Y')