DBA Data[Home] [Help]

APPS.WSH_PO_INTEGRATION_GRP dependencies on WSH_DELIVERY_LEGS

Line 457: wsh_delivery_legs wdl,

453: --
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

Line 472: wsh_delivery_legs wdl,

468: --
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