--1、写入SF_JZB000 jzdh00=14863784
insert into SF_JZB000(JZDH00,BRID00,MZID00,BRZJE0,JZJE00,GFJE00,HJJE00,JMJE00,GRZHZF,TCJJZF,ZFJE00,PJH000,JZRQ00,JZSJ00,JZY000,JMYY00,TSBZBH,JFLBID,FBBH00,YBLB00,              YBBRLB,YBZXLB,CZYKS0,YBDJH0,YBGHH0,ZYYBJK,TMLJ00,BXLB00,MXLSH0,ZZFKJE,
XJFKJE,YBJZRQ,YBJZSJ,ybxjzf, MZBZJE,SYBXJE,YBYL14,YBYL15,YBYL16,YBYL17,YBYL18,YBYL19,YBYL20,YBYL21,YBYL22,YBYL23, YBYL24,YBYL25,YBYL26,YBYL27,YBYL28,YBYL29,YBYL30,YBYL31,YBYL32,YBYL46,
                        YBYL47,YBYL48,YBYL49,YBYL50,YBYL51,YBYL52,YBYL53,YBYL54,YBYL55,YBYL56,
                        YBYL57,YBYL58,YBYL59,YBYL60,YBYL61,YBYL62,YBYL63,YBYL64,YBYL65,YBYL66,
                        YBYL67,YBYL68,YBYL69
                        )
                  select a.jzdh00,a.brid00,
                        (select mzh000 from sf_fymx00 where jzdh00=a.jzdh00 and rownum=1),
                        (select sum(hjje00) from sf_fymx00 where jzdh00=a.jzdh00),  --ls_HJJE00,
                        (select sum(jzje00) from sf_fymx00 where jzdh00=a.jzdh00),--ls_JZJE00,
                        0,--ls_JMJE00,
                        (select sum(hjje00) from sf_fymx00 where jzdh00=a.jzdh00),--ls_HJJE00,
                        0, --ls_YHJE00,0,
                        a.grzhzf, --GRZHZF
                        a.TCJJZF, --TCJJZF
                        
                        a.zfje00,--(select sum(zfje00) from sf_fymx00 where jzdh00=a.jzdh00),--ls_ZFJE00,
                        0,--decode(as_SFDYFP,'N',decode(ls_SFDYMZFPSJ,'Y',ls_PJH000,0),ls_PJH000),
                        a.CZRQ00,
                        a.CZSJ00,
                        a.czy000,  --JZY000,
                        '',--as_JMYY00,
                        a.TSBZBH,--as_tsbzbh,
                        1,--ad_JFLBID,
                        b.fbbh00,
                        b.yblb00,
                        
                        b.YBBRLB,
                        c.YBZXLB,
                        2112,--ad_JZYKS0,
                        a.YBDJH0,
                        a.YBGHH0,a.ZYYBJK,a.TMLJ00,a.BXLB00,a.MXLSH0,a.ybzfje,
                        a.zfje00,a.YBSFRQ,a.YBSFSJ,a.zfje00,0,0,
                        YBYL14,YBYL15,YBYL16,YBYL17,YBYL18,YBYL19,YBYL20,YBYL21,YBYL22,YBYL23,
                        YBYL24,YBYL25,YBYL26,YBYL27,YBYL28,YBYL29,YBYL30,YBYL31,YBYL32,YBYL46,
                        YBYL47,YBYL48,YBYL49,YBYL50,YBYL51,YBYL52,YBYL53,YBYL54,YBYL55,YBYL56,
                        YBYL57,YBYL58,YBYL59,YBYL60,YBYL61,YBYL62,YBYL63,YBYL64,YBYL65,YBYL66,
                        YBYL67,YBYL68,YBYL69
                from bm_ybjs00 a,BM_BRXXB0 b,ic_ybbrlb c
                  where a.brid00=b.brid00 and b.fbbh00=c.fbbh00 and b.yblb00=c.yblb00
                    and a.jzdh00 =14863784;       
                    
--2、写入SF_JZMX00 jzdh00=14863784
    insert into SF_JZMX00(JZDH00,XMBH00,XMMC00,XMJE00,JMJE00,JMSHR0,JMYY00,ZFBL00,QZFJE0,TCHXJE)
         select a.JZDH00,B.FPXMID,B.XMMC00,sum(A.HJJE00),sum(a.JMJE00),null,null,1,sum(a.QZFJE0),sum(decode(TCNWBZ,'1',a.HJJE00,0))
                       from  SF_FYMX00 A,BM_FPXM00 B
                      where  A.MZFPID = B.FPXMID
                        and  A.JZDH00 = 14863784
                        and  A.JFLBID = 1       --JFLBID=1是门诊预交金账户
                   group by   a.JZDH00,B.FPXMID,B.XMMC00;

--3、写入SF_JZMXXM jzdh00=14863784
    insert into SF_JZMXXM (JZDH00,MXID00,BZ0000) 
      select jzdh00,mxid00,1 from SF_FYMX00 where JZDH00=14863784;