Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java
===================================================================
diff -u -r13425 -r13442
--- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java	(.../TousseInstanceManagerImpl.java)	(revision 13425)
+++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java	(.../TousseInstanceManagerImpl.java)	(revision 13442)
@@ -347,10 +347,10 @@
 		
 		List<TousseSimpleVO> vos = new ArrayList<TousseSimpleVO>();
 		
-		String sql = " select t.id id, tt.name name, tt.tousseType, t.tousseName, b.barcode, t.validUntil, t.sterilingType,"
+		String sql = " select t.id id, tt.tousseName name, td.tousseType, t.tousseName, b.barcode, t.validUntil, t.sterilingType,"
 				+ "t.orgUnitCoding, t.orgUnitName, t.foreignProxyItem_Id, t.proxyDisinfection_Id  "
-				+ "from tousseinstance t, barcodedevice b , cssdHandleTousse tt "
-				+ "where t.id = b.id and tt.tousseDefitionId=t.toussedefinition_id and t.reviewBasket_id ="
+				+ "from tousseinstance t, barcodedevice b , cssdHandleTousses tt , TousseDefinition td "
+				+ "where t.id = b.id and tt.tousseDefinitionId=t.toussedefinition_id and t.tousseDefinition_id=td.id and t.reviewBasket_id ="
 				+ reviewedBasket.getId();
 		
 		if(StringUtils.isNotBlank(taskGroup)){