Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Patches */
2 
SELECT qry.*
3 
  FROM (
4 
 
5 
		 SELECT pp.PATCH_ID AS PPATCH_ID,
6 
 
7 
		        pp.INSTALL_ORDER,
8 
                pkg.PKG_NAME,
9 
                pv.PKG_VERSION,
10 
                pv.COMMENTS,
11 
                pv.OBSOLETE_COMMENTS,
12 
                pv.DLOCKED,
13 
                DECODE( pv.dlocked, 'Y', pv.modified_stamp, NULL ) AS release_stamp,
14 
                pv.IS_PATCH,
15 
                pv.is_obsolete,
16 
                usr.FULL_NAME,
17 
                usr.USER_EMAIL
18 
		   FROM PACKAGE_PATCHES pp,
19 
           	    PACKAGES pkg,
20 
                PACKAGE_VERSIONS pv,
21 
                USERS usr
22 
		  WHERE pp.PV_ID = :PV_ID
23 
            AND pv.PKG_ID = pkg.PKG_ID
24 
            AND pp.PATCH_ID = pv.PV_ID
25 
            AND pv.MODIFIER_ID = usr.USER_ID
26 
			AND ( ( NVL( pv.IS_OBSOLETE, 'N' ) = 'N' AND :HIDE_OBSOLETE = 'Y' ) OR
27 
				  ( NVL( pv.IS_OBSOLETE, 'N' ) = NVL( pv.IS_OBSOLETE, 'N' ) AND :HIDE_OBSOLETE = 'N' )
28 
				)
29 
 
30 
 
31 
 
32 
		UNION
33 
 
34 
 
35 
		SELECT pdep.PV_ID AS PPATCH_ID,
36 
			   pdep.DPV_ID AS PATCH_ID,
37 
		       pp.INSTALL_ORDER AS INSTALL_ORDER,
38 
               pkg.PKG_NAME,
39 
               pv.PKG_VERSION,
40 
               pv.COMMENTS,
41 
               pv.OBSOLETE_COMMENTS,
42 
               pv.DLOCKED,
43 
               DECODE( pv.dlocked, 'Y', pv.modified_stamp, NULL ) AS release_stamp,
44 
               pv.IS_PATCH,
45 
               pv.is_obsolete,
46 
               usr.FULL_NAME,
47 
               usr.USER_EMAIL
48 
		  FROM PACKAGE_DEPENDENCIES pdep,
49 
		  	   (
50 
		         SELECT pp.PV_ID, pp.PATCH_ID, pp.INSTALL_ORDER
51 
				   FROM PACKAGE_PATCHES pp
52 
				  WHERE pp.PV_ID = :PV_ID
53 
		       ) pp,
54 
               PACKAGES pkg,
55 
               PACKAGE_VERSIONS pv,
56 
               USERS usr
57 
		 WHERE pdep.PV_ID = pp.PATCH_ID
58 
           AND pv.PKG_ID = pkg.PKG_ID
59 
           AND pdep.DPV_ID = pv.PV_ID
60 
           AND pv.MODIFIER_ID = usr.USER_ID
61 
		   AND ( ( NVL( pv.IS_OBSOLETE, 'N' ) = 'N' AND :HIDE_OBSOLETE = 'Y' ) OR
62 
				  ( NVL( pv.IS_OBSOLETE, 'N' ) = NVL( pv.IS_OBSOLETE, 'N' ) AND :HIDE_OBSOLETE = 'N' )
63 
				)
64 
 
65 
  		) qry
66 
 ORDER BY qry.INSTALL_ORDER, qry.PATCH_ID