Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java
===================================================================
diff -u -r29376 -r29617
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java	(.../InvoicePlanOptimizeManagerImpl.java)	(revision 29376)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java	(.../InvoicePlanOptimizeManagerImpl.java)	(revision 29617)
@@ -668,7 +668,7 @@
 						if(hideUnprintedTousseItems){
 							tousseItemCondition = String.format("%s and (%s and "+ tableColumnAliasPre +"isPrinted=%s or %s)", tousseItemCondition , 
 									SqlUtils.getStringFieldInLargeCollectionsPredicate(tableColumnAliasPre +"tousseType", hideUnprintedTousseItemTousseTypeList),1,
-									SqlUtils.getStringFieldNotInCollectionsPredicate("tousseType", hideUnprintedTousseItemTousseTypeList));
+									SqlUtils.getStringFieldNotInCollectionsPredicate(tableColumnAliasPre +"tousseType", hideUnprintedTousseItemTousseTypeList));
 						}
 						if(CollectionUtils.isNotEmpty(tousseGroupIdList) 
 								&& CollectionUtils.isNotEmpty(sterilingMethodList)){