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

2317: x_return_status OUT NOCOPY VARCHAR2 ) IS
2318:
2319: CURSOR check_stop_name IS
2320: SELECT stop_id
2321: FROM wsh_trip_stops
2322: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2323: stop_id = p_stop_id
2324: UNION ALL
2325: SELECT stop_id

Line 2326: FROM wsh_trip_stops

2322: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2323: stop_id = p_stop_id
2324: UNION ALL
2325: SELECT stop_id
2326: FROM wsh_trip_stops
2327: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2328: trip_id = p_trip_id AND
2329: stop_location_id = p_stop_location_id AND
2330: planned_departure_date = nvl(p_planned_dep_date, planned_departure_date)

Line 2472: from wsh_trip_stops s

2468: x_return_status OUT NOCOPY VARCHAR2 ) IS
2469:
2470: CURSOR check_stop_count is
2471: select count(*)
2472: from wsh_trip_stops s
2473: where s.trip_id = p_trip_id
2474: and s.physical_stop_id is null
2475: and rownum < 4;
2476:

Line 3127: from wsh_trip_stops s

3123: -- stops (linked stops are counted as one stop in this case).
3124:
3125: cursor l_trip_stop_count(p_trip_id in number) is
3126: select count(*)
3127: from wsh_trip_stops s
3128: where s.trip_id = p_trip_id
3129: and s.physical_stop_id is null
3130: and rownum < 4;
3131: