APPS.WSH_XC_UTIL dependencies on WSH_DELIVERY_LEGS

Line 3962: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

3958: -- This is the same cursor as in close_exceptions.
3959: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
3960: -- pick up deliveries
3961: SELECT dg.delivery_id
3962: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
3963: WHERE dg.delivery_id = dl.delivery_id
3964: AND st.stop_location_id = dl.initial_pickup_location_id
3965: AND st.stop_id = dg.pick_up_stop_id
3966: AND st.stop_id = v_stop_id

Line 3970: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

3966: AND st.stop_id = v_stop_id
3967: UNION ALL
3968: -- drop off deliveries
3969: SELECT dg.delivery_id
3970: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
3971: WHERE dg.delivery_id = dl.delivery_id
3972: AND st.stop_location_id = dl.ultimate_dropoff_location_id
3973: AND st.stop_id = dg.drop_off_stop_id
3974: AND st.stop_id = v_stop_id;

Line 4437: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

4433: -- This is the same cursor as in check_exceptions.
4434: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
4435: -- pick up deliveries
4436: SELECT dg.delivery_id
4437: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
4438: WHERE dg.delivery_id = dl.delivery_id
4439: AND st.stop_location_id = dl.initial_pickup_location_id
4440: AND st.stop_id = dg.pick_up_stop_id
4441: AND st.stop_id = v_stop_id

Line 4445: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st

4441: AND st.stop_id = v_stop_id
4442: UNION ALL
4443: -- drop off deliveries
4444: SELECT dg.delivery_id
4445: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
4446: WHERE dg.delivery_id = dl.delivery_id
4447: AND st.stop_location_id = dl.ultimate_dropoff_location_id
4448: AND st.stop_id = dg.drop_off_stop_id
4449: AND st.stop_id = v_stop_id;