Subversion Repositories DevTools

Rev

Rev 119 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT pv.pv_id, pkg.pkg_name, pv.pkg_version, igw.rtag_id, proj.proj_name, rt.rtag_name
2 
  FROM (
3 
 
4 
        /* Get Distinct list of package using ignore feature */
5 
        SELECT DISTINCT iw.pv_id, iw.rtag_id
6 
          FROM ignore_warnings iw
7 
         WHERE iw.rtag_id = DECODE( :RTAG_ID, -1, iw.rtag_id, :RTAG_ID )
8 
 
9 
       ) igw,
10 
       packages pkg,
11 
       package_versions pv,
12 
       projects proj,
13 
       release_tags rt
14 
 WHERE pv.pkg_id = pkg.pkg_id
15 
   AND rt.proj_id = proj.PROJ_ID
16 
   AND igw.rtag_id = rt.rtag_id
17 
   AND proj.proj_id = DECODE( :PROJ_ID, -1, proj.proj_id, :PROJ_ID )
18 
   AND igw.pv_id = pv.pv_id
19 
ORDER BY UPPER(proj.proj_name), UPPER(rt.rtag_name), UPPER(pkg.pkg_name)
20