Index: ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java =================================================================== diff -u -r28997 -r29003 --- ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java (.../DiposableGoodsManagerImpl.java) (revision 28997) +++ ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java (.../DiposableGoodsManagerImpl.java) (revision 29003) @@ -3294,7 +3294,7 @@ ,DisposableGoodsStock.class.getSimpleName() ,wareHouseId,SqlUtils.getStringFieldInLargeCollectionsPredicate("dg.id", amountAndIdsMap.keySet()));; }else if(DatabaseUtil.isOracle(dbConnection.getDatabase())){ - sql = String.format("select dgs.id disposableGoodsStockId,dg.ttsName,dg.name showTousseName,dg.id,dg.barcode,dg.referencePrice,(case when dg.specification is null then dg.name else dg.name || '[' || dg.specification || ']' end) name,dgs.amount from %s dg " + sql = String.format("select dgs.id disposableGoodsStockId,dg.ttsName,dg.applicationSpecification,dg.specification,dg.name showTousseName,dg.id,dg.barcode,dg.referencePrice,(case when dg.specification is null then dg.name else dg.name || '[' || dg.specification || ']' end) name,dgs.amount from %s dg " + " join %s dgs on dg.id=dgs.disposableGoodsID" + " where dgs.warehouseID= %s and %s " ,DisposableGoods.class.getSimpleName()