APPS.WSH_AUTO_MANIFEST dependencies on WSH_DELIVERY_DETAILS

Line 192: , wsh_delivery_details wdd

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
196: AND ((p_src_header_num_from IS NOT NULL

Line 234: FROM wsh_delivery_details wdd,

230: ,wnd.delivery_id
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

Line 274: FROM wsh_delivery_details wdd,

270: wnd.delivery_id
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

Line 929: FROM wsh_delivery_details wdd,

925: l_status_code VARCHAR2(10);
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

Line 1005: FROM wsh_delivery_details wdd,

1001:
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'

Line 1016: FROM wsh_delivery_details wdd,

1012: AND trunc(wdd.DATE_SCHEDULED) between trunc(p_scheduled_from_date) AND trunc(p_scheduled_to_date);
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'

Line 1027: FROM wsh_delivery_details wdd,

1023: AND trunc(wdd.DATE_SCHEDULED) >= trunc(p_scheduled_from_date);
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'