SELECT * from view_smas_submas where BRAND_NAME='' and STO_CODE=''
ITEM CODE
DESCRIPTION
BRAND
COST
SELLING
DEPARTMENT STOCK
ALL STOCK