Subversion Repositories DevTools

Rev

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

Rev 15 Rev 17
Line 8... Line 8...
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.NODE_NAME AS NODE_NAME_A,
 11 
			   oldbom.NODE_NAME AS NODE_NAME_A,
12 
			   oldbom.OS_NAME AS OS_NAME_A,
 12 
			   oldbom.OS_NAME AS OS_NAME_A,
- 
 
 13 
			   oldbom.OS_ID AS OS_ID_A,
- 
 
 14 
			   oldbom.NODE_ID AS NODE_ID_A,
13 
			   NULL AS PV_ID_B,
 15 
			   NULL AS PV_ID_B,
14 
			   NULL AS PKG_NAME_B,
 16 
			   NULL AS PKG_NAME_B,
15 
			   NULL AS PKG_VERSION_B,
 17 
			   NULL AS PKG_VERSION_B,
16 
			   NULL AS NODE_NAME_B,
 18 
			   NULL AS NODE_NAME_B,
17 
			   NULL AS OS_NAME_B
 19 
			   NULL AS OS_NAME_B,
- 
 
 20 
			   NULL AS OS_ID_B,
- 
 
 21 
			   NULL AS NODE_ID_B
18 
		  FROM (
 22 
		  FROM (
19 
		  		SELECT osc.PROD_ID,
 23 
		  		SELECT osc.PROD_ID,
20 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 24 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
21 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME AS NODE_NAME_B
25 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME AS NODE_NAME_B
22 
				  FROM OS_CONTENTS osc,
 26 
				  FROM OS_CONTENTS osc,
Line 33... Line 37...
33 
				   AND bc.BOM_ID = :SBOM_B
 37 
				   AND bc.BOM_ID = :SBOM_B
34 
				   AND pkg.PKG_ID = pv.PKG_ID
38 
				   AND pkg.PKG_ID = pv.PKG_ID
35 
		  	   ) newbom,
 39 
		  	   ) newbom,
