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 (