Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java
===================================================================
diff -u -r33314 -r33323
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java	(.../InvoicePlanOptimizeManagerImpl.java)	(revision 33314)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java	(.../InvoicePlanOptimizeManagerImpl.java)	(revision 33323)
@@ -1275,7 +1275,7 @@
 									tousseItemCondition = String.format("%s and (%s or "+ tableColumnAliasPre +"tousseDefinitionId is not null)", tousseItemCondition , 
 											SqlUtils.getStringFieldInLargeCollectionsPredicate(tableColumnAliasPre +"disposableGoodsType", disposableGoodsTypeList));
 								}else if(CollectionUtils.isNotEmpty(tousseGroupIdList)){
-									tousseItemCondition = String.format("%s and ("+ tableColumnAliasPre +"tousseDefinitionId in(select * from %s where ancestorID in (select id from %s where %s)) or "+ tableColumnAliasPre +"disposableGoodsId is not null)", 
+									tousseItemCondition = String.format("%s and ("+ tableColumnAliasPre +"tousseDefinitionId in(select id from %s where ancestorID in (select id from %s where %s)) or "+ tableColumnAliasPre +"disposableGoodsId is not null)", 
 											tousseItemCondition , TousseDefinition.class.getSimpleName() , 
 											TousseDefinition.class.getSimpleName(),
 											SqlUtils.getNonStringFieldInLargeCollectionsPredicate("tousseGroupID", tousseGroupIdList));