create or replace view vw_yj_grsrcxtj as
select
    'N' as SFYP00,
    '门诊' as MZZYBZ,
    c.XM0000,
    f.KJXMID,
    f.KJXMMC,
    c.XMMC00,
    c.XMDJ00,
    c.XMGG00,
    round(a.ZXCS00/decode(b.SL0000,0,1,b.SL0000)*c.XMSL00,2) as ZXSL00,
    c.XMDW00,
    round(a.ZXCS00/decode(b.SL0000,0,1,b.SL0000)*c.HJJE00,2) as HJJE00,
    0 GJJE00,
    (select ZWXM00||'/'||XKH000 from BM_YGBM00 where YGBH00 = a.ZXR000) as ZXRXM0,
    a.ZXRQ00,
    (select BMMC00 from BM_BMBM00 where BMBH00 = c.ZXKS00) as BMMC00,
    a.ZXR000,
    c.ZXKS00,
    c.KDYS00,
    c.KDKS00,
    f.XSXLH0,
    a.ZXSJ00,
    b.KDRQ00||b.KDSJ00 as KDRQSJ
 from YJ_YWZXJL a,YJ_YW0000 b,SF_FYMX00 c,BM_YYKJXM f
where a.YJDJH0 = b.YJDJH0 
  and to_char(b.YJDJH0) = c.YJDJH0 
  and c.KJXMID = f.KJXMID
  and c.SFLB00 <> '3' 
  and b.MZZYBZ = '0' 
union all
select 
    'N' as SFYP00,
    '住院' as MZZYBZ,
    c.XM0000,
    f.KJXMID,
    f.KJXMMC,
    c.XMMC00,
    c.XMDJ00,
    c.XMGG00,
    round(a.ZXCS00/decode(b.SL0000,0,1,b.SL0000)*c.XMSL00,2) as ZXSL00,
    c.XMDW00,
    round(a.ZXCS00/decode(b.SL0000,0,1,b.SL0000)*c.HJJE00,2) as HJJE00,
    0 GJJE00,
    (select ZWXM00||'/'||XKH000 from BM_YGBM00 where YGBH00 = a.ZXR000) as ZXRXM0,
    a.ZXRQ00,
    (select BMMC00 from BM_BMBM00 where BMBH00 = c.ZXKS00) as BMMC00,
    a.ZXR000,
    c.ZXKS00,
    c.KDYS00,
    c.KDKS00,
    f.XSXLH0,
    a.ZXSJ00,
    b.KDRQ00||b.KDSJ00 as KDRQSJ
 from YJ_YWZXJL a,YJ_YW0000 b,ZY_FYMX00 c,BM_YYKJXM f,yj_ywjj00 e
where a.YJDJH0 = b.YJDJH0 
  and b.SFDJH0 = c.DJH000 
  and b.yjdjh0=e.yjdjh0
  --and b.YJDJH0 = c.DJID00   ---aaa
  and c.mxid00=e.mxid00
  and c.KJXMID = f.KJXMID
  and c.SFLB00 <> '3' 
  and b.MZZYBZ = '1';