Subversion Repositories DevTools

Rev

Rev 5080 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5080 Rev 5156
Line 3... Line 3...
3 
       dpv.pkg_id AS dpkg_id,
3 
       dpv.pkg_id AS dpkg_id,
4 
       dpkg.pkg_name AS dpkg_name,
4 
       dpkg.pkg_name AS dpkg_name,
5 
       dpv.pv_id AS orig_pv_id,
5 
       dpv.pv_id AS orig_pv_id,
6 
       dpv.pkg_version AS dpkg_version,
6 
       dpv.pkg_version AS dpkg_version,
7 
       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,
8 
       DECODE (lpkg.pkg_version, NULL, NVL2(drc.SDKTAG_ID, 12, -1), lpkg.pkg_state) AS pkg_state,
 8 
       DECODE (lpkg.pkg_version, NULL, NVL2((SELECT SDKTAG_ID FROM RELEASE_CONTENT trc  WHERE trc.rtag_id(+) = :RTAG_ID AND trc.pv_id(+) = :PV_ID), 12, -1), lpkg.pkg_state) AS pkg_state,
9 
	   dpv.dlocked,
 9 
	     dpv.dlocked,
10 
       lpkg.dlocked AS latest_dlocked,
 10 
       lpkg.dlocked AS latest_dlocked,
11 
       DECODE (igw.dpv_id, NULL, NULL, 'checked') AS ignore_warn,
 11 
       DECODE (igw.dpv_id, NULL, NULL, 'checked') AS ignore_warn,
12 
	   igw.IS_PATCH_IGNORE,
 12 
	     igw.IS_PATCH_IGNORE,
13 
	   dep.dpv_id AS ignore_dpv,
13 
	     dep.dpv_id AS ignore_dpv,
14 
       lpkg.MODIFIED_STAMP,
14 
       lpkg.MODIFIED_STAMP,
15 
       lmod.full_name AS modifier_name,
15 
       lmod.full_name AS modifier_name,
16 
       lmod.user_email AS modifier_email,
 16 
       lmod.user_email AS modifier_email,
17 
	   dpv.is_patch,
 17 
	     dpv.is_patch,
18 
       dpv.is_obsolete,
 18 
       dpv.is_obsolete,
19 
	   lpkg.deprecated_state,
 19 
	     lpkg.deprecated_state,
20 
       lpkg.SDKTAG_ID
 20 
       lpkg.SDKTAG_ID
- 
 
 21 
  FROM
21 
  FROM PACKAGE_DEPENDENCIES dep,
 22 
       PACKAGE_DEPENDENCIES dep,
22 
       PACKAGE_VERSIONS dpv,
 23 
       PACKAGE_VERSIONS dpv,
23 
       PACKAGES dpkg,
 24 
       PACKAGES dpkg,
24 
       IGNORE_WARNINGS igw,
 25 
       IGNORE_WARNINGS igw,
25 
       USERS lmod,
 26 
       USERS lmod,
26 
       RELEASE_CONTENT drc,
 - 
 
27 
       (
 27 
       (
28 
       /* Full pkg list in release contents */
 28 
       /* Full pkg list in release contents */
29 
       SELECT DISTINCT pv.pkg_id,
29 
       SELECT DISTINCT pv.pkg_id,
30 
              NVL(pv.v_ext,'|LINK_A_NULL|') AS v_ext,
30 
              NVL(pv.v_ext,'|LINK_A_NULL|') AS v_ext,
31 
              pv.pkg_version, pv.pv_id,
31 
              pv.pkg_version, pv.pv_id,
Line 49... Line 49...
49 
   AND igw.dpv_id(+) = dep.dpv_id
 49 
   AND igw.dpv_id(+) = dep.dpv_id
50 
   AND dep.pv_id = :PV_ID
 50 
   AND dep.pv_id = :PV_ID
51 
   AND lpkg.pkg_id(+) = dpv.pkg_id
 51 
   AND lpkg.pkg_id(+) = dpv.pkg_id
52 
   AND lpkg.v_ext(+) = NVL(dpv.v_ext,'|LINK_A_NULL|')
 52 
   AND lpkg.v_ext(+) = NVL(dpv.v_ext,'|LINK_A_NULL|')
53 
   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
 - 
 
56 
ORDER BY (dep.display_order), UPPER(dpkg.PKG_NAME)
 54 
ORDER BY (dep.display_order), UPPER(dpkg.PKG_NAME)
- 
 
 55