CREATE OR REPLACE VIEW VW_BQ_YF0000 AS
SELECT 
      BMMC00,BH0000,WBSM00,PYSM00,BMBH00,BMXZ00,
      decode(bmxz00,'2','ΓΕΥο','3','Χ‘ΤΊ','²»Οκ')"MZZY00"
from  BM_BMBM00  
where CZBZ00<>'2' and bmxz00 in ('2','3') AND FLAG00='1'
and yyid00='229112'