DBA Data[Home] [Help]

APPS.WSH_IB_TXN_MATCH_PKG dependencies on WSH_TRIPS

Line 5123: wsh_trips wt

5119: FROM wsh_delivery_legs wdl,
5120: wsh_new_deliveries wnd,
5121: wsh_trip_stops wts,
5122: wsh_trip_stops wts1,
5123: wsh_trips wt
5124: WHERE wnd.delivery_id = p_deliveryId
5125: AND wdl.delivery_id = wnd.delivery_id
5126: AND wdl.drop_off_stop_id = wts.stop_id
5127: AND wts.stop_location_id = wnd.ultimate_dropoff_location_id

Line 5140: wsh_trips wt

5136: FROM wsh_delivery_legs wdl,
5137: wsh_new_deliveries wnd,
5138: wsh_trip_stops wts,
5139: wsh_trip_stops wts1,
5140: wsh_trips wt
5141: WHERE wnd.delivery_id = p_deliveryId
5142: AND wdl.delivery_id = wnd.delivery_id
5143: AND wdl.pick_up_stop_id = wts.stop_id
5144: AND wts.stop_location_id = wnd.initial_pickup_location_id