Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT DISTINCT
2 
       pkg.pkg_name,
3 
       qry.pv_id,
4 
       pv.pkg_version,
5 
       rc.rtag_id
6 
 FROM (
7 
       SELECT dep.*,
8 
       LEVEL AS LEVEL_NUM
9 
       FROM package_dependencies dep
10 
       START WITH dep.dpv_id IN ( :PV_ID )
11 
       CONNECT BY PRIOR dep.pv_id = dep.dpv_id
12 
      ) qry,
13 
       packages pkg,
14 
       package_versions pv,
15 
       release_content rc,
16 
       views vi
17 
 WHERE qry.pv_id = pv.pv_id
18 
   AND pv.pkg_id = pkg.pkg_id
19 
   AND rc.pv_id = qry.pv_id
20 
   AND rc.rtag_id = :RTAG_ID
21 
   AND rc.base_view_id = vi.view_id
22 
   AND UPPER(vi.view_name) IN ( 'PRODUCTS', 'AUTO_PRODUCTS' )