Subversion Repositories DevTools

Rev

Rev 5513 | Rev 5634 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5513 Rev 5633
Line 114... Line 114...
114
		  )	   
114
		  )	   
115
 
115
 
116
		UNION
116
		UNION
117
		
117
		
118
		/* REMOVED PRODUCTS ONLY*/    
118
		/* REMOVED PRODUCTS ONLY*/    
119
		SELECT 'R' AS CHANGE_TYPE, oldbom.PROD_ID, oldbom.PK
119
		--SELECT 'R' AS CHANGE_TYPE, oldbom.PROD_ID, oldbom.PK
-
 
120
    SELECT DECODE( newbom.PROD_ID,
-
 
121
					   NULL, 'R', 'U' ) AS CHANGE_TYPE, 
-
 
122
			   oldbom.PROD_ID, oldbom.PK
120
		  FROM (
123
		  FROM (
121
		  		SELECT osc.PROD_ID,
124
		  		SELECT osc.PROD_ID,
122
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
125
					   nn.NODE_NAME ||'_'|| os.OS_NAME AS PK,
123
					   pv.PKG_ID,
126
					   pv.PKG_ID,
124
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
127
					   NVL( pv.V_EXT, '|LINK_A_NULL|' ) AS V_EXT
Line 153... Line 156...
153
			   ) oldbom
156
			   ) oldbom
154
		 WHERE newbom.PK (+) = oldbom.PK  
157
		 WHERE newbom.PK (+) = oldbom.PK  
155
		   --AND newbom.PROD_ID (+) = oldbom.PROD_ID
158
		   --AND newbom.PROD_ID (+) = oldbom.PROD_ID
156
		   AND newbom.PKG_ID (+) = oldbom.PKG_ID
159
		   AND newbom.PKG_ID (+) = oldbom.PKG_ID
157
		   AND newbom.V_EXT (+) = oldbom.V_EXT   
160
		   AND newbom.V_EXT (+) = oldbom.V_EXT   
158
		   AND newbom.PK IS NULL  
161
		   --AND newbom.PK IS NULL
-
 
162
       AND ( oldbom.PROD_ID != newbom.PROD_ID  OR newbom.PROD_ID IS NULL )
-
 
163
  	   AND oldbom.PROD_ID NOT IN 
159
		   
164
		   (
-
 
165
		   	   SELECT osc.PROD_ID
-
 
166
			   FROM OS_CONTENTS osc,
-
 
167
			  	    OPERATING_SYSTEMS os,
-
 
168
					NETWORK_NODES nn,
-
 
169
					BOM_CONTENTS bc,
-
 
170
					PACKAGE_VERSIONS pv
-
 
171
			  WHERE osc.OS_ID = os.OS_ID
-
 
172
				AND os.NODE_ID = nn.NODE_ID
-
 
173
				AND bc.NODE_ID = nn.NODE_ID
-
 
174
				AND osc.PROD_ID = pv.PV_ID
-
 
175
				AND pv.IS_PATCH IS NULL
-
 
176
				AND bc.BOM_ID = :BOM_ID	
-
 
177
		  )	 
-
 
178
       
160
		UNION   
179
		UNION   
161
		   
180
		   
162
		/* REMOVED PATCHES */    
181
		/* REMOVED PATCHES */    
163
		SELECT 'R' AS CHANGE_TYPE, oldbom.PROD_ID, oldbom.PK
182
		SELECT 'R' AS CHANGE_TYPE, oldbom.PROD_ID, oldbom.PK
164
		  FROM (
183
		  FROM (