Subversion Repositories DevTools

SELECT pkg.pkg_name, pv.pkg_version, rtd.rtd_comments, rtd.rtd_url
  FROM PACKAGES pkg, package_versions pv, runtime_dependencies rtd
 WHERE pv.pkg_id = pkg.pkg_id
   AND rtd.rtd_id = pv.pv_id
   AND rtd.pv_id = :PV_ID
ORDER BY UPPER(pkg.pkg_name)