Subversion Repositories DevTools

Rev

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

Rev 15 Rev 25
Line 50... Line 50...
50 
		   AND os.NODE_ID = nn.NODE_ID
 50 
		   AND os.NODE_ID = nn.NODE_ID
51 
		   AND bc.NODE_ID = nn.NODE_ID
 51 
		   AND bc.NODE_ID = nn.NODE_ID
52 
		   AND osc.PROD_ID = pv.PV_ID
 52 
		   AND osc.PROD_ID = pv.PV_ID
53 
		   AND pv.PKG_ID = pkg.PKG_ID
 53 
		   AND pv.PKG_ID = pkg.PKG_ID
54 
		   AND bc.BOM_ID = :COMPARE_BOM_ID
 54 
		   AND bc.BOM_ID = :COMPARE_BOM_ID
- 
 
 55 
		   AND pv.PV_ID = :PROD_ID
55
56
56 
	   ) oldbom
 57 
	   ) oldbom
57 
		 WHERE newbom.PK = oldbom.PK (+)
58 
		 WHERE newbom.PK = oldbom.PK (+)
58 
		   --AND newbom.PROD_ID = oldbom.PROD_ID (+)
 59 
		   --AND newbom.PROD_ID = oldbom.PROD_ID (+)
59 
		   AND newbom.PKG_ID  = oldbom.PKG_ID (+)
 60 
		   AND newbom.PKG_ID  = oldbom.PKG_ID (+)