| 119 |
ghuddy |
1 |
SELECT pkg.pkg_name, pv.pkg_version
|
|
|
2 |
FROM packages pkg, package_versions pv,
|
|
|
3 |
(
|
|
|
4 |
SELECT UNIQUE MAX(pv.pv_id) OVER (PARTITION BY pkg.pkg_name) AS pv_id
|
|
|
5 |
FROM packages pkg, package_versions pv
|
|
|
6 |
WHERE pkg.pkg_id = pv.pkg_id
|
|
|
7 |
AND pv.dlocked = 'Y'
|
|
|
8 |
AND pv.v_ext NOT IN ( SELECT ext_name FROM project_extentions WHERE proj_id <> $PROJ_ID$ )
|
|
|
9 |
AND pkg.pkg_id IN ( $PKGID_LIST$ )
|
|
|
10 |
) latest
|
|
|
11 |
WHERE pkg.pkg_id = pv.pkg_id
|
|
|
12 |
AND pv.pv_id = latest.pv_id
|