1 11:26:49 SQL Execute: ORACLE - select count(*) from VW_BM_JSGJBM where GJBM00='320200002' and sfxmid=8000134098 and GJBM00 in ('320200002') 2 11:26:49 SQL Execute: ORACLE - COMMIT WORK 3 11:26:49 SQL Execute: ORACLE - update YJ_YW0000 SET XMZT00='1' WHERE Yjdjh0=49985539 4 11:26:49 SQL Data In: ORACLE - Rows affected = 1 5 11:26:49 SQL Execute: ORACLE - Commit 6 11:26:49 SQL Data In: ORACLE - Rows affected = 0 7 11:26:49 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 ,j.ZTM000,j.CTM000,j.BSM000,j.HCID00,j.HCDJ00,j.HCPH00,j.HCGYS0,j.HCYXQ0,j.HCZCZH from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=49985539 8 11:26:50 SQL Execute: ORACLE - select SF_ZS_BRSFCRGLPD('674923') res from dual 9 11:26:50 SQL Execute: ORACLE - Select b.zdmc00 zdmc00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='1' and brid00=2637906 and (YJKSBH=2018 or ((b.Zlxmid,kdksbh) in (Select Zlxmid,kdksbh from vw_XT_xmfwfx where jsxmks=2018 ))) and kdrq00 between '20191114' and '20191214' and rownum=1 10 11:26:50 SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,b.ZLDCCF,b.CXSL00,b.txm000,b.ZXKSMC,b.JSCS00,b.CFID00,b.LJBZ00,b.sqid00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='1' and brid00=2637906 and (YJKSBH+0=2018 or (b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=2018)) or ((b.Zlxmid,kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=2018) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=2018) ))) and kdrq00 between '20191114' and '20191214' and ((b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0) or (b.mzzybz='0' and b.jscs00>0)) order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid 11 11:26:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 12 11:26:50 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 13 11:26:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2637906.000000 14 11:26:50 SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00 from BM_BRXXB0 a,IC_YBBRLB b where A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 15 11:26:50 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 ,j.ZTM000,j.CTM000,j.BSM000,j.HCID00,j.HCDJ00,j.HCPH00,j.HCGYS0,j.HCYXQ0,j.HCZCZH from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=49985539 16 11:26:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2637906.000000 17 11:26:50 SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00 from BM_BRXXB0 a,IC_YBBRLB b where A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 18 11:26:50 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 ,j.ZTM000,j.CTM000,j.BSM000,j.HCID00,j.HCDJ00,j.HCPH00,j.HCGYS0,j.HCYXQ0,j.HCZCZH from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=49985539 19 11:26:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2637906.000000 20 11:26:50 SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00 from BM_BRXXB0 a,IC_YBBRLB b where A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 21 11:26:50 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 ,j.ZTM000,j.CTM000,j.BSM000,j.HCID00,j.HCDJ00,j.HCPH00,j.HCGYS0,j.HCYXQ0,j.HCZCZH from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=49985539 22 11:26:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 23 11:26:50 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 24 11:26:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2637906.000000 25 11:26:50 SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00 from BM_BRXXB0 a,IC_YBBRLB b where A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 26 11:26:50 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 ,j.ZTM000,j.CTM000,j.BSM000,j.HCID00,j.HCDJ00,j.HCPH00,j.HCGYS0,j.HCYXQ0,j.HCZCZH from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=49985539 27 11:26:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 28 11:26:50 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 29 11:26:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2637906.000000 30 11:26:50 SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00 from BM_BRXXB0 a,IC_YBBRLB b where A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 31 11:26:50 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 ,j.ZTM000,j.CTM000,j.BSM000,j.HCID00,j.HCDJ00,j.HCPH00,j.HCGYS0,j.HCYXQ0,j.HCZCZH from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=49985539 32 11:27:48 SQL Execute: ORACLE - select fbzxbz from yj_yw0000 where yjdjh0=49985539 33 11:27:50 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 674923.000000 34 11:27:50 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 35 11:27:50 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 36 11:27:50 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 37 11:27:50 SQL Data In: ORACLE - Param = 5, Name = V_MZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 38 11:27:50 SQL Data In: ORACLE - Param = 6, Name = V_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 39 11:27:50 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0,V_MZZYBZ => :V_MZZYBZ,V_XTDM00 => :V_XTDM00); END; 40 11:27:50 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 41 11:27:50 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 42 11:27:50 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 43 11:27:50 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 44 11:27:50 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 9999 45 11:27:50 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2018.000000 46 11:27:50 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 47 11:27:50 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 48 11:27:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 49985539 49 11:27:50 SQL Execute: ORACLE - select a.NBID00 from SS_GZHCJK a,YJ_YWJJ00 b where b.yjdjh0=? and b.ID0000=a.JJID00 and a.CKRQ00 IS NULL and a.CXBZ00='Z' 50 11:27:50 SQL Execute: ORACLE - select SF_SS_ESBHighFee('296',4,2018,49985539,'1') from dual 51 11:27:52 SQL Execute: ORACLE - Update SS_GZHCJK a set CKRQ00=to_char(sysdate,'YYYYMMDD'),CKCZY0=4, YNDFSC=?,YNDJSC=? where a.CKRQ00 IS NULL and a.CXBZ00='Z' and JJID00 in (select ID0000 from yj_ywjj00 where YJDJH0=49985539) 52 11:27:52 SQL Data In: ORACLE - Rows affected = 1 53 11:27:52 SQL Execute: ORACLE - Commit 54 11:27:52 SQL Data In: ORACLE - Rows affected = 0 55 11:27:52 SQL Execute: ORACLE - select b.LBBH00,C.ZYZBMC from YJ_YW0000 a,BM_ZLZD00 b,BM_JYZYZB C WHERE a.YJDJH0=49985539 AND a.ZLXMID=b.ZLXMID AND C.ZYZBID(+)=b.ZYZBID 56 11:27:52 SQL Execute: ORACLE - select b.LBBH00,C.ZYZBMC from YJ_YW0000 a,BM_ZLZD00 b,BM_JYZYZB C WHERE a.YJDJH0=49985539 AND a.ZLXMID=b.ZLXMID AND C.ZYZBID(+)=b.ZYZBID 57 11:27:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 58 11:27:52 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 59 11:27:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2637906.000000 60 11:27:52 SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00 from BM_BRXXB0 a,IC_YBBRLB b where A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 61 11:27:52 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 ,j.ZTM000,j.CTM000,j.BSM000,j.HCID00,j.HCDJ00,j.HCPH00,j.HCGYS0,j.HCYXQ0,j.HCZCZH from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=49985539 62 11:27:52 SQL Execute: ORACLE - select SF_ZS_BRSFCRGLPD('674923') res from dual 63 11:27:52 SQL Execute: ORACLE - Select b.zdmc00 zdmc00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='1' and brid00=2637906 and (YJKSBH=2018 or ((b.Zlxmid,kdksbh) in (Select Zlxmid,kdksbh from vw_XT_xmfwfx where jsxmks=2018 ))) and kdrq00 between '20191114' and '20191214' and rownum=1 64 11:27:52 SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,b.ZLDCCF,b.CXSL00,b.txm000,b.ZXKSMC,b.JSCS00,b.CFID00,b.LJBZ00,b.sqid00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='1' and brid00=2637906 and (YJKSBH+0=2018 or (b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=2018)) or ((b.Zlxmid,kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=2018) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=2018) ))) and kdrq00 between '20191114' and '20191214' and ((b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0) or (b.mzzybz='0' and b.jscs00>0)) order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid 65 11:27:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 66 11:27:52 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 67 11:27:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 68 11:27:52 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 69 11:27:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 70 11:27:52 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 71 11:27:52 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 72 11:27:52 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1 73 11:27:52 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 691163 74 11:27:52 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 75 11:27:52 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 76 11:27:52 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 77 11:27:52 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 78 11:27:52 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 79 11:27:52 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 80 11:27:52 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 81 11:27:52 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 82 11:27:52 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 83 11:27:52 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 84 11:27:52 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 85 11:27:52 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 86 11:27:52 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 87 11:27:52 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 88 11:27:52 SQL Data In: ORACLE - Param = 18, Name = PBRZTQK, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 89 11:27:52 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00,PBRZTQK => :PBRZTQK); END; 90 11:27:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 91 11:27:57 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 92 11:27:57 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 93 11:27:57 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1 94 11:27:57 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 691163 95 11:27:57 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 96 11:27:57 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 97 11:27:57 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 98 11:27:57 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 99 11:27:57 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 100 11:27:57 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 101 11:27:57 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 102 11:27:57 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 103 11:27:57 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 104 11:27:57 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 105 11:27:57 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 106 11:27:57 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 107 11:27:57 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 108 11:27:57 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 109 11:27:57 SQL Data In: ORACLE - Param = 18, Name = PBRZTQK, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 110 11:27:57 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00,PBRZTQK => :PBRZTQK); END; 111 11:27:57 SQL Execute: ORACLE - select SF_ZS_BRSFCRGLPD('674923') res from dual 112 11:27:57 SQL Execute: ORACLE - Select b.zdmc00 zdmc00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('3','4') and b.mzzybz='1' and brid00=2637906 and (YJKSBH=2018 or ((b.Zlxmid,kdksbh) in (Select Zlxmid,kdksbh from vw_XT_xmfwfx where jsxmks=2018 ))) and kdrq00 between '20191114' and '20191214' and rownum=1 113 11:27:57 SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,b.ZLDCCF,b.CXSL00,b.txm000,b.ZXKSMC,b.JSCS00,b.CFID00,b.LJBZ00,b.sqid00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('3','4') and b.mzzybz='1' and brid00=2637906 and YJKSBH+0=2018 and zxrq00 between '20191114' and '20191214' order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid 114 11:27:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49979426.000000 115 11:27:57 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 116 11:27:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49979426.000000 117 11:27:57 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 118 11:27:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2637906.000000 119 11:27:57 SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00 from BM_BRXXB0 a,IC_YBBRLB b where A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 120 11:27:57 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 ,j.ZTM000,j.CTM000,j.BSM000,j.HCID00,j.HCDJ00,j.HCPH00,j.HCGYS0,j.HCYXQ0,j.HCZCZH from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=49979426 121 11:28:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49979426.000000 122 11:28:01 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 123 11:28:01 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 124 11:28:01 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1 125 11:28:01 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 691163 126 11:28:01 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 127 11:28:01 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 128 11:28:01 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 129 11:28:01 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 130 11:28:01 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 131 11:28:01 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 132 11:28:01 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 133 11:28:01 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 134 11:28:01 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 135 11:28:01 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 136 11:28:01 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 137 11:28:01 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 138 11:28:01 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 139 11:28:01 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 140 11:28:01 SQL Data In: ORACLE - Param = 18, Name = PBRZTQK, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 141 11:28:01 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00,PBRZTQK => :PBRZTQK); END; 142 11:28:01 SQL Execute: ORACLE - select SF_ZS_BRSFCRGLPD('674923') res from dual 143 11:28:01 SQL Execute: ORACLE - Select b.zdmc00 zdmc00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='1' and brid00=2637906 and (YJKSBH=2018 or ((b.Zlxmid,kdksbh) in (Select Zlxmid,kdksbh from vw_XT_xmfwfx where jsxmks=2018 ))) and kdrq00 between '20191214' and '20191214' and rownum=1 144 11:28:01 SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,b.ZLDCCF,b.CXSL00,b.txm000,b.ZXKSMC,b.JSCS00,b.CFID00,b.LJBZ00,b.sqid00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='1' and brid00=2637906 and (YJKSBH+0=2018 or (b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=2018)) or ((b.Zlxmid,kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=2018) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=2018) ))) and kdrq00 between '20191214' and '20191214' and ((b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0) or (b.mzzybz='0' and b.jscs00>0)) order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid 145 11:28:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 146 11:28:01 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 147 11:28:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 148 11:28:01 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 149 11:28:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 150 11:28:02 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 151 11:28:02 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 152 11:28:02 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1 153 11:28:02 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 691163 154 11:28:02 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 155 11:28:02 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 156 11:28:02 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 157 11:28:02 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 158 11:28:02 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 159 11:28:02 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 160 11:28:02 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 161 11:28:02 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 162 11:28:02 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 163 11:28:02 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 164 11:28:02 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 165 11:28:02 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 166 11:28:02 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 167 11:28:02 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 168 11:28:02 SQL Data In: ORACLE - Param = 18, Name = PBRZTQK, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 169 11:28:02 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00,PBRZTQK => :PBRZTQK); END; 170 11:28:02 SQL Execute: ORACLE - select SF_ZS_BRSFCRGLPD('674923') res from dual 171 11:28:02 SQL Execute: ORACLE - Select b.zdmc00 zdmc00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('3','4') and b.mzzybz='1' and brid00=2637906 and (YJKSBH=2018 or ((b.Zlxmid,kdksbh) in (Select Zlxmid,kdksbh from vw_XT_xmfwfx where jsxmks=2018 ))) and kdrq00 between '20191214' and '20191214' and rownum=1 172 11:28:02 SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,b.ZLDCCF,b.CXSL00,b.txm000,b.ZXKSMC,b.JSCS00,b.CFID00,b.LJBZ00,b.sqid00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('3','4') and b.mzzybz='1' and brid00=2637906 and YJKSBH+0=2018 and zxrq00 between '20191214' and '20191214' order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid 173 11:28:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 174 11:28:02 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 175 11:28:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 176 11:28:02 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 177 11:28:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2637906.000000 178 11:28:02 SQL Execute: ORACLE - select B.YBZXLB,A.YBBRLB, A.FBBH00 from BM_BRXXB0 a,IC_YBBRLB b where A.BRID00=? AND B.YBLB00=a.YBLB00 and B.FBBH00=a.FBBH00 179 11:28:02 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00,s.XMNH00 ,j.ZTM000,j.CTM000,j.BSM000,j.HCID00,j.HCDJ00,j.HCPH00,j.HCGYS0,j.HCYXQ0,j.HCZCZH from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=49985539 180 11:28:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 181 11:28:03 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 182 11:28:05 SQL Execute: ORACLE - Select SQ_SS_GZHCJK_NBID00.NextVal Val from Dual 183 11:28:24 SQL Execute: ORACLE - select SF_SS_ESBGETTXM('1','01123456789','','4','2018') from dual 184 11:28:29 SQL Execute: ORACLE - select SF_SS_ESBGETTXM('2','01123456789','1719120010170899','4','2018') from dual 185 11:28:30 SQL Execute: ORACLE - delete SS_GZHCJK where YJDJH0=49985539 186 11:28:30 SQL Data In: ORACLE - Rows affected = 1 187 11:28:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 49985539 188 11:28:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 189 11:28:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 190 11:28:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 01123456789 191 11:28:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1719120010170899 192 11:28:30 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 235, Scale = 0, Data = 01123456789|1719120010170899|测试物品20190815||CS|||2019-12-31|3.000|170899||8000134098|20190815094000654_4996AD99B43C4754AF28D3487D42D1AC|福建亿能达|舒尔洁|1548.0000|个|||||2|2018|DSA|20190815094747488_F284A5405CCB4A0283E8E1A7538BD12C 193 11:28:30 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 测试物品20190815 194 11:28:30 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 195 11:28:30 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = CS 196 11:28:30 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 197 11:28:30 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 198 11:28:30 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2019-12-31 199 11:28:30 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 3.000 200 11:28:30 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 170899 201 11:28:30 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 202 11:28:30 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000134098 203 11:28:30 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 50, Scale = 0, Data = 20190815094000654_4996AD99B43C4754AF28D3487D42D1AC 204 11:28:30 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 福建亿能达 205 11:28:30 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 舒尔洁 206 11:28:30 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 1548.0000 207 11:28:30 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 个 208 11:28:30 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 209 11:28:30 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 210 11:28:30 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 211 11:28:30 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 212 11:28:30 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 213 11:28:30 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2018 214 11:28:30 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = DSA 215 11:28:30 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 216 11:28:30 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 217 11:28:30 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 49985539 218 11:28:30 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 173, Scale = 0, Data = MSH|^~\&|HIS|手麻|HRP||20191214111227.434|N|QBP^Q13^QBP_Q13|QRY_Product_MDH-20191214111227434|P|2.7 QPD|Q13^QRY_Product_MDH^HL7|QPM01|01123456789|1719120010170899|2018 RCP|I 219 11:28:30 SQL Execute: ORACLE - insert into SS_GZHCJK(NBID00,YJDJH0,JJID00,CZY000,SSDH00,ZTM000,CTM000,RDT000,WZMC00,MDHID0,WZGGXH,XLH000,SCRQ00,SXRQ00,SL0000,PC0000,TM0000, SFXMBH,GHDWID,GHDWMC,SCCJMC,CGJ000,SFDW00,ZCZBH0,ZCZRQ0,ZCZRQ1,RKMXID,SFGZHC,KSBH00,KSMC00,HCMODE,LYXT00,ID0000,YNDFSC,YNDJSC) VALUES (SQ_SS_GZHCJK_NBID00.nextval,?,null,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) 220 11:28:30 SQL Data In: ORACLE - Rows affected = 1 221 11:28:30 SQL Execute: ORACLE - select a.*,b.SFJE00,b.SFXMID,substrb(a.WZGGXH,1,200) WZGG00,b.XMMC00 from SS_GZHCJK a,BM_YYSFXM b where a.YJDJH0=49985539 and a.SFXMBH=b.SFXMID(+) and a.CKRQ00 is NULL and a.JJID00 is null and a.NBID00>=560 222 11:28:31 SQL Execute: ORACLE - select LSCL00,GJBM00 from BM_YYSFXM where SFXMID in (53324) 223 11:28:31 SQL Execute: ORACLE - select * from VW_SS_YYSFXM_INP where sfxmid in (8000134098) and ((ybbrlb='0' and YBZXLB='0' and fbbh00='1' and sfsfxm='Y') or (sfsfxm='N')) and ((JSXM00='0' or SFXMID in (select SFXMID from XT_ZLSFGX where ZLXMID in (select ZLXMID from YJ_YW0000 where YJDJH0=49985539 union all select ZLXMID from YJ_YWMX00 where YJDJH0=49985539)))or (JSXM00='1' and ('320200002' Like GJBM00||'%')) or (JSXM00='2' and Instr('930015,930001,930002,930010,950058,950059,960028,930003,930010,930001,930008,930008',substrb(BH0000,1,6))>0)) 224 11:28:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000134098 225 11:28:31 SQL Execute: ORACLE - SELECT * FROM BM_YYSFXM WHERE SFXMID=? 226 11:28:31 SQL Execute: ORACLE - Update SS_GZHCJK set JJID00=(select max(ID0000) from YJ_YWJJ00 where YJDJH0=49985539) where CXBZ00='Z' and NBID00=561 227 11:28:31 SQL Data In: ORACLE - Rows affected = 1 228 11:28:36 SQL Execute: ORACLE - select count(*) from VW_BM_JSGJBM where GJBM00='930008' and sfxmid=8000134098 and GJBM00 in ('320200002') 229 11:28:36 SQL Execute: ORACLE - select count(*) from VW_BM_JSGJBM where GJBM00='320200002' and sfxmid=8000134098 and GJBM00 in ('320200002') 230 11:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49985539.000000 231 11:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 232 11:28:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000134098.000000 233 11:28:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 234 11:28:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 235 11:28:36 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1548.000000 236 11:28:36 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 237 11:28:36 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 238 11:28:36 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 239 11:28:36 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 240 11:28:36 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1548.000000 241 11:28:36 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 242 11:28:36 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 243 11:28:36 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 244 11:28:36 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 320200002 245 11:28:36 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 246 11:28:36 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 01123456789 247 11:28:36 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1719120010170899 248 11:28:36 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 249 11:28:36 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 250 11:28:36 SQL Data In: ORACLE - Param = 21, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1548.000000 251 11:28:36 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 170899 252 11:28:36 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 50, Scale = 0, Data = 20190815094000654_4996AD99B43C4754AF28D3487D42D1AC 253 11:28:36 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2019-12-31 254 11:28:36 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 255 11:28:36 SQL Execute: ORACLE - insert into yj_ywjj00 (ID0000, YJDJH0, YJFZH0, SFXMID, SL0000, SFCS00, JJJE00, GFJE00, JZJE00, ZFJE00, SFXX00, SFSX00, YBBZ00, GDBZ00, FJFYBZ, MXID00, GJBM00, SFLB00 ,ZTM000,CTM000,BSM000,HCID00,HCDJ00,HCPH00,HCGYS0,HCYXQ0,HCZCZH) values (SQ_YJ_YWJJ00_ID0000.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'N', ?,?, ?, ?,?,?,?,?,?,?,?,?) 256 11:28:36 SQL Error: ORACLE - ORA-20030: 收过费的医技单不能重新定价！* ORA-06512: 在 "SD_HOSPITAL.TR_YJ_YW0000_BINS_UPD", line 301 ORA-04088: 触发器 'SD_HOSPITAL.TR_YJ_YW0000_BINS_UPD' 执行过程中出错 ORA-06512: 在 "SD_HOSPITAL.TR_YJ_YWJJ00_BINS_UPD", line 216 ORA-04088: 触发器 'SD_HOSPITAL.TR_YJ_YWJJ00_BINS_UPD' 执行过程中出错 257 11:28:36 SQL Error: ORACLE - Unmapped SQL Error Code: 20030