| 119 |
ghuddy |
1 |
SELECT dpkg.pkg_id, dpkg.pkg_name, dpv.pkg_version, dpv.pv_id, dep.build_type,
|
|
|
2 |
frc.pkg_version AS lpkg_version, frc.pv_id AS lpv_id
|
|
|
3 |
FROM package_dependencies dep,
|
|
|
4 |
package_versions dpv,
|
|
|
5 |
packages dpkg,
|
|
|
6 |
(
|
|
|
7 |
/* Full Release Content */
|
|
|
8 |
SELECT rpv.pv_id, rpv.pkg_version, rpv.pkg_id, rpv.v_ext
|
|
|
9 |
FROM RELEASE_CONTENT rc,
|
|
|
10 |
PACKAGE_VERSIONS rpv
|
|
|
11 |
WHERE rc.rtag_id = :RTAG_ID
|
|
|
12 |
AND rc.pv_id = rpv.pv_id
|
|
|
13 |
) frc
|
|
|
14 |
WHERE dep.dpv_id = dpv.pv_id
|
|
|
15 |
AND dpv.pkg_id = dpkg.pkg_id
|
|
|
16 |
AND dep.pv_id = :PV_ID
|
|
|
17 |
AND frc.pkg_id (+) = dpv.pkg_id
|
|
|
18 |
AND NVL(frc.v_ext (+),'|LINK_A_NULL|') = NVL(dpv.v_ext,'|LINK_A_NULL|')
|
|
|
19 |
ORDER BY UPPER(dpkg.pkg_name)
|
|
|
20 |
|