| 119 |
ghuddy |
1 |
SELECT pkg.pkg_name, pv.pkg_version, proj.proj_name, vt.vtree_name, rt.rtag_name, rt.rtag_id, pv.pv_id
|
|
|
2 |
FROM package_versions pv,
|
|
|
3 |
packages pkg,
|
|
|
4 |
projects proj,
|
|
|
5 |
vtrees vt,
|
|
|
6 |
release_tags rt,
|
|
|
7 |
release_content rc
|
|
|
8 |
WHERE rt.vtree_id = vt.vtree_id
|
|
|
9 |
AND vt.proj_id = proj.proj_id
|
|
|
10 |
AND pv.pkg_id = pkg.pkg_id
|
|
|
11 |
AND rc.rtag_id = rt.rtag_id
|
|
|
12 |
AND rc.pv_id = pv.pv_id
|
|
|
13 |
AND vt.hide = 'N'
|
|
|
14 |
AND LOWER(pkg.pkg_name) LIKE LOWER('/*PKG_NAME*/')
|
|
|
15 |
AND NVL(LOWER(pv.v_ext),'LINK_A_NULL') LIKE NVL(LOWER('/*V_EXT*/'),'LINK_A_NULL')
|
|
|
16 |
ORDER BY UPPER(pkg.pkg_name), pv.pv_id, proj.proj_name, vt.vtree_id, rt.rtag_id
|
|
|
17 |
|