APPS.WSH_XC_UTIL dependencies on WSH_TRIP_STOPS

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

3966: -- This is the same cursor as in close_exceptions.
3967: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
3968: -- pick up 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.initial_pickup_location_id
3973: AND st.stop_id = dg.pick_up_stop_id
3974: AND st.stop_id = v_stop_id

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

3974: AND st.stop_id = v_stop_id
3975: UNION ALL
3976: -- drop off deliveries
3977: SELECT dg.delivery_id
3978: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
3979: WHERE dg.delivery_id = dl.delivery_id
3980: AND st.stop_location_id = dl.ultimate_dropoff_location_id
3981: AND st.stop_id = dg.drop_off_stop_id
3982: AND st.stop_id = v_stop_id;

Line 3986: FROM wsh_trip_stops

3982: AND st.stop_id = v_stop_id;
3983:
3984: CURSOR Get_Stops_Trip(v_trip_id NUMBER) IS
3985: SELECT stop_id
3986: FROM wsh_trip_stops
3987: WHERE trip_id = v_trip_id
3988: ORDER BY stop_sequence_number ASC ;
3989:
3990: CURSOR Get_Contents_Container (v_container_id NUMBER) IS

Line 4003: FROM wsh_trip_stops wts

3999: WHERE delivery_detail_id = v_delivery_detail_id;
4000:
4001: CURSOR c_dummy_stop (v_stop_id NUMBER) IS
4002: SELECT stop_id
4003: FROM wsh_trip_stops wts
4004: WHERE wts.physical_stop_id IS NOT NULL
4005: AND wts.physical_location_id IS NOT NULL
4006: AND wts.physical_stop_id=v_stop_id
4007: AND wts.trip_id =(SELECT trip_id

Line 4008: FROM wsh_trip_stops wts1

4004: WHERE wts.physical_stop_id IS NOT NULL
4005: AND wts.physical_location_id IS NOT NULL
4006: AND wts.physical_stop_id=v_stop_id
4007: AND wts.trip_id =(SELECT trip_id
4008: FROM wsh_trip_stops wts1
4009: WHERE wts1.stop_id=v_stop_id);
4010:
4011: l_severity VARCHAR2(30);
4012:

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

4441: -- This is the same cursor as in check_exceptions.
4442: CURSOR Get_Deliveries_Stop(v_stop_id NUMBER) IS
4443: -- pick up 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.initial_pickup_location_id
4448: AND st.stop_id = dg.pick_up_stop_id
4449: AND st.stop_id = v_stop_id

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

4449: AND st.stop_id = v_stop_id
4450: UNION ALL
4451: -- drop off deliveries
4452: SELECT dg.delivery_id
4453: FROM wsh_new_deliveries dl, wsh_delivery_legs dg, wsh_trip_stops st
4454: WHERE dg.delivery_id = dl.delivery_id
4455: AND st.stop_location_id = dl.ultimate_dropoff_location_id
4456: AND st.stop_id = dg.drop_off_stop_id
4457: AND st.stop_id = v_stop_id;

Line 4461: FROM wsh_trip_stops

4457: AND st.stop_id = v_stop_id;
4458:
4459: CURSOR Get_Stops_Trip(v_trip_id NUMBER) IS
4460: SELECT stop_id
4461: FROM wsh_trip_stops
4462: WHERE trip_id = v_trip_id
4463: ORDER BY stop_sequence_number ASC ;
4464:
4465: CURSOR c_dummy_stop (v_stop_id NUMBER) IS

Line 4467: FROM wsh_trip_stops wts

4463: ORDER BY stop_sequence_number ASC ;
4464:
4465: CURSOR c_dummy_stop (v_stop_id NUMBER) IS
4466: SELECT stop_id
4467: FROM wsh_trip_stops wts
4468: WHERE wts.physical_stop_id IS NOT NULL
4469: AND wts.physical_location_id IS NOT NULL
4470: AND wts.physical_stop_id=v_stop_id
4471: AND wts.trip_id =(SELECT trip_id

Line 4472: FROM wsh_trip_stops wts1

4468: WHERE wts.physical_stop_id IS NOT NULL
4469: AND wts.physical_location_id IS NOT NULL
4470: AND wts.physical_stop_id=v_stop_id
4471: AND wts.trip_id =(SELECT trip_id
4472: FROM wsh_trip_stops wts1
4473: WHERE wts1.stop_id=v_stop_id);
4474:
4475: -- Standard call to check for call compatibility
4476: l_api_version CONSTANT NUMBER := 1.0;