APPS.WSH_AUTO_MANIFEST dependencies on WSH_DELIVERY_DETAILS

Line 215: , wsh_delivery_details wdd

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
219: AND wnd.pending_advice_flag = 'Y'

Line 266: , wsh_delivery_details wdd

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
270: --R12.1.1 STANDALONE PROJECT

Line 319: FROM wsh_delivery_details wdd,

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

Line 368: FROM wsh_delivery_details wdd,

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

Line 1102: FROM wsh_delivery_details wdd,

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

Line 1178: FROM wsh_delivery_details wdd,

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

Line 1189: FROM wsh_delivery_details wdd,

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

Line 1200: FROM wsh_delivery_details wdd,

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