CREATE OR REPLACE VIEW VW_YF_YPCKFX 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'  
UNION ALL
    SELECT
        99999,
        '0',
        '0',
        '盘盈出库',
        '',
        '',
        '7'
    FROM DUAL
UNION ALL
    SELECT
        77777,
        '0',
        '0',
        '调价报亏',
        '',
        '',
        '7'
    FROM DUAL
UNION ALL
    SELECT
        88888,
        '0',
        '0',
        '报损出库',
        '',
        '',
        '7'
    FROM DUAL
UNION ALL
    SELECT
        55555,
        '0',
        '0',
        '个人借药',
        'grjy',
        'wwwa',
        '7'
    FROM DUAL
UNION ALL
    SELECT
        99998,
        '0',
        '0',
        '抽检出库',
        'cjck',
        '',
        '7'
    FROM DUAL
;