Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java =================================================================== diff -u -r35736 -r35737 --- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java (.../PackingManagerImpl.java) (revision 35736) +++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java (.../PackingManagerImpl.java) (revision 35737) @@ -10174,7 +10174,7 @@ 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(" pt on pt.tousseDefinition_id=td.id join "+ ComboTousseOrgUint.class.getSimpleName() +" ct on ct.combotoussedefinitionid=c.combotoussedefinitionid and ct.unitcode=pt.departcoding where "); stringBuffer.append(SqlUtils.getNonStringFieldInLargeCollectionsPredicate("td.id", tdIds)); stringBuffer.append(" and ch.orgunitcode='"+ orgUnitCoding +"' "); ResultSet rs = null;