DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_LEGS

Line 562: wsh_delivery_legs_ob_grp_v wdl,

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
566: and pickup_stop.stop_id = wdl.pick_up_stop_id

Line 2989: wsh_delivery_legs dlg,

2985: wt.trip_id
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