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_BATCH_PROCESS dependencies on WSH_TRIPS

Line 529: wsh_trips wt

525: x_initial_loc_id IN NUMBER)IS
526: SELECT wt.ship_method_code
527: FROM wsh_delivery_legs dlg,
528: wsh_trip_stops st,
529: wsh_trips wt
530: WHERE dlg.delivery_id = x_delivery_id
531: AND st.stop_id = dlg.pick_up_stop_id
532: AND st.stop_location_id = x_initial_loc_id
533: AND st.trip_id = wt.trip_id

Line 754: FROM wsh_trip_stops a, wsh_trips b, wsh_trip_stops c

750: x_return_status OUT NOCOPY VARCHAR2) IS
751:
752: Cursor lock_stop_trip (c_stop_id NUMBER) IS
753: SELECT a.stop_id self_stop_id, b.trip_id, c.stop_id other_stop_id
754: FROM wsh_trip_stops a, wsh_trips b, wsh_trip_stops c
755: WHERE a.trip_id = b.trip_id AND
756: a.stop_id = c_stop_id AND
757: c.trip_id = b.trip_id AND
758: a.stop_id <> C.stop_id

Line 915: wsh_trips wtp

911: SELECT DISTINCT wtp.trip_id, wst.stop_sequence_number, wst.stop_id, wst.stop_location_id
912: FROM wsh_new_deliveries wnd,
913: wsh_delivery_legs wlg,
914: wsh_trip_stops wst,
915: wsh_trips wtp
916: WHERE wnd.delivery_id = wlg.delivery_id AND
917: wlg.pick_up_stop_id = wst.stop_id AND
918: wnd.status_code = 'CO' AND
919: wnd.batch_id = p_sc_batch_id AND