Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java
===================================================================
diff -u -r35734 -r35736
--- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java	(.../PackingManagerImpl.java)	(revision 35734)
+++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java	(.../PackingManagerImpl.java)	(revision 35736)
@@ -10168,15 +10168,15 @@
 		stringBuffer.append(ComboTousseComposite.class.getSimpleName());
 		stringBuffer.append(" c join ");
 		stringBuffer.append(TousseDefinition.class.getSimpleName());
-		stringBuffer.append(" tdcom on tdcom.id=c.comboTousseDefinitionId join ");
+		stringBuffer.append(" tdcom on tdcom.id=c.comboTousseDefinitionId join "+ CssdHandleTousses.class.getSimpleName() +" ch on ch.toussedefinitionid=tdcom.id join ");
 		stringBuffer.append(TousseDefinition.class.getSimpleName());
 		stringBuffer.append(" tdc on tdc.id=c.TousseDefinitionId join ");
 		stringBuffer.append(TousseDefinition.class.getSimpleName());
 		stringBuffer.append(" td on td.ancestorID=tdc.id join ");
 		stringBuffer.append(PackingTask.class.getSimpleName());
 		stringBuffer.append(" pt on pt.tousseDefinition_id=td.id join "+ ComboTousseOrgUint.class.getSimpleName() +" ct on ct.combotoussedefinitionid=c.combotoussedefinitionid where  ");
 		stringBuffer.append(SqlUtils.getNonStringFieldInLargeCollectionsPredicate("td.id", tdIds));
-		stringBuffer.append(" and tdcom.handlerDepartCode='"+ orgUnitCoding +"' ");
+		stringBuffer.append(" and ch.orgunitcode='"+ orgUnitCoding +"' ");
 		ResultSet rs = null;
 		Map<Long,JSONObject> infoMap = new HashMap<Long, JSONObject>();
 		JSONArray arr = new JSONArray();