Subversion Repositories DevTools

Rev

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

Rev 13 Rev 29
Line 1... Line -...
1 
 
 - 
 
2 
/* Bom Removed Product Location */
1 
/* Bom Removed Product Location */
3 
SELECT newloc.*
 2 
SELECT newloc.*
4 
  FROM (
 3 
  FROM (
5
4
6 
  		SELECT osc.PROD_ID,
 5 
  		SELECT osc.PROD_ID,
Line 72... Line 71...
72 
	   ) newloc
 71 
	   ) newloc
73 
 WHERE newbom.PK (+) = oldbom.PK
72 
 WHERE newbom.PK (+) = oldbom.PK
74 
   AND newbom.PROD_ID (+) = oldbom.PROD_ID
 73 
   AND newbom.PROD_ID (+) = oldbom.PROD_ID
75 
   AND newloc.PK = oldbom.PK
 74 
   AND newloc.PK = oldbom.PK
76 
   AND newbom.PROD_ID IS NULL
 75 
   AND newbom.PROD_ID IS NULL
77 
ORDER BY UPPER(oldbom.NODE_NAME), UPPER(oldbom.OS_NAME)
- 
 
78
- 
 
79 

            76
            
 

          

          

            -
            
 

            77
            
   AND newloc.PK NOT IN (

          

          

            -
            
 

            78
            
		SELECT nn.NODE_NAME ||'_'|| os.OS_NAME AS PK

          

          

            -
            
 

            79
            
		  FROM OS_CONTENTS osc,

          

          

            -
            
 

            80
            
			   OPERATING_SYSTEMS os,

          

          

            -
            
 

            81
            
			   NETWORK_NODES nn,

          

          

            -
            
 

            82
            
			   BOM_CONTENTS bc,

          

          

            -
            
 

            83
            
			   PACKAGE_VERSIONS pv,

          

          

            -
            
 

            84
            
			   PACKAGES pkg

          

          

            -
            
 

            85
            
		 WHERE osc.OS_ID = os.OS_ID

          

          

            -
            
 

            86
            
		   AND os.NODE_ID = nn.NODE_ID

          

          

            -
            
 

            87
            
		   AND bc.NODE_ID = nn.NODE_ID

          

          

            -
            
 

            88
            
		   AND osc.PROD_ID = pv.PV_ID

          

          

            -
            
 

            89
            
		   AND pv.PKG_ID = pkg.PKG_ID

          

          

            -
            
 

            90
            
		   AND bc.BOM_ID = :BOM_ID	

          

          

            -
            
 

            91
            
		   AND pkg.PKG_NAME = :PKG_NAME

          

          

            -
            
 

            92
            
 

          

          

            -
            
 

            93
            
			   MINUS

          

          

            -
            
 

            94
            
 

          

          

            -
            
 

            95
            
		SELECT nn.NODE_NAME ||'_'|| os.OS_NAME AS PK

          

          

            -
            
 

            96
            
		  FROM OS_CONTENTS osc,

          

          

            -
            
 

            97
            
			   OPERATING_SYSTEMS os,

          

          

            -
            
 

            98
            
			   NETWORK_NODES nn,

          

          

            -
            
 

            99
            
			   BOM_CONTENTS bc,

          

          

            -
            
 

            100
            
			   PACKAGE_VERSIONS pv,

          

          

            -
            
 

            101
            
			   PACKAGES pkg

          

          

            -
            
 

            102
            
		 WHERE osc.OS_ID = os.OS_ID

          

          

            -
            
 

            103
            
		   AND os.NODE_ID = nn.NODE_ID

          

          

            -
            
 

            104
            
		   AND bc.NODE_ID = nn.NODE_ID

          

          

            -
            
 

            105
            
		   AND osc.PROD_ID = pv.PV_ID

          

          

            -
            
 

            106
            
		   AND pv.PKG_ID = pkg.PKG_ID

          

          

            -
            
 

            107
            
		   AND bc.BOM_ID = :BOM_ID	

          

          

            -
            
 

            108
            
		   AND pkg.PKG_NAME = :PKG_NAME

          

          

            -
            
 

            109
            
		   AND pv.IS_PATCH IS NOT NULL

          

          

            -
            
 

            110
            
	   )

          

          

            -
            
 

            111
            
ORDER BY UPPER(oldbom.NODE_NAME), UPPER(oldbom.OS_NAME)

          

          

            -
            
 

            112