select materialmg0_.M_Storage_Detail_ID as col_0_0_, product1_.M_Product_ID as col_1_0_, ad_column_identifier_std('m_product', product1_.M_Product_ID) as col_2_0_, product1_.UPC as col_3_0_, uom5_.C_UOM_ID as col_4_0_, coalesce(uom5_.UOMSymbol, uom5_.Name) as col_5_0_, coalesce(uom5_.StdPrecision, 2) as col_6_0_, (select productaum7_.C_Uom_ID from M_Product_AUM productaum7_ cross join C_UOM uom8_ where productaum7_.C_Uom_ID=uom8_.C_UOM_ID and productaum7_.M_Product_ID=product1_.M_Product_ID and productaum7_.Logistics='P') as col_7_0_, (select productaum9_.Conversionrate from M_Product_AUM productaum9_ where productaum9_.M_Product_ID=product1_.M_Product_ID and productaum9_.Logistics='P') as col_8_0_, m_getjsondescription(attributes4_.M_AttributeSetInstance_ID, 'Y', '192') as col_9_0_, materialmg0_.QtyOnHand as col_10_0_, locator2_.M_Locator_ID as col_11_0_, locator2_.Value as col_12_0_, locator2_.Barcode as col_13_0_, locator2_.M_InventoryStatus_ID as col_14_0_, locator2_.EM_Obawo_Occupancy as col_15_0_, locator2_.EM_Obawo_Occupancy_Pending as col_16_0_, materialmg6_.Value as col_17_0_, warehouse3_.M_Warehouse_ID as col_18_0_, warehouse3_.Value as col_19_0_, warehouse3_.Name as col_20_0_ from M_Storage_Detail materialmg0_ left outer join M_Product product1_ on materialmg0_.M_Product_ID=product1_.M_Product_ID left outer join M_Locator locator2_ on materialmg0_.M_Locator_ID=locator2_.M_Locator_ID left outer join M_Warehouse warehouse3_ on locator2_.M_Warehouse_ID=warehouse3_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes4_ on materialmg0_.M_AttributeSetInstance_ID=attributes4_.M_AttributeSetInstance_ID left outer join C_UOM uom5_ on materialmg0_.C_UOM_ID=uom5_.C_UOM_ID left outer join M_RefInventory materialmg6_ on materialmg0_.M_RefInventory_ID=materialmg6_.M_RefInventory_ID where materialmg0_.QtyOnHand>0 and locator2_.M_Warehouse_ID='FCA81F56E9E643E096E86F5F379459FB' and materialmg0_.QtyOnHand-(select coalesce(sum(obawo_task10_.Expected_Qty), 0) from OBAWO_task obawo_task10_ where obawo_task10_.Status='AV' and obawo_task10_.M_Storage_Detail_ID=materialmg0_.M_Storage_Detail_ID)>0 and (upper(product1_.Value) like '%5503-BVV%' or upper(product1_.UPC) like '%5503-BVV%' or upper(product1_.Name) like '%5503-BVV%' or upper(locator2_.Value) like '%5503-BVV%' or upper(attributes4_.Description) like '%5503-BVV%') order by locator2_.Value asc limit '101'