| Line -... |
Line 1... |
| - |
|
1 |
/* Get Build Dependencies information for :PV_ID in :RTAG_ID */
|
| - |
|
2 |
SELECT lpkg.pv_id AS dpv_link,
|
| 1 |
/* Dependencies */
|
3 |
dpv.pkg_id AS dpkg_id,
|
| - |
|
4 |
dpkg.pkg_name AS dpkg_name,
|
| - |
|
5 |
dpv.pv_id AS orig_pv_id,
|
| 2 |
SELECT lpkg.pv_id AS dpv_link, dpv.pkg_id AS dpkg_id, dpkg.pkg_name AS dpkg_name, dpv.pv_id AS orig_pv_id, dpv.pkg_version AS dpkg_version,
|
6 |
dpv.pkg_version AS dpkg_version,
|
| 3 |
DECODE (dpv.pkg_version, lpkg.pkg_version, NULL, lpkg.pkg_version) AS latest_pkg_version,
|
7 |
DECODE (dpv.pkg_version, lpkg.pkg_version, NULL, lpkg.pkg_version) AS latest_pkg_version,
|
| 4 |
DECODE (lpkg.pkg_version, NULL, -1, lpkg.pkg_state) AS pkg_state,
|
8 |
DECODE (lpkg.pkg_version, NULL, NVL2(drc.SDKTAG_ID, 12, -1), lpkg.pkg_state) AS pkg_state,
|
| 5 |
dpv.dlocked,
|
9 |
dpv.dlocked,
|
| 6 |
lpkg.dlocked AS latest_dlocked,
|
10 |
lpkg.dlocked AS latest_dlocked,
|
| 7 |
DECODE (igw.dpv_id, NULL, NULL, 'checked') AS ignore_warn,
|
11 |
DECODE (igw.dpv_id, NULL, NULL, 'checked') AS ignore_warn,
|
| 8 |
igw.IS_PATCH_IGNORE,
|
12 |
igw.IS_PATCH_IGNORE,
|
| - |
|
13 |
dep.dpv_id AS ignore_dpv,
|
| - |
|
14 |
lpkg.MODIFIED_STAMP,
|
| - |
|
15 |
lmod.full_name AS modifier_name,
|
| 9 |
dep.dpv_id AS ignore_dpv, lpkg.MODIFIED_STAMP, lmod.full_name AS modifier_name, lmod.user_email AS modifier_email,
|
16 |
lmod.user_email AS modifier_email,
|
| 10 |
dpv.is_patch,
|
17 |
dpv.is_patch,
|
| 11 |
dpv.is_obsolete,
|
18 |
dpv.is_obsolete,
|
| 12 |
lpkg.deprecated_state
|
19 |
lpkg.deprecated_state,
|
| - |
|
20 |
lpkg.SDKTAG_ID
|
| 13 |
FROM PACKAGE_DEPENDENCIES dep,
|
21 |
FROM PACKAGE_DEPENDENCIES dep,
|
| 14 |
PACKAGE_VERSIONS dpv,
|
22 |
PACKAGE_VERSIONS dpv,
|
| 15 |
PACKAGES dpkg,
|
23 |
PACKAGES dpkg,
|
| 16 |
IGNORE_WARNINGS igw,
|
24 |
IGNORE_WARNINGS igw,
|
| 17 |
USERS lmod,
|
25 |
USERS lmod,
|
| - |
|
26 |
RELEASE_CONTENT drc,
|
| 18 |
(
|
27 |
(
|
| 19 |
/* Full pkg list in release contents */
|
28 |
/* Full pkg list in release contents */
|
| - |
|
29 |
SELECT DISTINCT pv.pkg_id,
|
| 20 |
SELECT DISTINCT pv.pkg_id, NVL(pv.v_ext,'|LINK_A_NULL|') AS v_ext,
|
30 |
NVL(pv.v_ext,'|LINK_A_NULL|') AS v_ext,
|
| 21 |
pv.pkg_version, pv.pv_id, rc.pkg_state, rc.deprecated_state, pv.dlocked, pv.modifier_id, pv.MODIFIED_STAMP
|
31 |
pv.pkg_version, pv.pv_id,
|
| - |
|
32 |
rc.pkg_state,
|
| - |
|
33 |
rc.deprecated_state,
|
| - |
|
34 |
pv.dlocked,
|
| - |
|
35 |
pv.modifier_id,
|
| - |
|
36 |
pv.MODIFIED_STAMP,
|
| - |
|
37 |
rc.SDKTAG_ID
|
| 22 |
FROM PACKAGE_DEPENDENCIES dep,
|
38 |
FROM PACKAGE_DEPENDENCIES dep,
|
| 23 |
PACKAGE_VERSIONS pv,
|
39 |
PACKAGE_VERSIONS pv,
|
| 24 |
RELEASE_CONTENT rc
|
40 |
RELEASE_CONTENT rc
|
| 25 |
WHERE rc.rtag_id = :RTAG_ID
|
41 |
WHERE rc.rtag_id = :RTAG_ID
|
| 26 |
AND pv.pv_id = rc.pv_id
|
42 |
AND pv.pv_id = rc.pv_id
|
| Line 33... |
Line 49... |
| 33 |
AND igw.dpv_id(+) = dep.dpv_id
|
49 |
AND igw.dpv_id(+) = dep.dpv_id
|
| 34 |
AND dep.pv_id = :PV_ID
|
50 |
AND dep.pv_id = :PV_ID
|
| 35 |
AND lpkg.pkg_id(+) = dpv.pkg_id
|
51 |
AND lpkg.pkg_id(+) = dpv.pkg_id
|
| 36 |
AND lpkg.v_ext(+) = NVL(dpv.v_ext,'|LINK_A_NULL|')
|
52 |
AND lpkg.v_ext(+) = NVL(dpv.v_ext,'|LINK_A_NULL|')
|
| 37 |
AND lpkg.modifier_id = lmod.user_id(+)
|
53 |
AND lpkg.modifier_id = lmod.user_id(+)
|
| - |
|
54 |
AND drc.rtag_id = :RTAG_ID
|
| - |
|
55 |
AND drc.pv_id = :PV_ID
|
| 38 |
ORDER BY (dep.display_order), UPPER(dpkg.PKG_NAME)
|
56 |
ORDER BY (dep.display_order), UPPER(dpkg.PKG_NAME)
|