Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java
===================================================================
diff -u -r29259 -r29271
--- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java	(.../RecyclingRecordManagerImpl.java)	(revision 29259)
+++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java	(.../RecyclingRecordManagerImpl.java)	(revision 29271)
@@ -649,7 +649,7 @@
 					String draftSql = String.format(" where po.tousseDefinitionId=%s and po.materialDefinitionId=%s "
 							+ "and (po.linkType is null or po.linkType<>'%s') "
 							+ "and po.type='%s' and po.status=%s "
-							+ "and po.id in (select errorDamageDetail_id from recyclingItem_errorDamage where recyclingItem_id=%s)", 
+							+ "and po in (select edd from RecyclingItem ri join ri.errorDamageDetails edd where recyclingItem_id=%s)", 
 							tousseDefinitionID,materialDefinitionId,
 							MaterialErrorDamageDetail.LINKTYPE_USERECORD,itemType,
 							MaterialErrorDamageDetail.STATUS_TWO,