eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_UTIL_VALIDATE dependencies on WSH_TRIP_STOPS

Line 2343: FROM wsh_trip_stops

2339: x_return_status OUT NOCOPY VARCHAR2 ) IS
2340:
2341: CURSOR check_stop_name IS
2342: SELECT stop_id
2343: FROM wsh_trip_stops
2344: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2345: stop_id = p_stop_id
2346: UNION ALL
2347: SELECT stop_id

Line 2348: FROM wsh_trip_stops

2344: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2345: stop_id = p_stop_id
2346: UNION ALL
2347: SELECT stop_id
2348: FROM wsh_trip_stops
2349: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2350: trip_id = p_trip_id AND
2351: stop_location_id = p_stop_location_id AND
2352: planned_departure_date = nvl(p_planned_dep_date, planned_departure_date)

Line 2494: from wsh_trip_stops s

2490: x_return_status OUT NOCOPY VARCHAR2 ) IS
2491:
2492: CURSOR check_stop_count is
2493: select count(*)
2494: from wsh_trip_stops s
2495: where s.trip_id = p_trip_id
2496: and s.physical_stop_id is null
2497: and rownum < 4;
2498:

Line 3149: from wsh_trip_stops s

3145: -- stops (linked stops are counted as one stop in this case).
3146:
3147: cursor l_trip_stop_count(p_trip_id in number) is
3148: select count(*)
3149: from wsh_trip_stops s
3150: where s.trip_id = p_trip_id
3151: and s.physical_stop_id is null
3152: and rownum < 4;
3153: