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.WMS_RFID_DEVICE_PUB dependencies on WSH_TRIP_STOPS

Line 361: from wsh_delivery_legs wdl, wsh_trip_stops wts

357: --get the trip if any associated with the delivery
358: begin
359: select wts.trip_id
360: into l_trip_id
361: from wsh_delivery_legs wdl, wsh_trip_stops wts
362: where wdl.delivery_id = l_delivery_id
363: and wdl.pick_up_stop_id = wts.stop_id;
364: EXCEPTION
365: WHEN no_data_found THEN

Line 430: wsh_trip_stops pickup_stop,

426: wsh_delivery_legs wdl,
427: wsh_delivery_details wdd,
428: wsh_delivery_assignments_v wda,
429: wsh_delivery_details wdd2,
430: wsh_trip_stops pickup_stop,
431: wsh_trip_stops dropoff_stop
432: where pickup_stop.trip_id = l_trip_id
433: and wdl.pick_up_stop_id = pickup_stop.stop_id
434: and wdl.drop_off_stop_id = dropoff_stop.stop_id

Line 431: wsh_trip_stops dropoff_stop

427: wsh_delivery_details wdd,
428: wsh_delivery_assignments_v wda,
429: wsh_delivery_details wdd2,
430: wsh_trip_stops pickup_stop,
431: wsh_trip_stops dropoff_stop
432: where pickup_stop.trip_id = l_trip_id
433: and wdl.pick_up_stop_id = pickup_stop.stop_id
434: and wdl.drop_off_stop_id = dropoff_stop.stop_id
435: and pickup_stop.trip_id = dropoff_stop.trip_id