APPS.FTE_TL_CACHE dependencies on WSH_TRIPS

Line 245: FROM wsh_trips t

241:
242: CURSOR get_vehicle_item(c_trip_id IN NUMBER)
243: IS
244: SELECT t.vehicle_item_id
245: FROM wsh_trips t
246: WHERE t.trip_id=c_trip_id;
247:
248:
249: l_vehicle_item NUMBER;

Line 7676: FROM wsh_trips t ,

7672: null,
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:

Line 8281: FROM wsh_trips t

8277: null,
8278: null,
8279: null,
8280: null
8281: FROM wsh_trips t
8282: WHERE t.trip_id=c_trip_id;
8283:
8284: l_trip_index NUMBER;
8285: l_carrier_index NUMBER;

Line 8458: FROM wsh_trips t ,

8454: null,
8455: null,
8456: null,
8457: null
8458: FROM wsh_trips t ,
8459: fte_trip_moves m
8460: WHERE m.move_id=c_move_id and
8461: t.trip_id=m.trip_id
8462: ORDER BY m.sequence_number;

Line 8647: FROM wsh_trips t

8643: null,
8644: null,
8645: null,
8646: null
8647: FROM wsh_trips t
8648: WHERE t.trip_id=c_trip_id;
8649:
8650: CURSOR get_lane_info(c_lane_id IN NUMBER) IS
8651: SELECT null,

Line 11485: FROM wsh_trips t

11481: null,
11482: null,
11483: null,
11484: null
11485: FROM wsh_trips t
11486: WHERE t.trip_id=c_trip_id;
11487:
11488: --Gets info from wsh_carriers
11489: