DBA Data[Home] [Help]

APPS.WSH_DELIVERY_UTIL dependencies on WSH_TRIP_STOPS

Line 566: wsh_trip_stops wts1,

562: wnd.planned_flag,
563: wnd.delivery_id
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

Line 567: wsh_trip_stops wts2,

563: wnd.delivery_id
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

Line 646: wsh_trip_stops wts1,

642: from wsh_delivery_details wdd,
643: wsh_new_deliveries wnd,
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

Line 647: wsh_trip_stops wts2,

643: wsh_new_deliveries wnd,
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