Subversion Repositories DevTools

Rev

Rev 119 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT pv.pv_id, pkg.pkg_name, pv.pkg_version, usr.full_name
2 
  FROM RELEASE_CONTENT rc,
3 
  	   PACKAGE_VERSIONS pv,
4 
	   PACKAGES pkg,
5 
	   USERS usr,
6 
  	   /* New deployable packages */
7 
  	   (
8 
		/* All deployable modules*/
9 
		SELECT pv.pkg_id, pv.v_ext
10 
		  FROM RELEASE_CONTENT rc,
11 
		  	   PACKAGE_VERSIONS pv
12 
		 WHERE rc.rtag_id = :RTAG_ID
13 
		   AND rc.pv_id = pv.pv_id
14 
		   AND NOT pv.IS_DEPLOYABLE IS NULL
15 
		   AND NOT rc.BASE_VIEW_ID = :BASE_VIEW_ID
16 
		MINUS
17 
		/* Currently deployed modules */
18 
		SELECT dpv.pkg_id, dpv.v_ext
19 
		  FROM PACKAGE_DEPENDENCIES dep,
20 
		  	   PACKAGE_VERSIONS dpv
21 
		 WHERE dep.dpv_id = dpv.pv_id
22 
		   AND NOT dpv.IS_DEPLOYABLE IS NULL
23 
		   AND dep.pv_id IN
24 
		  	   (
25 
				/* All deployment packages in release */
26 
				SELECT rc.pv_id
27 
				  FROM RELEASE_CONTENT rc
28 
				 WHERE rc.RTAG_ID = :RTAG_ID
29 
				   AND rc.BASE_VIEW_ID = :BASE_VIEW_ID
30 
			    )
31 
	   ) ndp
32 
 WHERE rc.rtag_id = :RTAG_ID
33 
   AND rc.pv_id = pv.pv_id
34 
   AND pv.pkg_id = pkg.pkg_id
35 
   AND pv.MODIFIER_ID = usr.user_id
36 
   AND pv.pkg_id = ndp.pkg_id
37 
   AND NVL( pv.v_ext, 'LINK_A_NULL' ) = NVL( ndp.v_ext, 'LINK_A_NULL' )
38