diff --git a/src-db/database/model/views/OBAWO_WAREHOUSEOPS_V.xml b/src-db/database/model/views/OBAWO_WAREHOUSEOPS_V.xml
--- a/src-db/database/model/views/OBAWO_WAREHOUSEOPS_V.xml
+++ b/src-db/database/model/views/OBAWO_WAREHOUSEOPS_V.xml
@@ -1,4 +1,4 @@
 <?xml version="1.0"?>
   <database name="VIEW OBAWO_WAREHOUSEOPS_V">
-    <view name="OBAWO_WAREHOUSEOPS_V"><![CDATA[SELECT sd.m_product_id, sd.m_locator_id, sd.m_attributesetinstance_id, sd.c_uom_id, sd.m_product_uom_id, sd.qtyonhand, sd.qtyorderonhand, sd.datelastinventory, sd.preqtyonhand, sd.preqtyorderonhand, sd.ad_client_id, sd.ad_org_id, sd.isactive, sd.created, sd.createdby, sd.updated, sd.updatedby, sd.m_storage_detail_id AS obawo_warehouseops_v_id, sd.m_storage_detail_id, sd.reservedqty, sd.allocatedqty, 'N' AS generate_invprop, 'N' AS generate_recount, 'N' AS move, 'N' AS putaway, 'N' AS change_status, l.m_warehouse_id, l.em_obawo_locator_group_id AS obawo_locator_group_id, lg.obawo_internal_routing_area_id, l.m_inventorystatus_id, 'N' AS boxinplanned, 'N' AS unbox, sd.m_refinventory_id FROM m_storage_detail sd JOIN m_locator l ON sd.m_locator_id = l.m_locator_id JOIN obawo_locator_group lg ON l.em_obawo_locator_group_id = lg.obawo_locator_group_id WHERE sd.qtyonhand <> 0 AND (EXISTS (SELECT 1 FROM ad_orginfo oi WHERE oi.ad_org_id = sd.ad_org_id AND oi.em_obawo_awo_flow = 'Y'))]]></view>
+    <view name="OBAWO_WAREHOUSEOPS_V"><![CDATA[SELECT sd.m_product_id, sd.m_locator_id, sd.m_attributesetinstance_id, sd.c_uom_id, sd.m_product_uom_id, sd.qtyonhand, sd.qtyorderonhand, sd.datelastinventory, sd.preqtyonhand, sd.preqtyorderonhand, sd.ad_client_id, l.ad_org_id, sd.isactive, sd.created, sd.createdby, sd.updated, sd.updatedby, sd.m_storage_detail_id AS obawo_warehouseops_v_id, sd.m_storage_detail_id, sd.reservedqty, sd.allocatedqty, 'N' AS generate_invprop, 'N' AS generate_recount, 'N' AS move, 'N' AS putaway, 'N' AS change_status, l.m_warehouse_id, l.em_obawo_locator_group_id AS obawo_locator_group_id, lg.obawo_internal_routing_area_id, l.m_inventorystatus_id, 'N' AS boxinplanned, 'N' AS unbox, sd.m_refinventory_id FROM m_storage_detail sd JOIN m_locator l ON sd.m_locator_id = l.m_locator_id JOIN obawo_locator_group lg ON l.em_obawo_locator_group_id = lg.obawo_locator_group_id WHERE sd.qtyonhand <> 0 AND (EXISTS (SELECT 1 FROM ad_orginfo oi WHERE oi.ad_org_id = l.ad_org_id AND oi.em_obawo_awo_flow = 'Y'))]]></view>
   </database>

