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 pkg.pkg_name, pv.pkg_version
2 
  FROM packages pkg, package_versions pv,
3 
       (
4 
        SELECT UNIQUE MAX(pv.pv_id) OVER (PARTITION BY pkg.pkg_name) AS pv_id
5 
          FROM packages pkg, package_versions pv
6 
         WHERE pkg.pkg_id = pv.pkg_id
7 
           AND pv.dlocked = 'Y'
8 
           AND pv.v_ext NOT IN ( SELECT ext_name FROM project_extentions WHERE proj_id <> $PROJ_ID$ )
9 
           AND pkg.pkg_id IN ( $PKGID_LIST$ )
10 
       ) latest
11 
 WHERE pkg.pkg_id = pv.pkg_id
12 
   AND pv.pv_id = latest.pv_id