To find all available application version

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

END_DATE_ACTIVE "when lasted",

CASE
WHEN
BASE_RELEASE_FLAG = 'Y'
Then 'BASE VERSION'
ELSE 'Upgrade'
END "BASE/UPGRADE",
ROW_SOURCE_COMMENTS "how it is done"

from
AD_RELEASES;