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