Subversion Repositories DevTools

Rev

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

Rev 13 Rev 15
Line 53... Line 53...
53 
		   AND oldbom.PK IS NULL
 53 
		   AND oldbom.PK IS NULL
54
54
55 
		UNION
55 
		UNION
56
56
57 
		/* ADDED PRODUCTS ONLY */
 57 
		/* ADDED PRODUCTS ONLY */
- 
 
 58 
		SELECT DECODE( oldbom.PROD_ID,
58 
		SELECT 'A' AS CHANGE_TYPE,
59 
					   NULL, 'A', 'U' ) AS CHANGE_TYPE,
59 
			   newbom.PROD_ID, newbom.PK
 60 
			   newbom.PROD_ID, newbom.PK
60 
		  FROM (
 61 
		  FROM (
61 
		  		SELECT osc.PROD_ID,
 62 
		  		SELECT osc.PROD_ID,
62 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
 63 
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
63 
					   pv.PKG_ID,
 64 
					   pv.PKG_ID,
Line 93... Line 94...
93 
			   ) oldbom
 94 
			   ) oldbom
94 
		 WHERE newbom.PK = oldbom.PK (+)
95 
		 WHERE newbom.PK = oldbom.PK (+)
95 
		   --AND newbom.PROD_ID = oldbom.PROD_ID (+)
 96 
		   --AND newbom.PROD_ID = oldbom.PROD_ID (+)
96 
		   AND newbom.PKG_ID  = oldbom.PKG_ID (+)
 97 
		   AND newbom.PKG_ID  = oldbom.PKG_ID (+)
97 
		   AND newbom.V_EXT  = oldbom.V_EXT (+)
98 
		   AND newbom.V_EXT  = oldbom.V_EXT (+)
98 
		   AND oldbom.PROD_ID IS NULL
99 
		   AND ( oldbom.PROD_ID != newbom.PROD_ID  OR oldbom.PROD_ID IS NULL )
99 
 
 - 
 
100
- 
 
101 
		UNION
 - 
 
102 
 
 - 
 
103 
		/*UPDATED PRODUCTS ONLY*/
 - 
 
104 
 
 - 
 
105 
		SELECT 'U' AS CHANGE_TYPE,
- 
 
106 
			   osc.PROD_ID,
 - 
 
107 
			   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK
 - 
 
108 
		  FROM OS_CONTENTS osc,
 - 
 
109 
		  	   OPERATING_SYSTEMS os,
 - 
 
110 
			   NETWORK_NODES nn,
 - 
 
111 
			   BOM_CONTENTS bc,
 - 
 
112 
			   PACKAGE_VERSIONS pv
 - 
 
113 
		 WHERE osc.OS_ID = os.OS_ID
 - 
 
114 
		   AND os.NODE_ID = nn.NODE_ID
 - 
 
115 
		   AND bc.NODE_ID = nn.NODE_ID
 - 
 
116 
		   AND osc.PROD_ID = pv.PV_ID
 - 
 
117 
		   AND pv.IS_PATCH IS NULL
 - 
 
118 
		   AND bc.BOM_ID = :BOM_ID
 - 
 
119 
		   AND osc.PROD_ID NOT IN
100 
		   AND newbom.PROD_ID NOT IN
120 
			   (
 101 
		   (
121 
		   	   SELECT osc.PROD_ID
 102 
		   	   SELECT osc.PROD_ID
122 
			   FROM OS_CONTENTS osc,
 103 
			   FROM OS_CONTENTS osc,
123 
			  	    OPERATING_SYSTEMS os,
 104 
			  	    OPERATING_SYSTEMS os,
124 
					NETWORK_NODES nn,
 105 
					NETWORK_NODES nn,
125 
					BOM_CONTENTS bc,
 106 
					BOM_CONTENTS bc,
Line 128... Line 109...
128 
				AND os.NODE_ID = nn.NODE_ID
 109 
				AND os.NODE_ID = nn.NODE_ID
129 
				AND bc.NODE_ID = nn.NODE_ID
 110 
				AND bc.NODE_ID = nn.NODE_ID
130 
				AND osc.PROD_ID = pv.PV_ID
 111 
				AND osc.PROD_ID = pv.PV_ID
131 
				AND pv.IS_PATCH IS NULL
 112 
				AND pv.IS_PATCH IS NULL
132 
				AND bc.BOM_ID = :COMPARE_BOM_ID
113 
				AND bc.BOM_ID = :COMPARE_BOM_ID
133 
			   )
 114 
		  )
134
115 
 
135 
		UNION
 116 
		UNION
136
117
137 
		/* REMOVED PRODUCTS ONLY*/
118 
		/* REMOVED PRODUCTS ONLY*/
138 
		SELECT 'R' AS CHANGE_TYPE, oldbom.PROD_ID, oldbom.PK
 119 
		SELECT 'R' AS CHANGE_TYPE, oldbom.PROD_ID, oldbom.PK
139 
		  FROM (
 120 
		  FROM (