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,
2 
	   dpv.pv_id AS dpv_id, dpkg.pkg_name AS dpkg_name, dpv.pkg_version AS dpkg_version,
3 
	   DECODE ( dpv.is_deployable,
4 
	   			NULL, 'Not Deployable!', NULL ) AS is_dep_deployable
5 
  FROM PACKAGE_DEPENDENCIES dep,
6 
  	   PACKAGES pkg,
7 
  	   PACKAGE_VERSIONS pv,
8 
	   PACKAGES dpkg,
9 
	   PACKAGE_VERSIONS dpv
10 
 WHERE dep.pv_id = pv.pv_id
11 
   AND dep.dpv_id = dpv.pv_id
12 
   AND pv.pkg_id = pkg.pkg_id
13 
   AND dpv.pkg_id = dpkg.pkg_id
14 
   AND dep.pv_id IN
15 
  	   (
16 
		/* All deployment packages in release */
17 
		SELECT rc.pv_id
18 
		  FROM RELEASE_CONTENT rc
19 
		 WHERE rc.RTAG_ID = :RTAG_ID
20 
		   AND rc.BASE_VIEW_ID = :BASE_VIEW_ID
21 
	    )
22 
ORDER BY UPPER(pkg.pkg_name)