DBA Data[Home] [Help]

APPS.WSH_DELIVERY_UTIL dependencies on WSH_TRIPS

Line 568: wsh_trips wt

564: from wsh_new_deliveries wnd,
565: wsh_delivery_legs wdl,
566: wsh_trip_stops wts1,
567: wsh_trip_stops wts2,
568: wsh_trips wt
569: where wnd.delivery_id = wdl.delivery_id
570: and wts1.stop_id = wdl.PICK_UP_STOP_ID
571: and wts2.stop_id = wdl.DROP_OFF_STOP_ID
572: and wts1.trip_id = wt.trip_id

Line 648: wsh_trips wt

644: wsh_delivery_assignments_v wda,
645: wsh_delivery_legs wdl,
646: wsh_trip_stops wts1,
647: wsh_trip_stops wts2,
648: wsh_trips wt
649: where wt.trip_id = p_trip_id
650: and wts1.trip_id = wt.trip_id
651: and wts2.trip_id = wt.trip_id
652: and wts1.stop_id = wdl.pick_up_stop_id