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_TRIP_STOPS_OB_GRP_V

Line 561: wsh_trip_stops_ob_grp_v pickup_stop,

557: BEGIN
558: select trip.name, trip.trip_id
559: into l_trip_name, l_trip_id
560: from wsh_trips_ob_grp_v trip,
561: wsh_trip_stops_ob_grp_v pickup_stop,
562: wsh_trip_stops_ob_grp_v dropoff_stop,
563: wsh_delivery_legs_ob_grp_v wdl,
564: wsh_new_deliveries_ob_grp_v wnd
565: where wdl.delivery_id = wnd.delivery_id(+)

Line 562: wsh_trip_stops_ob_grp_v dropoff_stop,

558: select trip.name, trip.trip_id
559: into l_trip_name, l_trip_id
560: from wsh_trips_ob_grp_v trip,
561: wsh_trip_stops_ob_grp_v pickup_stop,
562: wsh_trip_stops_ob_grp_v dropoff_stop,
563: wsh_delivery_legs_ob_grp_v wdl,
564: wsh_new_deliveries_ob_grp_v wnd
565: where wdl.delivery_id = wnd.delivery_id(+)
566: and wdl.delivery_id = p_delivery_id

Line 592: from wsh_trip_stops_ob_grp_v wts, hr_locations hrl

588: p_trip_id IN NUMBER) IS
589: BEGIN
590: open x_dock_door for
591: select hrl.location_code
592: from wsh_trip_stops_ob_grp_v wts, hr_locations hrl
593: where wts.stop_location_id = hrl.location_id
594: and wts.trip_id = p_trip_id;
595: END get_dock_door;
596: