SELECT RT.RTAG_ID, RT.RTAG_NAME, RT.CONFIG_SPEC_BRANCH, PV.PV_ID, 
(SELECT PKG_LABEL FROM PACKAGE_VERSIONS WHERE PV_ID = PV.LAST_PV_ID) AS PKG_LABEL,
 PV.SRC_PATH, P.PKG_NAME
FROM RELEASE_TAGS RT, PACKAGE_VERSIONS PV, PACKAGES P
WHERE 
RT.RTAG_ID = :RTAG_ID
AND PV.PV_ID = :PV_ID
AND PV.PKG_ID = P.PKG_ID