To find the latest application version

select

ARU_RELEASE_NAME||'.'||MINOR_VERSION||'.'||TAPE_VERSION version, START_DATE_ACTIVE updated,

ROW_SOURCE_COMMENTS "how it is done",

BASE_RELEASE_FLAG "Base version"

FROM

AD_RELEASES

where

END_DATE_ACTIVE IS NULL;