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_CONTAINER_ACTIONS dependencies on WSH_TRIP_STOPS

Line 13425: wsh_trip_stops s

13421: cursor c_get_trip_info(p_del_id in number) is
13422: select s.trip_id, d2.delivery_id
13423: from wsh_delivery_legs l1, wsh_delivery_legs l2,
13424: wsh_new_deliveries d1, wsh_new_deliveries d2,
13425: wsh_trip_stops s
13426: where l1.delivery_id = p_del_id
13427: and l1.delivery_id = d1.delivery_id -- bug 4891897
13428: and s.stop_id = l1.pick_up_stop_id
13429: and s.stop_location_id = d1.initial_pickup_location_id

Line 13454: FROM wsh_trip_stops s, wsh_delivery_legs l

13450: */
13451:
13452: CURSOR c_get_trip_id(p_delivery_id in number) IS
13453: SELECT trip_id
13454: FROM wsh_trip_stops s, wsh_delivery_legs l
13455: WHERE s.stop_id = l.pick_up_stop_id
13456: AND l.delivery_id = p_delivery_id;
13457:
13458: l_assign_flag VARCHAR2(1);