APPS.WSH_XC_UTIL dependencies on WSH_TRIP_STOPS

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 3978: FROM wsh_trip_stops

3974: AND st.stop_id = v_stop_id;
3975:
3976: CURSOR Get_Stops_Trip(v_trip_id NUMBER) IS
3977: SELECT stop_id
3978: FROM wsh_trip_stops
3979: WHERE trip_id = v_trip_id
3980: ORDER BY stop_sequence_number ASC ;
3981:
3982: CURSOR Get_Contents_Container (v_container_id NUMBER) IS

Line 3995: FROM wsh_trip_stops wts

3991: WHERE delivery_detail_id = v_delivery_detail_id;
3992:
3993: CURSOR c_dummy_stop (v_stop_id NUMBER) IS
3994: SELECT stop_id
3995: FROM wsh_trip_stops wts
3996: WHERE wts.physical_stop_id IS NOT NULL
3997: AND wts.physical_location_id IS NOT NULL
3998: AND wts.physical_stop_id=v_stop_id
3999: AND wts.trip_id =(SELECT trip_id

Line 4000: FROM wsh_trip_stops wts1

3996: WHERE wts.physical_stop_id IS NOT NULL
3997: AND wts.physical_location_id IS NOT NULL
3998: AND wts.physical_stop_id=v_stop_id
3999: AND wts.trip_id =(SELECT trip_id
4000: FROM wsh_trip_stops wts1
4001: WHERE wts1.stop_id=v_stop_id);
4002:
4003: l_severity VARCHAR2(30);
4004:

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;

Line 4453: FROM wsh_trip_stops

4449: AND st.stop_id = v_stop_id;
4450:
4451: CURSOR Get_Stops_Trip(v_trip_id NUMBER) IS
4452: SELECT stop_id
4453: FROM wsh_trip_stops
4454: WHERE trip_id = v_trip_id
4455: ORDER BY stop_sequence_number ASC ;
4456:
4457: CURSOR c_dummy_stop (v_stop_id NUMBER) IS

Line 4459: FROM wsh_trip_stops wts

4455: ORDER BY stop_sequence_number ASC ;
4456:
4457: CURSOR c_dummy_stop (v_stop_id NUMBER) IS
4458: SELECT stop_id
4459: FROM wsh_trip_stops wts
4460: WHERE wts.physical_stop_id IS NOT NULL
4461: AND wts.physical_location_id IS NOT NULL
4462: AND wts.physical_stop_id=v_stop_id
4463: AND wts.trip_id =(SELECT trip_id

Line 4464: FROM wsh_trip_stops wts1

4460: WHERE wts.physical_stop_id IS NOT NULL
4461: AND wts.physical_location_id IS NOT NULL
4462: AND wts.physical_stop_id=v_stop_id
4463: AND wts.trip_id =(SELECT trip_id
4464: FROM wsh_trip_stops wts1
4465: WHERE wts1.stop_id=v_stop_id);
4466:
4467: -- Standard call to check for call compatibility
4468: l_api_version CONSTANT NUMBER := 1.0;