service/Wom/WomdaahbManager.cs
@@ -238,7 +238,8 @@ left join mes_items m on M.ID = b.dab003 left join MES_UNIT u on u.id = ahbl.UNIT left join [dbo].[v_caa] v on v.guid = a.guid WHERE ahb.daahb001 = '{0}' AND D.ISSUE_TYPE = 1 LEFT JOIN MES_BACK_FLASH F ON b.dab003 = F.ItemId WHERE ahb.daahb001 = '{0}' AND D.ISSUE_TYPE = 1 AND (F.ItemId is null OR F.checkStatus<>1) group by m.item_no ORDER BY m.item_no ", query.hbNo);