APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_TRIP_STOPS

Line 1927: FROM wsh_trip_Stops

1923: CURSOR stop_status (l_stop_id NUMBER) IS
1924: SELECT status_code,
1925: planned_arrival_date,
1926: planned_departure_date
1927: FROM wsh_trip_Stops
1928: WHERE stop_id = l_stop_id AND
1929: status_code <> 'OP';
1930:
1931: l_del_status VARCHAR2(2);

Line 3759: FROM wsh_trip_stops st,

3755: WHERE delivery_id = p_delivery_id;
3756:
3757: CURSOR stop_status IS
3758: SELECT st.status_code
3759: FROM wsh_trip_stops st,
3760: wsh_delivery_legs dg,
3761: wsh_new_deliveries dl
3762: WHERE dl.delivery_id = p_delivery_id AND
3763: dg.delivery_id = dl.delivery_id AND

Line 3907: wsh_trip_stops st

3903: SELECT dg.drop_off_stop_id,
3904: st.stop_location_id
3905: FROM wsh_new_deliveries dl,
3906: wsh_delivery_legs dg,
3907: wsh_trip_stops st
3908: WHERE dl.delivery_id = l_delivery_id AND
3909: dl.delivery_id = dg.delivery_id AND
3910: dg.drop_off_stop_id = st.stop_id AND
3911: dl.ultimate_dropoff_location_id = st.stop_location_id;

Line 3942: wsh_trip_stops pu_stop,

3938: pu_stop.status_code pu_status,
3939: dg.drop_off_stop_id,
3940: do_stop.status_code do_status
3941: FROM wsh_delivery_legs dg,
3942: wsh_trip_stops pu_stop,
3943: wsh_trip_stops do_stop
3944: WHERE dg.delivery_id = l_delivery_id
3945: AND pu_stop.stop_id = dg.pick_up_stop_id
3946: AND do_stop.stop_id = dg.drop_off_stop_id;

Line 3943: wsh_trip_stops do_stop

3939: dg.drop_off_stop_id,
3940: do_stop.status_code do_status
3941: FROM wsh_delivery_legs dg,
3942: wsh_trip_stops pu_stop,
3943: wsh_trip_stops do_stop
3944: WHERE dg.delivery_id = l_delivery_id
3945: AND pu_stop.stop_id = dg.pick_up_stop_id
3946: AND do_stop.stop_id = dg.drop_off_stop_id;
3947:

Line 3969: FROM wsh_trip_stops ts,

3965: -- Sufficient to check drop off stops only;
3966: -- A drop off stop being closed implies that pick up stop is closed.
3967: CURSOR stops_not_closed(l_delivery_id NUMBER) IS
3968: SELECT ts.stop_id
3969: FROM wsh_trip_stops ts,
3970: wsh_delivery_legs dg
3971: WHERE dg.delivery_id = l_delivery_id
3972: AND ts.stop_id = dg.drop_off_stop_id
3973: AND ts.status_code in ('OP', 'AR')

Line 4250: FROM wsh_trip_stops ts,

4246: -- Sufficient to check drop off stops only;
4247: -- A drop off stop being closed implies that pick up stop is closed.
4248: CURSOR stops_not_closed(p_delivery_id NUMBER, p_stop_id NUMBER) IS
4249: SELECT 1
4250: FROM wsh_trip_stops ts,
4251: wsh_delivery_legs dg
4252: WHERE dg.delivery_id = p_delivery_id
4253: AND ts.stop_id = dg.drop_off_stop_id
4254: AND ts.stop_id <> p_stop_id

Line 4297: wsh_Trip_stops wts

4293: CURSOR shared_stops_csr (p_delivery_id NUMBER)
4294: IS
4295: SELECT 1
4296: FROM wsh_delivery_legs wdl,
4297: wsh_Trip_stops wts
4298: WHERE wdl.delivery_id = p_delivery_id
4299: AND (
4300: wdl.pick_up_stop_id = wts.stop_id
4301: OR wdl.drop_off_stop_id = wts.stop_id

Line 10855: wsh_trip_stops wts,

10851: p_pickup_locn_id IN NUMBER) is
10852: select wt.name, wnd.name
10853: from wsh_new_deliveries wnd,
10854: wsh_delivery_legs wdl,
10855: wsh_trip_stops wts,
10856: wsh_trips wt
10857: where wnd.delivery_id = p_del_id
10858: and wnd.delivery_id = wdl.delivery_id
10859: and wdl.pick_up_stop_id = wts.stop_id

Line 10872: wsh_trip_stops wts,

10868: p_dropoff_locn_id IN NUMBER) is
10869: select wt.name, wnd.name
10870: from wsh_new_deliveries wnd,
10871: wsh_delivery_legs wdl,
10872: wsh_trip_stops wts,
10873: wsh_trips wt
10874: where wnd.delivery_id = p_del_id
10875: and wnd.delivery_id = wdl.delivery_id
10876: and wdl.drop_off_stop_id = wts.stop_id

Line 12952: FROM wsh_trip_stops wts,

12948: CURSOR c_get_trip_info(p_del_id IN NUMBER) IS
12949: SELECT wt.trip_id,
12950: wt.name,
12951: wt.status_code
12952: FROM wsh_trip_stops wts,
12953: wsh_delivery_legs wdl,
12954: wsh_trips wt,
12955: wsh_new_deliveries wnd
12956: WHERE wnd.delivery_id = p_del_id