36 
			   (
 40 
			   (
37 
			   	SELECT osc.PROD_ID,
 41 
			   	SELECT osc.PROD_ID,
38 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 42 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK, nn.NODE_ID, os.OS_ID,
39 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME, os.OS_NAME
43 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME, os.OS_NAME
40 
				  FROM OS_CONTENTS osc,
 44 
				  FROM OS_CONTENTS osc,
41 
				  	   OPERATING_SYSTEMS os,
 45 
				  	   OPERATING_SYSTEMS os,
42 
					   NETWORK_NODES nn,
 46 
					   NETWORK_NODES nn,
43 
					   BOM_CONTENTS bc,
 47 
					   BOM_CONTENTS bc,
Line 66... Line 70...
66 
			   oldbom.PV_ID AS PV_ID_A,
 70 
			   oldbom.PV_ID AS PV_ID_A,
67 
		       oldbom.PKG_NAME AS PKG_NAME_A,
 71 
		       oldbom.PKG_NAME AS PKG_NAME_A,
68 
			   oldbom.PKG_VERSION AS PKG_VERSION_A,
 72 
			   oldbom.PKG_VERSION AS PKG_VERSION_A,
69 
			   oldbom.NODE_NAME_A,
 73 
			   oldbom.NODE_NAME_A,
70 
			   oldbom.OS_NAME_A,
 74 
			   oldbom.OS_NAME_A,
- 
 
 75 
			   oldbom.OS_ID AS OS_ID_A,
- 
 
 76 
			   oldbom.NODE_ID AS NODE_ID_A,
71 
			   NULL AS PV_ID_B,
 77 
			   NULL AS PV_ID_B,
72 
			   NULL AS PKG_NAME_B,
 78 
			   NULL AS PKG_NAME_B,
73 
			   NULL AS PKG_VERSION_B,
 79 
			   NULL AS PKG_VERSION_B,
74 
			   NULL AS NODE_NAME_B,
 80 
			   NULL AS NODE_NAME_B,
75 
			   NULL AS OS_NAME_B
 81 
			   NULL AS OS_NAME_B,
- 
 
 82 
   			   NULL AS OS_ID_B,
- 
 
 83 
			   NULL AS NODE_ID_B
76 
			 FROM (
84 
			 FROM (
77 
		  		SELECT osc.PROD_ID,
 85 
		  		SELECT osc.PROD_ID,
78 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 86 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
79 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID, nn.NODE_NAME AS NODE_NAME_B,
 87 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID, nn.NODE_NAME AS NODE_NAME_B,
80 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
 88 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
81 
				  FROM OS_CONTENTS osc,
 89 
				  FROM OS_CONTENTS osc,
82 
				  	   OPERATING_SYSTEMS os,
 90 
				  	   OPERATING_SYSTEMS os,
83 
					   NETWORK_NODES nn,
 91 
					   NETWORK_NODES nn,
Line 92... Line 100...
92 
				   AND bc.BOM_ID = :SBOM_B
100 
				   AND bc.BOM_ID = :SBOM_B
93 
				   AND pkg.PKG_ID = pv.PKG_ID
 101 
				   AND pkg.PKG_ID = pv.PKG_ID
94 
		  	   ) newbom,
 102 
		  	   ) newbom,
95 
			   (
 103 
			   (
96 
			   	SELECT osc.PROD_ID,
 104 
			   	SELECT osc.PROD_ID,
97 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 105 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK, nn.NODE_ID, os.OS_ID,
98 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID, nn.NODE_NAME AS NODE_NAME_A, os.OS_NAME AS OS_NAME_A,
 106 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID, nn.NODE_NAME AS NODE_NAME_A, os.OS_NAME AS OS_NAME_A,
99 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
 107 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
100 
				  FROM OS_CONTENTS osc,
 108 
				  FROM OS_CONTENTS osc,
101 
				  	   OPERATING_SYSTEMS os,
 109 
				  	   OPERATING_SYSTEMS os,
102 
					   NETWORK_NODES nn,
 110 
					   NETWORK_NODES nn,
Line 127... Line 135...
127 
			   NULL AS PV_ID_A,
 135 
			   NULL AS PV_ID_A,
128 
			   NULL AS PKG_NAME_A,
 136 
			   NULL AS PKG_NAME_A,
129 
			   NULL AS PKG_VERSION_A,
 137 
			   NULL AS PKG_VERSION_A,
130 
			   NULL AS NODE_NAME_A,
 138 
			   NULL AS NODE_NAME_A,
131 
			   NULL AS OS_NAME_A,
 139 
			   NULL AS OS_NAME_A,
- 
 
 140 
			   NULL AS OS_ID_A,
- 
 
 141 
			   NULL AS NODE_ID_A,
132 
			   newbom.PV_ID AS PV_ID_B,
 142 
			   newbom.PV_ID AS PV_ID_B,
133 
			   newbom.PKG_NAME AS PKG_NAME_B,
 143 
			   newbom.PKG_NAME AS PKG_NAME_B,
134 
			   newbom.PKG_VERSION AS PKG_VERSION_B,
 144 
			   newbom.PKG_VERSION AS PKG_VERSION_B,
135 
			   newbom.NODE_NAME_B,
 145 
			   newbom.NODE_NAME_B,
136 
			   newbom.OS_NAME_B
 146 
			   newbom.OS_NAME_B,
- 
 
 147 
			   newbom.OS_ID AS OS_ID_B,
- 
 
 148 
			   newbom.NODE_ID AS NODE_ID_B
137 
		  FROM (
 149 
		  FROM (
138 
		  		SELECT osc.PROD_ID,
 150 
		  		SELECT osc.PROD_ID,
139 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 151 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK, nn.NODE_ID, os.OS_ID,
140 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME AS NODE_NAME_B, os.OS_NAME AS OS_NAME_B
 152 
					   pv.PKG_VERSION, pv.PV_ID, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME AS NODE_NAME_B, os.OS_NAME AS OS_NAME_B
141 
				  FROM OS_CONTENTS osc,
 153 
				  FROM OS_CONTENTS osc,
142 
				  	   OPERATING_SYSTEMS os,
 154 
				  	   OPERATING_SYSTEMS os,
143 
					   NETWORK_NODES nn,
 155 
					   NETWORK_NODES nn,
144 
					   BOM_CONTENTS bc,
 156 
					   BOM_CONTENTS bc,
Line 180... Line 192...
180 
			   NULL AS PV_ID_A,
 192 
			   NULL AS PV_ID_A,
181 
			   NULL AS PKG_NAME_A,
 193 
			   NULL AS PKG_NAME_A,
182 
			   NULL AS PKG_VERSION_A,
 194 
			   NULL AS PKG_VERSION_A,
183 
			   NULL AS NODE_NAME_A,
 195 
			   NULL AS NODE_NAME_A,
184 
			   NULL AS OS_NAME_A,
 196 
			   NULL AS OS_NAME_A,
- 
 
 197 
			   NULL AS OS_ID_A,
- 
 
 198 
			   NULL AS NODE_ID_A,
185 
			   newbom.PV_ID AS PV_ID_B,
 199 
			   newbom.PV_ID AS PV_ID_B,
186 
			   newbom.PKG_NAME AS PKG_NAME_B,
 200 
			   newbom.PKG_NAME AS PKG_NAME_B,
187 
			   newbom.PKG_VERSION AS PKG_VERSION_B,
 201 
			   newbom.PKG_VERSION AS PKG_VERSION_B,
188 
			   newbom.NODE_NAME_B,
 202 
			   newbom.NODE_NAME_B,
189 
			   newbom.OS_NAME_B
 203 
			   newbom.OS_NAME_B,
- 
 
 204 
			   newbom.OS_ID AS OS_ID_B,
- 
 
 205 
			   newbom.NODE_ID AS NODE_ID_B
190 
		  FROM (
 206 
		  FROM (
191 
		  		SELECT osc.PROD_ID,
 207 
		  		SELECT osc.PROD_ID,
192 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 208 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK, nn.NODE_ID, os.OS_ID,
193 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID, nn.NODE_NAME AS NODE_NAME_B, os.OS_NAME AS OS_NAME_B,
 209 
					   pv.PKG_ID, pv.PKG_VERSION, pkg.PKG_NAME, pv.PV_ID, nn.NODE_NAME AS NODE_NAME_B, os.OS_NAME AS OS_NAME_B,
194 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
 210 
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
195 
				  FROM OS_CONTENTS osc,
 211 
				  FROM OS_CONTENTS osc,
196 
				  	   OPERATING_SYSTEMS os,
 212 
				  	   OPERATING_SYSTEMS os,
197 
					   NETWORK_NODES nn,
 213 
					   NETWORK_NODES nn,
Line 245... Line 261...
245 
			   ra.PV_ID AS PV_ID_A,
 261 
			   ra.PV_ID AS PV_ID_A,
246 
		       ra.PKG_NAME AS PKG_NAME_A,
 262 
		       ra.PKG_NAME AS PKG_NAME_A,
247 
			   ra.PKG_VERSION AS PKG_VERSION_A,
 263 
			   ra.PKG_VERSION AS PKG_VERSION_A,
248 
			   ra.NODE_NAME_A,
 264 
			   ra.NODE_NAME_A,
249 
			   ra.OS_NAME_A,
 265 
			   ra.OS_NAME_A,
- 
 
 266 
			   ra.OS_ID AS OS_ID_A,
- 
 
 267 
			   ra.NODE_ID AS NODE_ID_A,
250 
			   rb.PV_ID AS PV_ID_B,
 268 
			   rb.PV_ID AS PV_ID_B,
251 
			   rb.PKG_NAME AS PKG_NAME_B,
 269 
			   rb.PKG_NAME AS PKG_NAME_B,
252 
			   rb.PKG_VERSION AS PKG_VERSION_B,
 270 
			   rb.PKG_VERSION AS PKG_VERSION_B,
253 
			   rb.NODE_NAME_B,
 271 
			   rb.NODE_NAME_B,
254 
			   rb.OS_NAME_B
 272 
			   rb.OS_NAME_B,
- 
 
 273 
			   rb.OS_ID AS OS_ID_B,
- 
 
 274 
			   rb.NODE_ID AS NODE_ID_B
- 
 
 275
255 
		  FROM (
 276 
		  FROM (
256 
		   	   SELECT osc.PROD_ID, pv.PV_ID, pv.V_EXT, pv.PKG_VERSION, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME AS NODE_NAME_A,
 277 
		   	   SELECT osc.PROD_ID, pv.PV_ID, pv.V_EXT, pv.PKG_VERSION, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME AS NODE_NAME_A,
257 
			   os.OS_NAME AS OS_NAME_A
 278 
			   os.OS_NAME AS OS_NAME_A, os.OS_ID, nn.NODE_ID
258 
			   FROM OS_CONTENTS osc,
 279 
			   FROM OS_CONTENTS osc,
259 
			  	    OPERATING_SYSTEMS os,
 280 
			  	    OPERATING_SYSTEMS os,
260 
					NETWORK_NODES nn,
 281 
					NETWORK_NODES nn,
261 
					BOM_CONTENTS bc,
 282 
					BOM_CONTENTS bc,
262 
					PACKAGE_VERSIONS pv,
 283 
					PACKAGE_VERSIONS pv,
Line 269... Line 290...
269 
				AND bc.BOM_ID = :SBOM_A
 290 
				AND bc.BOM_ID = :SBOM_A
270 
				AND pkg.PKG_ID = pv.PKG_ID
 291 
				AND pkg.PKG_ID = pv.PKG_ID
271 
		       ) ra,
 292 
		       ) ra,
272 
			   (
 293 
			   (
273 
			   SELECT osc.PROD_ID, pv.PV_ID, pv.V_EXT, pv.PKG_VERSION, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME AS NODE_NAME_B,
 294 
			   SELECT osc.PROD_ID, pv.PV_ID, pv.V_EXT, pv.PKG_VERSION, pkg.PKG_NAME, pv.PKG_ID, nn.NODE_NAME AS NODE_NAME_B,
274 
			   os.OS_NAME AS OS_NAME_B
 295 
			   os.OS_NAME AS OS_NAME_B, os.OS_ID, nn.NODE_ID
275 
			   FROM OS_CONTENTS osc,
 296 
			   FROM OS_CONTENTS osc,
276 
			  	    OPERATING_SYSTEMS os,
 297 
			  	    OPERATING_SYSTEMS os,
277 
					NETWORK_NODES nn,
 298 
					NETWORK_NODES nn,
278 
					BOM_CONTENTS bc,
 299 
					BOM_CONTENTS bc,
279 
					PACKAGE_VERSIONS pv,
 300 
					PACKAGE_VERSIONS pv,