Go to most recent revision |
Details |
Last modification |
View Log
| RSS feed
| Rev |
Author |
Line No. |
Line |
| 119 |
ghuddy |
1 |
SELECT RT.RTAG_ID, RT.RTAG_NAME, RT.CONFIG_SPEC_BRANCH, PV.PV_ID,
|
|
|
2 |
(SELECT PKG_LABEL FROM PACKAGE_VERSIONS WHERE PV_ID = PV.LAST_PV_ID) AS PKG_LABEL,
|
|
|
3 |
PV.SRC_PATH, P.PKG_NAME
|
|
|
4 |
FROM RELEASE_TAGS RT, PACKAGE_VERSIONS PV, PACKAGES P
|
|
|
5 |
WHERE
|
|
|
6 |
RT.RTAG_ID = :RTAG_ID
|
|
|
7 |
AND PV.PV_ID = :PV_ID
|
|
|
8 |
AND PV.PKG_ID = P.PKG_ID
|