| 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 |
|