APPS.WMS_PACKING_WORKBENCH_PVT dependencies on WSH_TRIPS

Line 2012: , wsh_trips wt

2008: ,wsh_delivery_assignments_v wda, wsh_new_deliveries_ob_grp_v wnd
2009: -- Bug 5121507
2010: , wsh_delivery_legs wdl
2011: , wsh_trip_stops wts
2012: , wsh_trips wt
2013: WHERE wda.delivery_detail_id = wdd1.delivery_detail_id
2014: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
2015: AND wnd.delivery_id (+) = wda.delivery_id
2016: AND wdd1.released_status = 'Y'

Line 2355: FROM wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt

2351: BEGIN
2352: SELECT t.trip INTO l_material_rec.trip
2353: FROM(
2354: SELECT distinct wt.name trip
2355: FROM wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt
2356: WHERE wdl.delivery_id = l_material_rec.delivery_id
2357: AND wts.stop_id = wdl.pick_up_stop_id
2358: AND wt.trip_id = wts.trip_id) t
2359: WHERE rownum <2;