Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java
===================================================================
diff -u -r29260 -r29266
--- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java	(.../PackingManagerImpl.java)	(revision 29260)
+++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java	(.../PackingManagerImpl.java)	(revision 29266)
@@ -735,14 +735,14 @@
 		}
 		//外部代理灭菌
 		sql += " union all select d.name,i.reviewer as reviewer,d.isTraceable " +
-				 "from tousseInstance i,tousseDefinition d where i.toussedefinition_id = d.id and d.id=t.tousseDefinitionId and d.tousseType in ('"+TousseDefinition.PACKAGE_TYPE_FOREIGNPROXY+"') "
+				 "from tousseInstance i,tousseDefinition d,cssdHandleTousses t where i.toussedefinition_id = d.id and d.id=t.tousseDefinitionId and d.tousseType in ('"+TousseDefinition.PACKAGE_TYPE_FOREIGNPROXY+"') "
 				 + "and i.reviewTime between "+dateQueryAdapter.dateConverAdapter2(startDateTime, fmt)+" and "
 				 + dateQueryAdapter.dateConverAdapter2(endDateTime, fmt)
 				 + " and t.taskGroup = '"
 				 + taskGroup
 				 + "' and t.orgUnitCode = '"
 				 + orgUnitCode
-				 + " and i.orgUnitCoding = '"
+				 + "' and i.orgUnitCoding = '"
 				 + orgUnitCode
 			+ "' ";
 		sql += ") alias group by alias.name,alias.reviewer, alias.isTraceable";