APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_TRIP_STOPS

Line 95: wsh_trip_stops wts1,

91: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments
92: WHERE delivery_id in
93: (SELECT wdl.delivery_id
94: FROM wsh_delivery_legs wdl,
95: wsh_trip_stops wts1,
96: wsh_trip_stops wts2
97: WHERE wts1.trip_id = c_trip_id
98: AND wts2.trip_id = c_trip_id
99: AND wts1.stop_id = wdl.pick_up_stop_id

Line 96: wsh_trip_stops wts2

92: WHERE delivery_id in
93: (SELECT wdl.delivery_id
94: FROM wsh_delivery_legs wdl,
95: wsh_trip_stops wts1,
96: wsh_trip_stops wts2
97: WHERE wts1.trip_id = c_trip_id
98: AND wts2.trip_id = c_trip_id
99: AND wts1.stop_id = wdl.pick_up_stop_id
100: AND wts2.stop_id = wdl.drop_off_stop_id

Line 156: wsh_trip_stops wts1,

152: )
153: AND wd.delivery_id in
154: (SELECT wdl.delivery_id
155: FROM wsh_delivery_legs wdl,
156: wsh_trip_stops wts1,
157: wsh_trip_stops wts2
158: WHERE wts1.trip_id = c_trip_id
159: AND wts2.trip_id = c_trip_id
160: AND wts1.stop_id = wdl.pick_up_stop_id

Line 157: wsh_trip_stops wts2

153: AND wd.delivery_id in
154: (SELECT wdl.delivery_id
155: FROM wsh_delivery_legs wdl,
156: wsh_trip_stops wts1,
157: wsh_trip_stops wts2
158: WHERE wts1.trip_id = c_trip_id
159: AND wts2.trip_id = c_trip_id
160: AND wts1.stop_id = wdl.pick_up_stop_id
161: AND wts2.stop_id = wdl.drop_off_stop_id

Line 191: wsh_trip_stops wts1,

187: AND b.carrier_manifesting_flag = 'Y'
188: AND a.delivery_id in
189: (SELECT wdl.delivery_id
190: FROM wsh_delivery_legs wdl,
191: wsh_trip_stops wts1,
192: wsh_trip_stops wts2
193: WHERE wts1.trip_id = c_trip_id
194: AND wts2.trip_id = c_trip_id
195: AND wts1.stop_id = wdl.pick_up_stop_id

Line 192: wsh_trip_stops wts2

188: AND a.delivery_id in
189: (SELECT wdl.delivery_id
190: FROM wsh_delivery_legs wdl,
191: wsh_trip_stops wts1,
192: wsh_trip_stops wts2
193: WHERE wts1.trip_id = c_trip_id
194: AND wts2.trip_id = c_trip_id
195: AND wts1.stop_id = wdl.pick_up_stop_id
196: AND wts2.stop_id = wdl.drop_off_stop_id

Line 300: wsh_trip_stops wts1,

296: wt.schedule_id,
297: wt.load_tender_status
298: FROM wsh_trips wt,
299: wsh_delivery_legs wdl,
300: wsh_trip_stops wts1,
301: wsh_trip_stops wts2
302: WHERE wts1.stop_id = wdl.pick_up_stop_id
303: AND wts2.stop_id = wdl.drop_off_stop_id
304: AND wts1.trip_id = wt.trip_id

Line 301: wsh_trip_stops wts2

297: wt.load_tender_status
298: FROM wsh_trips wt,
299: wsh_delivery_legs wdl,
300: wsh_trip_stops wts1,
301: wsh_trip_stops wts2
302: WHERE wts1.stop_id = wdl.pick_up_stop_id
303: AND wts2.stop_id = wdl.drop_off_stop_id
304: AND wts1.trip_id = wt.trip_id
305: AND wts2.trip_id = wt.trip_id

Line 328: FROM wsh_trip_stops

324:
325: CURSOR c_trip_first_stop(c_trip_id NUMBER)
326: IS
327: SELECT stop_location_id, planned_departure_date
328: FROM wsh_trip_stops
329: WHERE trip_id = c_trip_id
330: AND stop_sequence_number =
331: (SELECT min(stop_sequence_number)
332: FROM wsh_trip_stops

Line 332: FROM wsh_trip_stops

328: FROM wsh_trip_stops
329: WHERE trip_id = c_trip_id
330: AND stop_sequence_number =
331: (SELECT min(stop_sequence_number)
332: FROM wsh_trip_stops
333: WHERE trip_id = c_trip_id);
334:
335: CURSOR c_trip_last_stop(c_trip_id NUMBER)
336: IS

Line 338: FROM wsh_trip_stops

334:
335: CURSOR c_trip_last_stop(c_trip_id NUMBER)
336: IS
337: SELECT stop_location_id, planned_arrival_date
338: FROM wsh_trip_stops
339: WHERE trip_id = c_trip_id
340: AND stop_sequence_number =
341: (SELECT max(stop_sequence_number)
342: FROM wsh_trip_stops

Line 342: FROM wsh_trip_stops

338: FROM wsh_trip_stops
339: WHERE trip_id = c_trip_id
340: AND stop_sequence_number =
341: (SELECT max(stop_sequence_number)
342: FROM wsh_trip_stops
343: WHERE trip_id = c_trip_id);
344: --
345: CURSOR c_cnt_trip_legs(c_trip_id NUMBER)
346: IS

Line 349: wsh_trip_stops wts1,

345: CURSOR c_cnt_trip_legs(c_trip_id NUMBER)
346: IS
347: SELECT count(wdl.delivery_leg_id)
348: FROM wsh_delivery_legs wdl,
349: wsh_trip_stops wts1,
350: wsh_trip_stops wts2
351: WHERE wts1.trip_id = c_trip_id
352: AND wts2.trip_id = c_trip_id
353: AND wts1.stop_id = wdl.pick_up_stop_id

Line 350: wsh_trip_stops wts2

346: IS
347: SELECT count(wdl.delivery_leg_id)
348: FROM wsh_delivery_legs wdl,
349: wsh_trip_stops wts1,
350: wsh_trip_stops wts2
351: WHERE wts1.trip_id = c_trip_id
352: AND wts2.trip_id = c_trip_id
353: AND wts1.stop_id = wdl.pick_up_stop_id
354: AND wts2.stop_id = wdl.drop_off_stop_id;

Line 358: from wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt

354: AND wts2.stop_id = wdl.drop_off_stop_id;
355:
356: CURSOR c_count_reprice_reqd(c_trip_id IN NUMBER) IS
357: Select count(*)
358: from wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt
359: where wdl.pick_up_stop_id = wts1.stop_id
360: and wdl.drop_off_stop_id = wts2.stop_id
361: and wdl.reprice_required = 'Y'
362: and wts1.trip_id = wt.trip_id

Line 377: wsh_trip_stops wts1,

373: wdl.reprice_required,
374: wdl.status_code,
375: wdl.parent_delivery_leg_id
376: FROM wsh_delivery_legs wdl,
377: wsh_trip_stops wts1,
378: wsh_trip_stops wts2
379: WHERE wts1.trip_id = c_trip_id
380: AND wts2.trip_id = c_trip_id
381: AND wts1.stop_id = wdl.pick_up_stop_id

Line 378: wsh_trip_stops wts2

374: wdl.status_code,
375: wdl.parent_delivery_leg_id
376: FROM wsh_delivery_legs wdl,
377: wsh_trip_stops wts1,
378: wsh_trip_stops wts2
379: WHERE wts1.trip_id = c_trip_id
380: AND wts2.trip_id = c_trip_id
381: AND wts1.stop_id = wdl.pick_up_stop_id
382: AND wts2.stop_id = wdl.drop_off_stop_id;

Line 3463: wsh_new_deliveries wd, wsh_trips wt, wsh_trip_stops wts1, wsh_trip_stops wts2

3459: wda.type,
3460: wda.parent_delivery_id,
3461: wdl.parent_delivery_leg_id
3462: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_legs wdl,
3463: wsh_new_deliveries wd, wsh_trips wt, wsh_trip_stops wts1, wsh_trip_stops wts2
3464: where wdd.delivery_detail_id = wda.delivery_detail_id
3465: and wda.delivery_id = wdl.delivery_id
3466: and wdl.delivery_id = wd.delivery_id
3467: and wdl.pick_up_stop_id = wts1.stop_id