Subversion Repositories DevTools

Rev

Rev 13 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13 Rev 17
Line 6... Line 6...
6 
		SELECT 'R' AS CHANGE_TYPE,
 6 
		SELECT 'R' AS CHANGE_TYPE,
7 
			   oldbom.PKG_ID,
 7 
			   oldbom.PKG_ID,
8 
			   oldbom.PV_ID AS PV_ID_A,
 8 
			   oldbom.PV_ID AS PV_ID_A,
9 
		       oldbom.PKG_NAME AS PKG_NAME_A,
 9 
		       oldbom.PKG_NAME AS PKG_NAME_A,
10 
			   oldbom.PKG_VERSION AS PKG_VERSION_A,
 10 
			   oldbom.PKG_VERSION AS PKG_VERSION_A,
- 
 
 11 
			   oldbom.IS_PATCH AS PATCH_A,
11 
			   NULL AS PV_ID_B,
 12 
			   NULL AS PV_ID_B,
12 
			   NULL AS PKG_NAME_B,
 13 
			   NULL AS PKG_NAME_B,
13 
			   NULL AS PKG_VERSION_B
 14 
			   NULL AS PKG_VERSION_B,
- 
 
 15 
			   NULL AS PATCH_B
14 
		  FROM (
 16 
		  FROM (
15 
		  		SELECT osc.PROD_ID,
 17 
		  		SELECT osc.PROD_ID, pv.IS_PATCH,
16 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 18 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
17 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID
19 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID
18 
				  FROM OS_CONTENTS osc,
 20 
				  FROM OS_CONTENTS osc,
19 
				  	   OPERATING_SYSTEMS os,
 21 
				  	   OPERATING_SYSTEMS os,
20 
					   NETWORK_NODES nn,
 22 
					   NETWORK_NODES nn,
Line 28... Line 30...
28 
				   AND NOT pv.IS_PATCH IS NULL
 30 
				   AND NOT pv.IS_PATCH IS NULL
29 
				   AND bc.BOM_ID = :SBOM_B
 31 
				   AND bc.BOM_ID = :SBOM_B
30 
				   AND pkg.PKG_ID = pv.PKG_ID
32 
				   AND pkg.PKG_ID = pv.PKG_ID
31 
		  	   ) newbom,
 33 
		  	   ) newbom,
