| 119 |
ghuddy |
1 |
SELECT DISTINCT 1 AS dep_level, dep.pv_id, pkg.pkg_name, dep.pkg_version,
|
|
|
2 |
dep.dpkg_version AS dpkg_version,
|
|
|
3 |
dep.dpv_id,
|
|
|
4 |
dep.modified_stamp, usr.full_name, usr.user_email
|
|
|
5 |
FROM (
|
|
|
6 |
SELECT dp.pv_id, dp.pkg_id, vex.v_ext, vex.pkg_version, dvex.pkg_version AS dpkg_version, vex.modifier_id, vex.modified_stamp, dp.dpv_id, dp.dpkg_id, dvex.v_ext AS dv_ext
|
|
|
7 |
FROM package_dependencies dp,
|
|
|
8 |
package_versions dvex,
|
|
|
9 |
package_versions vex
|
|
|
10 |
WHERE dp.pv_id IN ( SELECT rc.pv_id FROM release_content rc WHERE rtag_id = :RTAG_ID )
|
|
|
11 |
AND dp.dpv_id = dvex.pv_id
|
|
|
12 |
AND dp.pv_id = vex.pv_id
|
|
|
13 |
) dep,
|
|
|
14 |
package_versions pv,
|
|
|
15 |
packages pkg,
|
|
|
16 |
users usr
|
|
|
17 |
WHERE NVL(pv.v_ext, '|LINK_A_NULL|') = NVL(dep.dv_ext, '|LINK_A_NULL|')
|
|
|
18 |
AND pv.pkg_id = dep.dpkg_id
|
|
|
19 |
AND pv.pv_id IN ( /*START_FROM*/ )
|
|
|
20 |
AND dep.pkg_id = pkg.pkg_id
|
|
|
21 |
AND dep.modifier_id = usr.user_id
|
|
|
22 |
ORDER BY UPPER(pkg.pkg_name)
|
|
|
23 |
|