| 119 |
ghuddy |
1 |
SELECT frc.pv_id, pkg.pkg_name, frc.pkg_version, frc.view_name, frc.view_id,
|
|
|
2 |
frc.modifier, frc.modifier_email, frc.MODIFIED_STAMP,
|
|
|
3 |
frc.insertor, frc.insertor_email, frc.INSERT_STAMP
|
|
|
4 |
FROM
|
|
|
5 |
(
|
|
|
6 |
/* All packages from a release MINUS products */
|
|
|
7 |
SELECT pv.pkg_id, pv.v_ext
|
|
|
8 |
FROM release_content rc,
|
|
|
9 |
package_versions pv
|
|
|
10 |
WHERE rc.rtag_id = :RTAG_ID
|
|
|
11 |
AND NOT rc.base_view_id = 5
|
|
|
12 |
AND pv.dlocked = 'Y'
|
|
|
13 |
AND rc.pv_id = pv.pv_id
|
|
|
14 |
MINUS
|
|
|
15 |
/* All used by from a release */
|
|
|
16 |
SELECT dpv.pkg_id, dpv.v_ext
|
|
|
17 |
FROM release_content rc,
|
|
|
18 |
package_dependencies dep,
|
|
|
19 |
package_versions dpv
|
|
|
20 |
WHERE rc.rtag_id = :RTAG_ID
|
|
|
21 |
AND rc.pv_id = dep.pv_id
|
|
|
22 |
AND dep.dpv_id = dpv.pv_id
|
|
|
23 |
) nou,
|
|
|
24 |
(
|
|
|
25 |
/* Full release content */
|
|
|
26 |
SELECT pv.pv_id, pv.pkg_id, pv.v_ext, pv.pkg_version, vi.view_name, vi.view_id,
|
|
|
27 |
lmusr.full_name AS modifier, lmusr.user_email AS modifier_email, pv.MODIFIED_STAMP,
|
|
|
28 |
arusr.full_name AS insertor, arusr.user_email AS insertor_email, rc.INSERT_STAMP
|
|
|
29 |
FROM release_content rc,
|
|
|
30 |
package_versions pv,
|
|
|
31 |
views vi,
|
|
|
32 |
users lmusr,
|
|
|
33 |
users arusr
|
|
|
34 |
WHERE rc.rtag_id = :RTAG_ID
|
|
|
35 |
AND rc.pv_id = pv.pv_id
|
|
|
36 |
AND rc.base_view_id = vi.view_id
|
|
|
37 |
AND pv.MODIFIER_ID = lmusr.user_id
|
|
|
38 |
AND rc.INSERTOR_ID = arusr.user_id
|
|
|
39 |
) frc,
|
|
|
40 |
packages pkg
|
|
|
41 |
WHERE nou.pkg_id = frc.pkg_id
|
|
|
42 |
AND NVL(nou.v_ext, 'LINK_A_NULL') = NVL(frc.v_ext, 'LINK_A_NULL')
|
|
|
43 |
AND frc.pkg_id = pkg.pkg_id
|
|
|
44 |
ORDER BY frc.view_id, UPPER(pkg.pkg_name)
|