Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordListSqlGenerator.java
===================================================================
diff -u -r12865 -r12923
--- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordListSqlGenerator.java	(.../RecyclingRecordListSqlGenerator.java)	(revision 12865)
+++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordListSqlGenerator.java	(.../RecyclingRecordListSqlGenerator.java)	(revision 12923)
@@ -140,7 +140,7 @@
 	
 	public String getCountSql(){
 		String countSql = "select count(*) from RecyclingRecord r left join InvoicePlan p on r.recyclingApplication_id = p.id" 
-				+ " where r.orgUnitCoding = '" 
+				+ " where p.handleDepartCoding = '" 
 				+ AcegiHelper.getLoginUser().getOrgUnitCodingFromSupplyRoomConfig() 
 				+ "' and " 
 				+ filterSql;