DBA Data[Home] [Help]

APPS.WSH_PO_INTEGRATION_GRP dependencies on WSH_TRIP_STOPS

Line 458: wsh_trip_stops wts,

454: CURSOR c_GetPTripLastUpdateDate(p_delId NUMBER) IS
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

Line 473: wsh_trip_stops wts,

469: CURSOR c_GetDTripLastUpdateDate(p_delId NUMBER) IS
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