Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT pkg.pkg_name, pv.pkg_version, proj.proj_name, vt.vtree_name, rt.rtag_name, rt.rtag_id, pv.pv_id
2 
  FROM package_versions pv,
3 
       packages pkg,
4 
       projects proj,
5 
       vtrees vt,
6 
       release_tags rt,
7 
       release_content rc
8 
 WHERE rt.vtree_id = vt.vtree_id
9 
   AND vt.proj_id = proj.proj_id
10 
   AND pv.pkg_id = pkg.pkg_id
11 
   AND rc.rtag_id = rt.rtag_id
12 
   AND rc.pv_id = pv.pv_id
13 
   AND vt.hide = 'N'
14 
   AND LOWER(pkg.pkg_name) LIKE LOWER('/*PKG_NAME*/')
15 
   AND NVL(LOWER(pv.v_ext),'LINK_A_NULL') LIKE NVL(LOWER('/*V_EXT*/'),'LINK_A_NULL')
16 
ORDER BY UPPER(pkg.pkg_name), pv.pv_id, proj.proj_name, vt.vtree_id, rt.rtag_id
17