Subversion Repositories DevTools

SELECT DISTINCT 1 AS dep_level, dep.pv_id, pkg.pkg_name, dep.pkg_version, 
       dep.dpkg_version AS dpkg_version, 
       dep.dpv_id, 
       dep.modified_stamp, usr.full_name, usr.user_email
  FROM (
        SELECT dp.pv_id, dp.pkg_id, vex.v_ext, vex.pkg_version, dvex.pkg_version AS dpkg_version, vex.modifier_id, vex.modified_stamp, dp.dpv_id, dp.dpkg_id, dvex.v_ext AS dv_ext
          FROM package_dependencies dp,
               package_versions dvex,
               package_versions vex
         WHERE dp.pv_id IN ( SELECT rc.pv_id FROM release_content rc WHERE rtag_id = :RTAG_ID )
           AND dp.dpv_id = dvex.pv_id
           AND dp.pv_id = vex.pv_id
       ) dep,
       package_versions pv,
       packages pkg,
       users usr
 WHERE NVL(pv.v_ext, '|LINK_A_NULL|') = NVL(dep.dv_ext, '|LINK_A_NULL|')
   AND pv.pkg_id = dep.dpkg_id 
   AND pv.pv_id IN ( /*START_FROM*/ )
   AND dep.pkg_id = pkg.pkg_id
   AND dep.modifier_id = usr.user_id
ORDER BY UPPER(pkg.pkg_name)