DBA Data[Home] [Help]

APPS.WSH_PO_INTEGRATION_GRP dependencies on WSH_TRIPS

Line 459: wsh_trips wt

455: SELECT wts.last_update_date, wdl.last_update_date, wt.last_update_date
456: FROM wsh_new_deliveries wnd,
457: wsh_delivery_legs wdl,
458: wsh_trip_stops wts,
459: wsh_trips wt
460: WHERE wnd.delivery_id = p_delId
461: AND wnd.delivery_id = wdl.delivery_id
462: AND wdl.pick_up_stop_id = wts.stop_id
463: AND wnd.initial_pickup_location_id = wts.stop_location_id

Line 474: wsh_trips wt

470: SELECT wts.last_update_date, wdl.last_update_date, wt.last_update_date
471: FROM wsh_new_deliveries wnd,
472: wsh_delivery_legs wdl,
473: wsh_trip_stops wts,
474: wsh_trips wt
475: WHERE wnd.delivery_id = p_delId
476: AND wnd.delivery_id = wdl.delivery_id
477: AND wdl.pick_up_stop_id = wts.stop_id
478: AND wnd.ultimate_dropoff_location_id = wts.stop_location_id