SELECT pv.pv_id, 
       pkg.pkg_name,
       pv.pkg_version, 
       pv.pkg_label, 
       pv.src_path,
       dpkg.pkg_name AS dpkg_name,
       dpv.pkg_version AS dpkg_version
  FROM packages pkg,
       packages dpkg,
       package_versions pv,
       package_versions dpv,
       release_content rel,
       package_dependencies dep
 WHERE pv.pkg_id = pkg.pkg_id
       AND dpv.pkg_id = dpkg.pkg_id(+)
       AND dpv.pv_id(+) = dep.dpv_id
       AND rel.pv_id = pv.pv_id
       AND rel.pv_id = dep.pv_id(+)
       AND rel.rtag_id = /*RTAG_ID*/
ORDER BY UPPER(pkg.pkg_name), UPPER(dpkg.pkg_name)     