APPS.FTE_TL_CACHE dependencies on WSH_TRIP_STOPS

Line 4775: wsh_trip_stops s

4771: dl.parent_delivery_leg_id
4772: FROM wsh_delivery_assignments da,
4773: wsh_delivery_legs dl ,
4774: wsh_delivery_details dd,
4775: wsh_trip_stops s
4776: WHERE da.delivery_id=dl.delivery_id and
4777: dl.pick_up_stop_id=s.stop_id and
4778: s.trip_id = c_trip_id and
4779: da.parent_delivery_detail_id is NOT null and

Line 5467: FROM wsh_trip_stops s

5463: null,
5464: null,
5465: null,
5466: null
5467: FROM wsh_trip_stops s
5468: WHERE s.trip_id=c_trip_id
5469: ORDER by s.stop_sequence_number;
5470:
5471: --Gets all the dlegs that start from the given stop

Line 5495: wsh_trip_stops s

5491: 0,
5492: null,
5493: null
5494: FROM wsh_delivery_legs dl,
5495: wsh_trip_stops s
5496: WHERE dl.drop_off_stop_id = s.stop_id and
5497: dl.pick_up_stop_id=c_pick_up_stop_id;
5498:
5499:

Line 7677: wsh_trip_stops s

7673: null,
7674: null,
7675: null
7676: FROM wsh_trips t ,
7677: wsh_trip_stops s
7678: WHERE t.trip_id=s.trip_id AND
7679: s.stop_id=c_stop_id;
7680:
7681: CURSOR get_trip_id_from_dleg(c_dleg_id IN NUMBER) IS

Line 7684: wsh_trip_stops s

7680:
7681: CURSOR get_trip_id_from_dleg(c_dleg_id IN NUMBER) IS
7682: SELECT s.trip_id
7683: FROM wsh_delivery_legs dl,
7684: wsh_trip_stops s
7685: WHERE dl.delivery_leg_id=c_dleg_id AND
7686: dl.pick_up_stop_id=s.stop_id;
7687:
7688:

Line 11740: wsh_trip_stops s

11736: dl.parent_delivery_leg_id
11737: FROM wsh_delivery_assignments da,
11738: wsh_delivery_legs dl ,
11739: wsh_delivery_details dd,
11740: wsh_trip_stops s
11741: WHERE da.delivery_id=dl.delivery_id and
11742: s.trip_id=c_trip_id and
11743: dl.pick_up_stop_id=s.stop_id and
11744: da.parent_delivery_detail_id is null and

Line 11876: FROM wsh_trip_stops s

11872: null,
11873: null,
11874: null,
11875: null
11876: FROM wsh_trip_stops s
11877: WHERE s.trip_id=c_trip_id AND (s.physical_stop_id is NULL)
11878: ORDER by s.stop_sequence_number;
11879:
11880: