CREATE OR REPLACE VIEW VW_YK_YPCKFX AS
SELECT
  BMBH00,
  BH0000,
  FLAG00,
  BMMC00,
  PYSM00,
  WBSM00,
  BMXZ00
  FROM  BM_BMBM00 B
  WHERE B.CZBZ00<>'2' AND  FLAG00='1' --AND BMXZ00<>'4'  --BMXZ00 IN ('0','1','2','3','5','7','6','9','a')
  and BMXZ00 is not null and nvl(b.sfyx00,'1')='1'
union all
    SELECT
        99998,
        '0',
        '1',
        '³é¼ì³ö¿â',
        'cjck',
        'rsby',
        '-1'
    FROM DUAL 
union all    
    SELECT
        88888,
        '0',
        '1',
        '±¨Ëð³ö¿â',
        'bsck',
        'rrby',
        '-1'
    FROM DUAL
;