Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/materialdefinition/service/MaterialDefinitionManagerImpl.java
===================================================================
diff -u -r15260 -r15294
--- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/materialdefinition/service/MaterialDefinitionManagerImpl.java	(.../MaterialDefinitionManagerImpl.java)	(revision 15260)
+++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/materialdefinition/service/MaterialDefinitionManagerImpl.java	(.../MaterialDefinitionManagerImpl.java)	(revision 15294)
@@ -134,7 +134,7 @@
 		} else {
 			sql += " and po.specification is null";
 		}
-		sql += " and (po.isForeignMaterial is null or po.isForeignMaterial =  '" + Constants.STR_NO + "')";
+		sql += " and (po.isForeignMaterial is null or po.isForeignMaterial = '' or po.isForeignMaterial =  '" + Constants.STR_NO + "')";
 		return (MaterialDefinition) objectDao.getBySql(
 				MaterialDefinition.class.getSimpleName(), sql);
 	}