32 
			   (
 34 
			   (
33 
			   	SELECT osc.PROD_ID,
 35 
			   	SELECT osc.PROD_ID, pv.IS_PATCH,
34 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 36 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
35 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID
37 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID
36 
				  FROM OS_CONTENTS osc,
 38 
				  FROM OS_CONTENTS osc,
37 
				  	   OPERATING_SYSTEMS os,
 39 
				  	   OPERATING_SYSTEMS os,
38 
					   NETWORK_NODES nn,
 40 
					   NETWORK_NODES nn,
Line 60... Line 62...
60 
		SELECT 'R' AS CHANGE_TYPE,
 62 
		SELECT 'R' AS CHANGE_TYPE,
61 
			   oldbom.PKG_ID,
 63 
			   oldbom.PKG_ID,
62 
			   oldbom.PV_ID AS PV_ID_A,
 64 
			   oldbom.PV_ID AS PV_ID_A,
63 
		       oldbom.PKG_NAME AS PKG_NAME_A,
 65 
		       oldbom.PKG_NAME AS PKG_NAME_A,
64 
			   oldbom.PKG_VERSION AS PKG_VERSION_A,
 66 
			   oldbom.PKG_VERSION AS PKG_VERSION_A,
- 
 
 67 
			   oldbom.IS_PATCH AS PATCH_A,
65 
			   NULL AS PV_ID_B,
 68 
			   NULL AS PV_ID_B,
66 
			   NULL AS PKG_NAME_B,
 69 
			   NULL AS PKG_NAME_B,
67 
			   NULL AS PKG_VERSION_B
 70 
			   NULL AS PKG_VERSION_B,
- 
 
 71 
			   NULL AS PATCH_B
68 
			 FROM (
72 
			 FROM (
69 
		  		SELECT osc.PROD_ID,
 73 
		  		SELECT osc.PROD_ID,
70 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 74 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
71 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID,
 75 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID,
72 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
 76 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
Line 83... Line 87...
83 
				   AND pv.IS_PATCH IS NULL
 87 
				   AND pv.IS_PATCH IS NULL
84 
				   AND bc.BOM_ID = :SBOM_B
88 
				   AND bc.BOM_ID = :SBOM_B
85 
				   AND pkg.PKG_ID = pv.PKG_ID
 89 
				   AND pkg.PKG_ID = pv.PKG_ID
86 
		  	   ) newbom,
 90 
		  	   ) newbom,
87 
			   (
 91 
			   (
88 
			   	SELECT osc.PROD_ID,
 92 
			   	SELECT osc.PROD_ID, PV.IS_PATCH,
89 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 93 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
90 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID,
 94 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID,
91 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
 95 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
92 
				  FROM OS_CONTENTS osc,
 96 
				  FROM OS_CONTENTS osc,
93 
				  	   OPERATING_SYSTEMS os,
 97 
				  	   OPERATING_SYSTEMS os,
Line 117... Line 121...
117 
		SELECT 'A' AS CHANGE_TYPE,
 121 
		SELECT 'A' AS CHANGE_TYPE,
118 
			   newbom.PKG_ID,
 122 
			   newbom.PKG_ID,
119 
			   NULL AS PV_ID_A,
 123 
			   NULL AS PV_ID_A,
120 
			   NULL AS PKG_NAME_A,
 124 
			   NULL AS PKG_NAME_A,
121 
			   NULL AS PKG_VERSION_A,
 125 
			   NULL AS PKG_VERSION_A,
- 
 
 126 
			   NULL AS PATCH_A,
122 
			   newbom.PV_ID AS PV_ID_B,
 127 
			   newbom.PV_ID AS PV_ID_B,
123 
			   newbom.PKG_NAME AS PKG_NAME_B,
 128 
			   newbom.PKG_NAME AS PKG_NAME_B,
124 
			   newbom.PKG_VERSION AS PKG_VERSION_B
 129 
			   newbom.PKG_VERSION AS PKG_VERSION_B,
- 
 
 130 
			   newbom.IS_PATCH AS PATCH_B
125 
		  FROM (
 131 
		  FROM (
126 
		  		SELECT osc.PROD_ID,
 132 
		  		SELECT osc.PROD_ID, pv.IS_PATCH,
127 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 133 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
128 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID
 134 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID
129 
				  FROM OS_CONTENTS osc,
 135 
				  FROM OS_CONTENTS osc,
130 
				  	   OPERATING_SYSTEMS os,
 136 
				  	   OPERATING_SYSTEMS os,
131 
					   NETWORK_NODES nn,
 137 
					   NETWORK_NODES nn,
Line 166... Line 172...
166 
		SELECT 'A' AS CHANGE_TYPE,
 172 
		SELECT 'A' AS CHANGE_TYPE,
167 
			   newbom.PKG_ID,
 173 
			   newbom.PKG_ID,
168 
			   NULL AS PV_ID_A,
 174 
			   NULL AS PV_ID_A,
169 
			   NULL AS PKG_NAME_A,
 175 
			   NULL AS PKG_NAME_A,
170 
			   NULL AS PKG_VERSION_A,
 176 
			   NULL AS PKG_VERSION_A,
- 
 
 177 
			   NULL AS PATCH_A,
171 
			   newbom.PV_ID AS PV_ID_B,
 178 
			   newbom.PV_ID AS PV_ID_B,
172 
			   newbom.PKG_NAME AS PKG_NAME_B,
 179 
			   newbom.PKG_NAME AS PKG_NAME_B,
173 
			   newbom.PKG_VERSION AS PKG_VERSION_B
 180 
			   newbom.PKG_VERSION AS PKG_VERSION_B,
- 
 
 181 
			   newbom.IS_PATCH AS PATCH_B
174 
		  FROM (
 182 
		  FROM (
175 
		  		SELECT osc.PROD_ID,
 183 
		  		SELECT osc.PROD_ID, pv.IS_PATCH,
176 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 184 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
177 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID,
 185 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID,
178 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
 186 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
179 
				  FROM OS_CONTENTS osc,
 187 
				  FROM OS_CONTENTS osc,
180 
				  	   OPERATING_SYSTEMS os,
 188 
				  	   OPERATING_SYSTEMS os,
Line 227... Line 235...
227 
				) AS CHANGE_TYPE,
 235 
				) AS CHANGE_TYPE,
228 
			   ra.PKG_ID,
 236 
			   ra.PKG_ID,
229 
			   ra.PV_ID AS PV_ID_A,
 237 
			   ra.PV_ID AS PV_ID_A,
230 
		       ra.PKG_NAME AS PKG_NAME_A,
 238 
		       ra.PKG_NAME AS PKG_NAME_A,
231 
			   ra.PKG_VERSION AS PKG_VERSION_A,
 239 
			   ra.PKG_VERSION AS PKG_VERSION_A,
- 
 
 240 
			   ra.IS_PATCH AS PATCH_A,
232 
			   rb.PV_ID AS PV_ID_B,
 241 
			   rb.PV_ID AS PV_ID_B,
233 
			   rb.PKG_NAME AS PKG_NAME_B,
 242 
			   rb.PKG_NAME AS PKG_NAME_B,
234 
			   rb.PKG_VERSION AS PKG_VERSION_B
 243 
			   rb.PKG_VERSION AS PKG_VERSION_B,
- 
 
 244 
			   rb.IS_PATCH AS PATCH_B
235 
		  FROM (
 245 
		  FROM (
236 
		   	   SELECT osc.PROD_ID, pv.PV_ID, pv.V_EXT, pv.PKG_VERSION, pkg.PKG_NAME, pv.PKG_ID
 246 
		   	   SELECT osc.PROD_ID, pv.IS_PATCH, pv.PV_ID, pv.V_EXT, pv.PKG_VERSION, pkg.PKG_NAME, pv.PKG_ID
237 
			   FROM OS_CONTENTS osc,
 247 
			   FROM OS_CONTENTS osc,
238 
			  	    OPERATING_SYSTEMS os,
 248 
			  	    OPERATING_SYSTEMS os,
239 
					NETWORK_NODES nn,
 249 
					NETWORK_NODES nn,
240 
					BOM_CONTENTS bc,
 250 
					BOM_CONTENTS bc,
241 
					PACKAGE_VERSIONS pv,
 251 
					PACKAGE_VERSIONS pv,
Line 247... Line 257...
247 
				AND pv.IS_PATCH IS NULL
 257 
				AND pv.IS_PATCH IS NULL
248 
				AND bc.BOM_ID = :SBOM_A
 258 
				AND bc.BOM_ID = :SBOM_A
249 
				AND pkg.PKG_ID = pv.PKG_ID
 259 
				AND pkg.PKG_ID = pv.PKG_ID
250 
		       ) ra,
 260 
		       ) ra,
251 
			   (
 261 
			   (
252 
			   SELECT osc.PROD_ID, pv.PV_ID, pv.V_EXT, pv.PKG_VERSION, pkg.PKG_NAME, pv.PKG_ID
 262 
			   SELECT osc.PROD_ID, pv.IS_PATCH, pv.PV_ID, pv.V_EXT, pv.PKG_VERSION, pkg.PKG_NAME, pv.PKG_ID
253 
			   FROM OS_CONTENTS osc,
 263 
			   FROM OS_CONTENTS osc,
254 
			  	    OPERATING_SYSTEMS os,
 264 
			  	    OPERATING_SYSTEMS os,
255 
					NETWORK_NODES nn,
 265 
					NETWORK_NODES nn,
256 
					BOM_CONTENTS bc,
 266 
					BOM_CONTENTS bc,
257 
					PACKAGE_VERSIONS pv,
 267 
					PACKAGE_VERSIONS pv,