Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/signRecord/service/SignRecordManagerImpl.java =================================================================== diff -u -r37194 -r37245 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/signRecord/service/SignRecordManagerImpl.java (.../SignRecordManagerImpl.java) (revision 37194) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/signRecord/service/SignRecordManagerImpl.java (.../SignRecordManagerImpl.java) (revision 37245) @@ -401,15 +401,17 @@ + "%s i where ((ti.invoice2_id is not null and i.id = ti.invoice2_id) or (ti.invoice2_id is null and i.id = ti.invoice_id)) " + "and %s " + "and %s " - + "and i.departCoding = '%s'", + + "and i.departCoding = '%s' " + + "and ti.status = '%s'", TousseInstance.class.getSimpleName(), BarcodeDevice.class.getSimpleName(), TousseDefinition.class.getSimpleName(), TousseDefinition.class.getSimpleName(), Invoice.class.getSimpleName(), SqlUtils.getNonStringFieldInLargeCollectionsPredicate("i.id",invoiceIds), SqlUtils.getNonStringFieldInLargeCollectionsPredicate("tdAncestor.id", ancestorIdSet), - departCoding); + departCoding, + TousseInstance.STATUS_SHIPPED); return tousseSql; }