create or replace view vw_bq_ysfwjc as
select a."YJDJH0",a."YJFZH0",a."BRID00",a."ZYGHID",a."ZYHGHH",a."MZZYBZ",a."BRXM00",a."XB0000",a."CSRQ00",a."YEXM00",a."ZLXMID",a."ZLXMJC",a."SL0000",a."ZXSL00",a."DW0000",a."YJKSBH",a."KDYS00",a."KDYSXM",a."KDKSBH",a."YSSZKS",a."KDRQ00",a."KDSJ00",a."LRXM00",a."JZBZ00",a."FBZXBZ",a."BWMC00",a."APRXM0",a."APRQ00",a."APSJ00",a."JGLR00",a."ZXR000",a."ZXRXM0",a."ZXRQ00",a."ZXSJ00",a."ZDID00",a."ZDMC00",a."JGBGRQ",a."JGBGYS",a."BGYSXM",a."XMZT00",a."SFDJH0",a."YZCFID",a."YPNM00",a."DCBZ00",a."TQPC00",a."CXDJH0",a."ZJE000",a."BZ0000",a."YJLRBZ",a."KDBQ00",a."JGZCBZ",a."BQSFBZ",a."CH0000",a."NL0000",a."JZQRR0",a."ZLDCCF",a."SM0000",a."JZQRRQ",a."JZQRSJ",a."ZHXMID",a."YJDJDY",a."BBID00",a."CFID00",a."MC0000",a."BH0000",a."CXSL00",a."TXM000",a."DYRQTM",a."DYSJTM",a."JCQZY0",a."SQID00",a."QSPC00",a."QSRQ00",a."QSSJ00",a."QSR000",a."QSRXM0",a."ZSDYMC",a."TSBSMC",a."DYBGRQ",a."SYLSH0",a."SMKSBH",a."ZXYS00",a."CJKSBH",a."YYID00",a."ZPJLID",a."ZHJE00",a."QRYSBH",a."QRRQ00",a."BBZT00",a."KYXMMC",a."FJDJBZ",a."HBDJH0",a."BWBH00",a."HBXHID",a."YZLX00",a."YSZID0",a."ZRZYLS",a."APNUM0",a."YBSSSH",a."APJCZS",a."YYID01",a."DYRQXX",a."DYSJXX",a."DYCZY0",a."ZRYJDH",a."LRY000",a."SFXYSH",a."DQKS00",a."BRPIC0",a."SHZT00",a."JKZT00",a."SFBLJC",a."SFMZJC",a."JCHRBZ",a."WZBM00",a."SSBM00",a."SSMC00",a."SSYJDH",a."WZBH00",a."ZXDCBZ",a."CZBZ00",a."HISYJH",a."APNUM2",a."DWZBID",a."BBBZ00",a."LLBZ00",a."CXSHR0",a."APSJD0",a."LRKS00",a."TCID00",a."TCNWBZ",a."XMZK00",a."SQZCID",a."LJID00",a."BRZXJD",a."JHMXID",a."BYYY00",a."LJYZMX",a."WDWID0",a."MBRCID",a."DJID00",a."DJMXID",a."HBZYXM",a."SFZF00",a."SJBBMC",a."YYGXJG",a."BQZY00",a."BWID00",a."TFSHR0",a."TFSHRQ",a."TFSHSJ",a."SJLY00",a."YWKSRQ",a."YWJSRQ",a."SFFR00",a."DCNYJ0",a."JZDH00",a."ZXYSZ0",a."SFMFBZ",a."KDYSZ0",(select BMMC00 from BM_BMBM00 where BMBH00 = a.YJKSBH) BMMC00,
decode(XMZT00, '2', '已收费','3','已执行', '已收费') XMZTMC
from YJ_YW0000 a,BM_ZlZD00 d
where a.ZLXMID in (select ZLXMID from BM_ZLZD00 where LBBH00 = '3')
   and a.ZLXMID=d.ZLXMID
   and a.MZZYBZ = '1'
   and SFDJH0 > 0
   and a.XMZT00 ='2'
   and a.cxdjh0 is  null
   and instr(nvl(a.BZ0000,' '),'门诊转住院')<=0
   and not exists (select 1
          from YJ_YW0000
          where CXDJH0 = a.YJDJH0
           and SFDJH0 > 0
           and ZYGHID = a.ZYGHID)
           and d.lbbh00='3';