Details |
Last modification |
View Log
| RSS feed
| Rev |
Author |
Line No. |
Line |
| 119 |
ghuddy |
1 |
SELECT pv.pv_id AS dpv_id, pkg.pkg_name, pv.pkg_version
|
|
|
2 |
FROM PACKAGES pkg, package_versions pv, package_dependencies dep
|
|
|
3 |
WHERE pv.pkg_id = pkg.pkg_id
|
|
|
4 |
AND dep.dpv_id = pv.pv_id
|
|
|
5 |
AND dep.pv_id = :PV_ID
|
|
|
6 |
ORDER BY UPPER(pkg.pkg_name)
|