Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordListSqlGenerator.java
===================================================================
diff -u -r26675 -r26800
--- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordListSqlGenerator.java	(.../RecyclingRecordListSqlGenerator.java)	(revision 26675)
+++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordListSqlGenerator.java	(.../RecyclingRecordListSqlGenerator.java)	(revision 26800)
@@ -180,12 +180,12 @@
 			sql = "SELECT TOP 20 * FROM " + tempSql + " WHERE id not in "
 					+ tempSql2;
 		} else if (dbConnection.isOracle()) {
-			sql = "SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT r.*,p.type,p.remark,p.submitTime FROM " + RecyclingRecord.class.getSimpleName() 
+			sql = "SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT r.*,p.type,p.remark,p.submitTime,p.recyclingStatus "+ extraQuery +" FROM " + RecyclingRecord.class.getSimpleName() 
 					+ " r left join " + InvoicePlan.class.getSimpleName() + " p on r.recyclingApplication_id = p.id where r.orgUnitCoding = '"
 					+ orgUnitCodingFromSupplyRoomConfig
 					+ "' and " 
 					+ filterSql
-					+ " order by "+recyclingAmountNeedConfirmOrder+" r.recyclingTime desc) A WHERE ROWNUM <= "
+					+ " order by "+orderSqlOfUrgent + recyclingAmountNeedConfirmOrder+" r.recyclingTime desc) A WHERE ROWNUM <= "
 					+ end
 					+ ")WHERE RN >= " + start;
 		}