Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java =================================================================== diff -u -r36541 -r36631 --- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java (.../RecyclingApplicationManagerImpl.java) (revision 36541) +++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java (.../RecyclingApplicationManagerImpl.java) (revision 36631) @@ -8198,7 +8198,7 @@ @Override public InvoicePlan getRecycleApplicationByTousseBarcode(String instantceBarcode){ String sql = String - .format("where po.committedStatus = 1 and po.endStatus is null and po.tousseBarcodes like '%%%s%%'", instantceBarcode); + .format("where po.committedStatus = 1 and (po.endStatus is null or po.endStatus<>'"+ InvoicePlan.STATUS_END +"' ) and po.tousseBarcodes like '%%%s%%'", instantceBarcode); return (InvoicePlan)objectDao.getBySql(InvoicePlan.class.getSimpleName(), sql); }