Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT DISTINCT
2 
       :RTAG_ID,
3 
       qry.pv_id
4 
 FROM (
5 
       SELECT dep.*,
6 
       LEVEL AS LEVEL_NUM
7 
       FROM package_dependencies dep
8 
       START WITH dep.dpv_id IN ( :PV_ID )
9 
       CONNECT BY PRIOR dep.pv_id = dep.dpv_id
10 
      ) qry,
11 
       packages pkg,
12 
       package_versions pv,
13 
       release_content rc
14 
 WHERE qry.dpv_id = pv.pv_id
15 
   AND pv.pkg_id = pkg.pkg_id
16 
   AND rc.pv_id = qry.pv_id
17 
   AND rc.rtag_id = :RTAG_ID