Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1 
 
2 
		SELECT DISTINCT newbom.PROD_ID,  newbom.PKG_VERSION, newbom.PKG_ID,
3 
			   			newbom.PKG_NAME
4 
		  FROM (
5 
		  		SELECT osc.PROD_ID,
6 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
7 
					   pv.PKG_VERSION,
8 
					   pv.PKG_ID,
9 
					   pkg.PKG_NAME
10 
				  FROM OS_CONTENTS osc,
11 
				  	   OPERATING_SYSTEMS os,
12 
					   NETWORK_NODES nn,
13 
					   BOM_CONTENTS bc,
14 
					   PACKAGE_VERSIONS pv,
15 
					   PACKAGES pkg
16 
				 WHERE osc.OS_ID = os.OS_ID
17 
				   AND os.NODE_ID = nn.NODE_ID
18 
				   AND bc.NODE_ID = nn.NODE_ID
19 
				   AND osc.PROD_ID = pv.PV_ID
20 
 
21 
				   AND bc.BOM_ID = :COMPARE_BOM_ID
22 
				   AND pkg.PKG_ID = PV.PKG_ID
23 
		  	   ) newbom,
24 
			   (
25 
			   	SELECT osc.PROD_ID,
26 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
27 
					   pv.PKG_VERSION,
28 
					   pv.PKG_ID
29 
				  FROM OS_CONTENTS osc,
30 
				  	   OPERATING_SYSTEMS os,
31 
					   NETWORK_NODES nn,
32 
					   BOM_CONTENTS bc,
33 
					   PACKAGE_VERSIONS pv
34 
				 WHERE osc.OS_ID = os.OS_ID
35 
				   AND os.NODE_ID = nn.NODE_ID
36 
				   AND bc.NODE_ID = nn.NODE_ID
37 
				   AND osc.PROD_ID = pv.PV_ID
38 
 
39 
				   AND bc.BOM_ID = :BOM_ID
40 
			   ) oldbom
41 
		 WHERE newbom.PK = oldbom.PK (+)
42 
		   AND newbom.PROD_ID = oldbom.PROD_ID (+)
43 
		    AND ( oldbom.PROD_ID = newbom.PROD_ID   )
44 
ORDER BY (newbom.PKG_NAME)
45 
 
46 
 
47 
 
48 
 
49 
 
50 
 
51