APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_TRIP_STOPS

Line 1887: FROM wsh_trip_Stops

1883: CURSOR stop_status (l_stop_id NUMBER) IS
1884: SELECT status_code,
1885: planned_arrival_date,
1886: planned_departure_date
1887: FROM wsh_trip_Stops
1888: WHERE stop_id = l_stop_id AND
1889: status_code <> 'OP';
1890:
1891: l_del_status VARCHAR2(2);

Line 3669: FROM wsh_trip_stops st,

3665: WHERE delivery_id = p_delivery_id;
3666:
3667: CURSOR stop_status IS
3668: SELECT st.status_code
3669: FROM wsh_trip_stops st,
3670: wsh_delivery_legs dg,
3671: wsh_new_deliveries dl
3672: WHERE dl.delivery_id = p_delivery_id AND
3673: dg.delivery_id = dl.delivery_id AND

Line 3817: wsh_trip_stops st

3813: SELECT dg.drop_off_stop_id,
3814: st.stop_location_id
3815: FROM wsh_new_deliveries dl,
3816: wsh_delivery_legs dg,
3817: wsh_trip_stops st
3818: WHERE dl.delivery_id = l_delivery_id AND
3819: dl.delivery_id = dg.delivery_id AND
3820: dg.drop_off_stop_id = st.stop_id AND
3821: dl.ultimate_dropoff_location_id = st.stop_location_id;

Line 3852: wsh_trip_stops pu_stop,

3848: pu_stop.status_code pu_status,
3849: dg.drop_off_stop_id,
3850: do_stop.status_code do_status
3851: FROM wsh_delivery_legs dg,
3852: wsh_trip_stops pu_stop,
3853: wsh_trip_stops do_stop
3854: WHERE dg.delivery_id = l_delivery_id
3855: AND pu_stop.stop_id = dg.pick_up_stop_id
3856: AND do_stop.stop_id = dg.drop_off_stop_id;

Line 3853: wsh_trip_stops do_stop

3849: dg.drop_off_stop_id,
3850: do_stop.status_code do_status
3851: FROM wsh_delivery_legs dg,
3852: wsh_trip_stops pu_stop,
3853: wsh_trip_stops do_stop
3854: WHERE dg.delivery_id = l_delivery_id
3855: AND pu_stop.stop_id = dg.pick_up_stop_id
3856: AND do_stop.stop_id = dg.drop_off_stop_id;
3857:

Line 3879: FROM wsh_trip_stops ts,

3875: -- Sufficient to check drop off stops only;
3876: -- A drop off stop being closed implies that pick up stop is closed.
3877: CURSOR stops_not_closed(l_delivery_id NUMBER) IS
3878: SELECT ts.stop_id
3879: FROM wsh_trip_stops ts,
3880: wsh_delivery_legs dg
3881: WHERE dg.delivery_id = l_delivery_id
3882: AND ts.stop_id = dg.drop_off_stop_id
3883: AND ts.status_code in ('OP', 'AR')

Line 4160: FROM wsh_trip_stops ts,

4156: -- Sufficient to check drop off stops only;
4157: -- A drop off stop being closed implies that pick up stop is closed.
4158: CURSOR stops_not_closed(p_delivery_id NUMBER, p_stop_id NUMBER) IS
4159: SELECT 1
4160: FROM wsh_trip_stops ts,
4161: wsh_delivery_legs dg
4162: WHERE dg.delivery_id = p_delivery_id
4163: AND ts.stop_id = dg.drop_off_stop_id
4164: AND ts.stop_id <> p_stop_id

Line 4207: wsh_Trip_stops wts

4203: CURSOR shared_stops_csr (p_delivery_id NUMBER)
4204: IS
4205: SELECT 1
4206: FROM wsh_delivery_legs wdl,
4207: wsh_Trip_stops wts
4208: WHERE wdl.delivery_id = p_delivery_id
4209: AND (
4210: wdl.pick_up_stop_id = wts.stop_id
4211: OR wdl.drop_off_stop_id = wts.stop_id

Line 10583: wsh_trip_stops wts,

10579: p_pickup_locn_id IN NUMBER) is
10580: select wt.name, wnd.name
10581: from wsh_new_deliveries wnd,
10582: wsh_delivery_legs wdl,
10583: wsh_trip_stops wts,
10584: wsh_trips wt
10585: where wnd.delivery_id = p_del_id
10586: and wnd.delivery_id = wdl.delivery_id
10587: and wdl.pick_up_stop_id = wts.stop_id

Line 10600: wsh_trip_stops wts,

10596: p_dropoff_locn_id IN NUMBER) is
10597: select wt.name, wnd.name
10598: from wsh_new_deliveries wnd,
10599: wsh_delivery_legs wdl,
10600: wsh_trip_stops wts,
10601: wsh_trips wt
10602: where wnd.delivery_id = p_del_id
10603: and wnd.delivery_id = wdl.delivery_id
10604: and wdl.drop_off_stop_id = wts.stop_id

Line 12673: FROM wsh_trip_stops wts,

12669: CURSOR c_get_trip_info(p_del_id IN NUMBER) IS
12670: SELECT wt.trip_id,
12671: wt.name,
12672: wt.status_code
12673: FROM wsh_trip_stops wts,
12674: wsh_delivery_legs wdl,
12675: wsh_trips wt,
12676: wsh_new_deliveries wnd
12677: WHERE wnd.delivery_id = p_del_id