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;