APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_TRIP_STOPS

Line 560: wsh_trip_stops_ob_grp_v pickup_stop,

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
564: where wdl.delivery_id = wnd.delivery_id(+)

Line 561: wsh_trip_stops_ob_grp_v dropoff_stop,

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
564: where wdl.delivery_id = wnd.delivery_id(+)
565: and wdl.delivery_id = p_delivery_id

Line 591: from wsh_trip_stops_ob_grp_v wts, hr_locations hrl

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

Line 2990: wsh_trip_stops st,

2986: INTO x_trip_shipmethod_code,
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