Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Issue List */
2 
 
3 
SELECT cq.iss_id,
4 
	   cq.iss_db,
5 
	   cq.pv_id,
6 
	   pkg.pkg_name,
7 
	   pv.pkg_version,
8 
	   DECODE( cq.iss_state,
9 
	   		   1, DECODE ( isspv.status,
10 
			   	  		   1, 'LIMG_FIXED',
11 
						   2, 'LIMG_OLD_FIXED' ),
12 
			   '' ) AS ICON_FIXED
13 
  FROM
14 
  	   (
15 
		   (
16 
		    /* Modules updated + added in this new Product */
17 
 
18 
			/* Original Product */
19 
			SELECT 1 AS STATUS, dep.dpv_id
20 
			  FROM PACKAGE_DEPENDENCIES dep
21 
			 WHERE dep.PV_ID = :PROD_ID
22 
			MINUS
23 
			/* Previous Version */
24 
			SELECT 1 AS STATUS, dep.dpv_id
25 
			  FROM PACKAGE_DEPENDENCIES dep
26 
			 WHERE dep.PV_ID = :OLD_PROD_ID
27 
               AND :PROD_ID != :OLD_PROD_ID
28 
			UNION
29 
		   	/* Product itself */
30 
			SELECT 1 AS STATUS, TO_NUMBER( :PROD_ID ) FROM DUAL
31 
 
32 
		   )
33 
 
34 
		   UNION
35 
 
36 
		   (
37 
		   	/* Modules + Products itself of other versions */
38 
 
39 
		    SELECT 2 AS STATUS, dep.DPV_ID
40 
			  FROM PACKAGE_DEPENDENCIES dep
41 
			 WHERE dep.pv_id IN ( :OTHER_PROD_ID )
42 
			 UNION
43 
			SELECT 2 AS STATUS, TO_NUMBER( :OTHER_PROD_ID ) FROM DUAL
44 
 
45 
			MINUS
46 
 
47 
			(
48 
		    /* Modules updated + added in this new Product */
49 
 
50 
			/* Original Product */
51 
			SELECT 2 AS STATUS, dep.dpv_id
52 
			  FROM PACKAGE_DEPENDENCIES dep
53 
			 WHERE dep.PV_ID = :PROD_ID
54 
			MINUS
55 
			/* Previous Version */
56 
			SELECT 2 AS STATUS, dep.dpv_id
57 
			  FROM PACKAGE_DEPENDENCIES dep
58 
			 WHERE dep.PV_ID = :OLD_PROD_ID
59 
               AND :PROD_ID != :OLD_PROD_ID
60 
			UNION
61 
		   	/* Product itself */
62 
			SELECT 2 AS STATUS, TO_NUMBER( :PROD_ID ) FROM DUAL
63 
 
64 
		   )
65 
 
66 
		   )
67 
	   ) isspv,
68 
 
69 
	   CQ_ISSUES cq,
70 
	   PACKAGE_VERSIONS pv,
71 
	   PACKAGES pkg
72 
 
73 
 
74 
 WHERE isspv.dpv_id = cq.pv_id
75 
   AND pv.pkg_id = pkg.pkg_id
76 
   AND pv.pv_id = isspv.dpv_id
77