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, pv.pv_id, cqi.iss_db, cqi.iss_id, cqi.iss_state, pv.comments AS reasons
2 
  FROM CQ_ISSUES cqi,
3 
       PACKAGE_DEPENDENCIES dep,
4 
       PACKAGES pkg,
5 
       PACKAGE_VERSIONS pv
6 
 WHERE dep.pv_id = :PV_ID
7 
   AND dep.dpv_id = cqi.pv_id(+)
8 
   AND dep.dpv_id = pv.pv_id(+)
9 
   AND pv.pkg_id = pkg.pkg_id
10 
   AND cqi.iss_state (+) <> :enumISSUES_STATE_IMPORTED
11 
 ORDER BY UPPER(pkg.pkg_name) ASC, cqi.iss_state DESC