Subversion Repositories DevTools

Rev

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

Rev 13 Rev 15
Line 7... Line 7...
7
			   nt.NODE_ICON,
7
			   nt.NODE_ICON,
8
			   nn.NODE_ID,
8
			   nn.NODE_ID,
9
			   nn.NODE_NAME,
9
			   nn.NODE_NAME,
10
			   os.OS_ID,
10
			   os.OS_ID,
11
			   os.OS_NAME,
11
			   os.OS_NAME,
-
 
12
			   pkg.PKG_ID,
12
			   pkg.PKG_NAME,
13
			   pkg.PKG_NAME,
13
			   pv.PKG_VERSION
14
			   pv.PKG_VERSION
14
		  FROM OS_CONTENTS osc,
15
		  FROM OS_CONTENTS osc,
15
		  	   OPERATING_SYSTEMS os,
16
		  	   OPERATING_SYSTEMS os,
16
			   NETWORK_NODES nn,
17
			   NETWORK_NODES nn,
Line 34... Line 35...
34
			   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
35
			   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
35
			   nn.NODE_ID,
36
			   nn.NODE_ID,
36
			   nn.NODE_NAME,
37
			   nn.NODE_NAME,
37
			   os.OS_ID,
38
			   os.OS_ID,
38
			   os.OS_NAME,
39
			   os.OS_NAME,
-
 
40
			   pkg.PKG_ID,
39
			   pkg.PKG_NAME,
41
			   pkg.PKG_NAME,
40
			   pv.PKG_VERSION
42
			   pv.PKG_VERSION
41
		  FROM OS_CONTENTS osc,
43
		  FROM OS_CONTENTS osc,
42
		  	   OPERATING_SYSTEMS os,
44
		  	   OPERATING_SYSTEMS os,
43
			   NETWORK_NODES nn,
45
			   NETWORK_NODES nn,
Line 48... Line 50...
48
		   AND os.NODE_ID = nn.NODE_ID
50
		   AND os.NODE_ID = nn.NODE_ID
49
		   AND bc.NODE_ID = nn.NODE_ID
51
		   AND bc.NODE_ID = nn.NODE_ID
50
		   AND osc.PROD_ID = pv.PV_ID
52
		   AND osc.PROD_ID = pv.PV_ID
51
		   AND pv.PKG_ID = pkg.PKG_ID
53
		   AND pv.PKG_ID = pkg.PKG_ID
52
		   AND bc.BOM_ID = :COMPARE_BOM_ID
54
		   AND bc.BOM_ID = :COMPARE_BOM_ID
53
		   AND pv.PV_ID = :PROD_ID
-
 
54
		   
-
 
55
		   
55
		   		   
56
	   ) oldbom
56
	   ) oldbom
57
 WHERE newbom.PK = oldbom.PK (+) 
57
		 WHERE newbom.PK = oldbom.PK (+) 
58
   AND newbom.PROD_ID = oldbom.PROD_ID (+)
58
		   --AND newbom.PROD_ID = oldbom.PROD_ID (+)
-
 
59
		   AND newbom.PKG_ID  = oldbom.PKG_ID (+)
-
 
60
 
59
   AND oldbom.PROD_ID IS NULL
61
		   AND ( oldbom.PROD_ID IS NULL )
-
 
62
		   AND newbom.PROD_ID NOT IN 
-
 
63
		   (
-
 
64
		   	   SELECT osc.PROD_ID
-
 
65
			   FROM OS_CONTENTS osc,
-
 
66
			  	    OPERATING_SYSTEMS os,
-
 
67
					NETWORK_NODES nn,
-
 
68
					BOM_CONTENTS bc,
-
 
69
					PACKAGE_VERSIONS pv
-
 
70
			  WHERE osc.OS_ID = os.OS_ID
-
 
71
				AND os.NODE_ID = nn.NODE_ID
-
 
72
				AND bc.NODE_ID = nn.NODE_ID
-
 
73
				AND osc.PROD_ID = pv.PV_ID
-
 
74
				AND pv.IS_PATCH IS NULL
-
 
75
				AND bc.BOM_ID = :COMPARE_BOM_ID	
-
 
76
		  )	
60
 ORDER BY UPPER(newbom.NODE_NAME), UPPER(newbom.OS_NAME)  
77
 ORDER BY UPPER(newbom.NODE_NAME), UPPER(newbom.OS_NAME)  
61
 
78
 
62
 
79
 
63
80