Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java
===================================================================
diff -u -r37441 -r37442
--- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java	(.../TousseDefinitionManagerImpl.java)	(revision 37441)
+++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java	(.../TousseDefinitionManagerImpl.java)	(revision 37442)
@@ -1321,7 +1321,7 @@
 		} else {
 			if(!showDisableGoods){
 				//用祖先id的话，有些旧数据祖先id是自己，就没办法停用了。
-				sql += String.format(" and po.name not in(select distinct t.name from TousseDefinition t where t.tousseType = '%s' and t.forDisplay = 1 and t.isDisable = '%s' and t.supplierName = po.supplierName) ", 
+				sql += String.format(" and not exists(select distinct t.name from TousseDefinition t where t.tousseType = '%s' and t.forDisplay = 1 and t.isDisable = '%s' and t.name = po.name and t.supplierName = po.supplierName) ", 
 						TousseDefinition.PACKAGE_TYPE_FOREIGN,Constants.STR_YES);
 			}
 		}