Subversion Repositories DevTools

SELECT pv.pv_id, pkg.pkg_name, pv.pkg_version, igw.rtag_id, proj.proj_name, rt.rtag_name
  FROM (
  
        /* Get Distinct list of package using ignore feature */
        SELECT DISTINCT iw.pv_id, iw.rtag_id
          FROM ignore_warnings iw
         WHERE iw.rtag_id = DECODE( :RTAG_ID, -1, iw.rtag_id, :RTAG_ID )
                 
       ) igw,
       packages pkg,
       package_versions pv,
       projects proj,
       release_tags rt     
 WHERE pv.pkg_id = pkg.pkg_id
   AND rt.proj_id = proj.PROJ_ID
   AND igw.rtag_id = rt.rtag_id
   AND proj.proj_id = DECODE( :PROJ_ID, -1, proj.proj_id, :PROJ_ID )
   AND igw.pv_id = pv.pv_id
ORDER BY UPPER(proj.proj_name), UPPER(rt.rtag_name), UPPER(pkg.pkg_name)