CREATE OR REPLACE VIEW VW_YF_YPGHDW AS
SELECT
  BMBH00,  
  BH0000,  
  FLAG00,  
  BMMC00,  
  PYSM00,  
  WBSM00, 
  BMXZ00  
      --'0'住院临床科室，'1'门诊临床科室
      --'2'门诊药房，'3',住院药房，'4'收费处，
      --'5'医技科室,'6'药库,'7'外单位
      --'9'病区
  FROM  BM_BMBM00 B
  WHERE B.CZBZ00<>'2' AND FLAG00='1' and b.sfyx00='1'
UNION ALL
    SELECT
        99999,
        '0',
        '0',
        '盘盈入库',
        '',
        '',
        '7'
    FROM DUAL
UNION ALL
    SELECT
        77777,
        '0',
        '0',
        '调价报盈',
        '',
        '',
        '7'
    FROM DUAL
UNION ALL
    SELECT
        99998,
        '0',
        '0',
        '特殊病人纯消费账户',
        '',
        '',
        '7'
    FROM DUAL
UNION ALL
    SELECT
        66666,
        '0',
        '0',
        '处方调价',
        '',
        '',
        '7'
    FROM DUAL
UNION ALL
    SELECT
        88888,
        '0',
        '0',
        '报损出库',
        '',
        '',
        '7'
    FROM DUAL
;