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.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_TRIPS

Line 559: from wsh_trips_ob_grp_v trip,

555: l_trip_id NUMBER;
556: BEGIN
557: select trip.name, trip.trip_id
558: into l_trip_name, l_trip_id
559: from wsh_trips_ob_grp_v trip,
560: wsh_trip_stops_ob_grp_v pickup_stop,
561: wsh_trip_stops_ob_grp_v dropoff_stop,
562: wsh_delivery_legs_ob_grp_v wdl,
563: wsh_new_deliveries_ob_grp_v wnd

Line 581: from wsh_trips_ob_grp_v

577: p_trip_name IN VARCHAR2) IS
578: BEGIN
579: open x_trip_lov for
580: select name, trip_id, ship_method_code, carrier_id
581: from wsh_trips_ob_grp_v
582: where name like p_trip_name
583: and status_code = 'OP';
584: end GET_TRIP_LOV;
585:

Line 2991: wsh_trips wt

2987: p_trip_id
2988: FROM wsh_new_deliveries del,
2989: wsh_delivery_legs dlg,
2990: wsh_trip_stops st,
2991: wsh_trips wt
2992: WHERE del.delivery_id = dlg.delivery_id
2993: AND dlg.pick_up_stop_id = st.stop_id
2994: AND del.initial_pickup_location_id = st.stop_location_id
2995: AND st.trip_id = wt.trip_id