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 rep.*
2 
  FROM (
3 
        SELECT pkg.pkg_name, pv.pkg_version, pv.pv_id, pv.dlocked, crel.*
4 
          FROM
5 
               (
6 
                SELECT rt.rtag_id,
7 
                       vt.vtree_id,
8 
                       proj.proj_name,
9 
                       vt.vtree_name,
10 
                       rt.rtag_name,
11 
                       vt.hide
12 
                  FROM release_tags rt,
13 
                       vtrees vt,
14 
                       projects proj
15 
                  WHERE rt.vtree_id = vt.vtree_id
16 
                   AND vt.proj_id = proj.proj_id
17 
                ) crel,
18 
                release_content rc,
19 
                packages pkg,
20 
                package_versions pv
21 
         WHERE rc.rtag_id = crel.rtag_id(+)
22 
           AND rc.pv_id(+) = pv.pv_id
23 
           AND pv.pkg_id = pkg.pkg_id
24 
           AND LOWER(pkg.pkg_name) LIKE LOWER('/*PKG_NAME*/')
25 
		   AND NVL(LOWER(pv.v_ext),'LINK_A_NULL') LIKE NVL(LOWER('/*V_EXT*/'),'LINK_A_NULL')
26 
        ) rep
27 
 WHERE rep.hide = 'N' OR rep.hide IS NULL
28 
ORDER BY UPPER(rep.pkg_name), rep.pv_id, rep.proj_name, rep.vtree_id, rep.rtag_id
29