Subversion Repositories DevTools

Rev

Rev 5506 | Details | Compare with Previous | Last modification | View Log | RSS feed

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