Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1 
/* Reasons for Release */
2 
/* Does not pick REMOVED dependencies */
3 
SELECT pv.PV_ID,
4 
	   pkg.pkg_name,
5 
	   pv.pkg_version,
6 
	   pv.COMMENTS
7 
  FROM PACKAGES pkg,
8 
  	   PACKAGE_VERSIONS pv,
9 
	   (
10 
		/* Original Product */
11 
		SELECT 2 AS seq,
12 
			   dep.dpv_id
13 
		  FROM PACKAGE_DEPENDENCIES dep
14 
		 WHERE dep.PV_ID = :PROD_ID
15 
		MINUS
16 
		/* Previous Version */
17 
		SELECT 2 AS seq,
18 
			   dep.dpv_id
19 
		  FROM PACKAGE_DEPENDENCIES dep
20 
		 WHERE dep.PV_ID = :OLD_PROD_ID
21 
           AND :PROD_ID != :OLD_PROD_ID
22 
		UNION
23 
	   	/* Product itself */
24 
		SELECT 1 AS seq,
25 
			   TO_NUMBER( :PROD_ID ) FROM DUAL
26 
	   ) diff
27 
 WHERE pv.pkg_id = pkg.pkg_id
28 
   AND diff.dpv_id = pv.pv_id
29 
ORDER BY diff.seq, UPPER(pkg.pkg_name)