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 pv.pv_id,
2 
       pkg.pkg_name,
3 
       pv.pkg_version,
4 
       pv.pkg_label,
5 
       pv.src_path,
6 
       dpkg.pkg_name AS dpkg_name,
7 
       dpv.pkg_version AS dpkg_version
8 
  FROM packages pkg,
9 
       packages dpkg,
10 
       package_versions pv,
11 
       package_versions dpv,
12 
       release_content rel,
13 
       package_dependencies dep
14 
 WHERE pv.pkg_id = pkg.pkg_id
15 
       AND dpv.pkg_id = dpkg.pkg_id(+)
16 
       AND dpv.pv_id(+) = dep.dpv_id
17 
       AND rel.pv_id = pv.pv_id
18 
       AND rel.pv_id = dep.pv_id(+)
19 
       AND rel.rtag_id = /*RTAG_ID*/
20 
ORDER BY UPPER(pkg.pkg_name), UPPER(dpkg.pkg_name)