Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* User by Packages in this release */
2 
SELECT DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
3 
	   pv.PV_ID,
4 
	   pkg.PKG_NAME,
5 
       pv.PKG_VERSION,
6 
	   pv.DLOCKED,
7 
	   pv.BUILD_TYPE,
8 
	   igw.PV_ID AS IGNORE_WARN,
9 
	   igw.IS_PATCH_IGNORE,
10 
	   dpv.PV_ID AS DPV_ID,
11 
	   dpkg.PKG_NAME AS DPKG_NAME,
12 
	   dpv.PKG_VERSION AS DPKG_VERSION,
13 
	   ev.ENV_AREA,
14 
	   vi.VIEW_NAME,
15 
	   usr.FULL_NAME,
16 
	   usr.USER_EMAIL,
17 
	   pv.MODIFIED_STAMP
18 
  FROM ENVIRONMENT_VIEW ev,
19 
  	   PACKAGE_DEPENDENCIES dep,
20 
	   PACKAGE_VERSIONS dpv,
21 
	   PACKAGE_VERSIONS pv,
22 
	   PACKAGES pkg,
23 
	   PACKAGES dpkg,
24 
	   USERS usr,
25 
	   VIEWS vi,
26 
	   (
27 
 
28 
	     SELECT iw.PV_ID, iw.DPV_ID, iw.IS_PATCH_IGNORE
29 
	       FROM IGNORE_WARNINGS iw
30 
		  WHERE iw.RTAG_ID = :RTAG_ID
31 
 
32 
	   ) igw
33 
 WHERE ev.RTAG_ID = :RTAG_ID
34 
   AND ev.PV_ID = dep.PV_ID
35 
   AND dep.DPV_ID = dpv.PV_ID
36 
   AND dpv.PKG_ID = :PKG_ID
37 
   AND NVL( dpv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')
38 
   AND dep.PV_ID = pv.PV_ID
39 
   AND pv.PKG_ID = pkg.PKG_ID
40 
   AND dpv.PKG_ID = dpkg.PKG_ID
41 
   AND ev.VIEW_ID = vi.VIEW_ID
42 
   AND pv.MODIFIER_ID = usr.USER_ID
43 
   AND igw.PV_ID (+) = dep.PV_ID
44 
   AND igw.DPV_ID (+) = dep.DPV_ID
45 
 ORDER BY UPPER(pkg.PKG_NAME)
46