1 17:32:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31821531 2 17:32:11 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL from YJ_YWJJ00 A, BM_YYSFXM B where A.SFXMID = B.SFXMID and YJDJH0 = ? 3 17:32:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23284507 4 17:32:11 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 31821531 YJDJH0 from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 5 17:32:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 823269 6 17:32:11 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 7 17:32:11 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(2728092,'1',823269) from dual 8 17:32:11 SQL Execute: ORACLE - select '2728092' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13400546146' BRLXDH,'2004666' ZYHGHH, '钱静仁' BRXM00, '女' BRXB00, '81岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '2728092') FBMC00 , '09-11' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=485) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='2728092' ) JZFPBZ from dual 9 17:32:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31821531 10 17:32:11 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL from YJ_YWJJ00 A, BM_YYSFXM B where A.SFXMID = B.SFXMID and YJDJH0 = ? 11 17:32:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23284507 12 17:32:11 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 31821531 YJDJH0 from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 13 17:32:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 823269 14 17:32:11 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 15 17:32:11 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(2728092,'1',823269) from dual 16 17:32:11 SQL Execute: ORACLE - select '2728092' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13400546146' BRLXDH,'2004666' ZYHGHH, '钱静仁' BRXM00, '女' BRXB00, '81岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '2728092') FBMC00 , '09-11' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=485) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='2728092' ) JZFPBZ from dual 17 17:32:12 SQL Execute: ORACLE - Select brid00,zyghid,yjdjh0,yjfzh0,zyhghh,brxm00, yexm00,zlxmjc,xb0000,csrq00,kdysxm,kdksmc,zlxmid,zdid00, jzbz00,bwmc00,bz0000,zdmc00,mzzybz,kdksbh,kdys00,sl0000,yjksbh,zxksmc,bwid00 from vw_yj_yw0000_wzx where xmzt00 in ('0','5','1') and yjdjh0=31821531 18 17:32:12 SQL Execute: ORACLE - select zlxmbh from bm_zlzd00 where zlxmid=18035 19 17:32:12 SQL Execute: ORACLE - select yexm00 from bq_jsxx00 where zyid00=823269 20 17:32:12 SQL Execute: ORACLE - select zlxmbh from bm_zlzd00 where zlxmid=18035 21 17:32:12 SQL Execute: ORACLE - select zlxmjc,zxmid0 zlxmid,gdxmbz,''jgms00,jgdw00,ckz000,bbid00,zyzbid,zxmbh0 zlxmbh from VW_YS_YWMXXM WHERE SJXMID=18035 order by zxmbh0 22 17:32:12 SQL Execute: ORACLE - select b.zlxmid zlxmid,a.sl0000 sl0000 from yj_ywmx00 a,bm_zlzd00 b where b.zlxmbh in( select decode(length(d.zlxmbh),13,substr(d.zlxmbh,1,10),d.zlxmbh) from yj_ywmx00 c,bm_zlzd00 d where c.yjdjh0=31821531 and c.zlxmid=d.zlxmid) and a.yjdjh0=31821531 and a.zlxmid=b.zlxmid 23 17:32:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 823269.000000 24 17:32:12 SQL Execute: ORACLE - select distinct bqh000,bmmc00 from bq_brldxx q,bm_bmbm00 m where zyid00=? and q.bqh000=m.bmbh00 25 17:32:12 SQL Execute: ORACLE - select BMMC00,BMBH00 from VW_YS_YJZXKS where ZLXMID=18035 26 17:32:12 SQL Execute: ORACLE - SELECT KDBQ00 FROM YJ_YW0000 WHERE YJDJH0=31821531 27 17:32:12 SQL Misc: ORACLE - Set stored procedure on or off 28 17:32:12 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2728092.000000 29 17:32:12 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 30 17:32:12 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 31 17:32:12 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 32 17:32:12 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 17:32:12 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 34 17:32:12 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 35 17:32:12 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 36 17:32:12 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 37 17:32:12 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 38 17:32:12 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 39 17:32:12 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 40 17:32:12 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 17:32:12 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 17:32:12 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 43 17:32:12 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 44 17:32:12 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 45 17:32:12 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); END; 46 17:32:16 SQL Execute: ORACLE - Select TO_DATE('1939-05-05','yyyy-MM-dd') from dual 47 17:32:16 SQL Misc: ORACLE - Set stored procedure on or off 48 17:32:16 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 49 17:32:16 SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 31821531 50 17:32:16 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 823269 51 17:32:16 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 52 17:32:16 SQL Data In: ORACLE - Param = 5, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 18035 53 17:32:16 SQL Data In: ORACLE - Param = 6, Name = PZXMID0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 54 17:32:16 SQL Data In: ORACLE - Param = 7, Name = PZDID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = M81.900 55 17:32:16 SQL Data In: ORACLE - Param = 8, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 56 17:32:16 SQL Data In: ORACLE - Param = 9, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 57 17:32:16 SQL Data In: ORACLE - Param = 10, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 58 17:32:16 SQL Data In: ORACLE - Param = 11, Name = PYJLRBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 59 17:32:16 SQL Data In: ORACLE - Param = 12, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 60 17:32:16 SQL Data In: ORACLE - Param = 13, Name = PKDYS00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1663 61 17:32:16 SQL Data In: ORACLE - Param = 14, Name = PKDKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 491 62 17:32:16 SQL Data In: ORACLE - Param = 15, Name = PKDBQ00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 485 63 17:32:16 SQL Data In: ORACLE - Param = 16, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 499 64 17:32:16 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 65 17:32:16 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 66 17:32:16 SQL Data In: ORACLE - Param = 19, Name = PFJDJBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 67 17:32:16 SQL Data In: ORACLE - Param = 20, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 68 17:32:16 SQL Data In: ORACLE - Param = 21, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 499 69 17:32:16 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 70 17:32:16 SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 71 17:32:16 SQL Data In: ORACLE - Param = 24, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 72 17:32:16 SQL Data In: ORACLE - Param = 25, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 73 17:32:16 SQL Data In: ORACLE - Param = 26, Name = Pywmxid, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 74 17:32:16 SQL Data In: ORACLE - Param = 27, Name = Pbwmc00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 75 17:32:16 SQL Data In: ORACLE - Param = 28, Name = Pbwid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 76 17:32:16 SQL Execute: ORACLE - BEGIN "SP_YJ_YJSQWH" (POPFLAG => :POPFLAG,PYJDJH0 => :PYJDJH0,PZYGHID => :PZYGHID,PMZZYBZ => :PMZZYBZ,PZLXMID => :PZLXMID,PZXMID0 => :PZXMID0,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PBBID00 => :PBBID00,PBH0000 => :PBH0000,PYJLRBZ => :PYJLRBZ,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PKDBQ00 => :PKDBQ00,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,PFJDJBZ => :PFJDJBZ,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,Pywmxid => :Pywmxid,Pbwmc00 => :Pbwmc00,Pbwid00 => :Pbwid00); END; 77 17:32:16 SQL Execute: ORACLE - Commit 78 17:32:16 SQL Data In: ORACLE - Rows affected = 0 79 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 823269 80 17:32:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 499 81 17:32:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 499 82 17:32:18 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 499 83 17:32:18 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 499 84 17:32:18 SQL Execute: ORACLE - select 'N' NX, a.YJKSMC, A.XMZT00, A.ZLXMID, A.MZZYBZ, A.YZCFID, A.DCBZ00, A.BRID00,A.ZT0000, A.YJDJH0, A.YJFZH0, A.ZYHGHH, A.BRXM00, A.YEXM00, A.ZLXMJC, A.XB0000, A.CSRQ00, A.BRNL00, A.LRXM00, A.KDSJ00, A.ZYGHID, B.LBBH00, B.ZYZBID, A.KDYSXM, A.KDKSMC, A.KDRQ00, A.JZBZ00, A.BWMC00, A.BZ0000, A.ZDMC00, A.SL0000, A.ZXSL00, A.ZJE000, A.YJLRBZ, A.KDBQ00, nvl(A.CXDJH0,0) CXDJH0, A.ZXRXM0, A.ZXRQ00, A.ZXSJ00, A.BRYBMC, A.SM0000, A.ZLDCCF, A.CXSL00, A.TXM000, A.FBBH00, A.CH0000, A.YJKSBH, A.KDRQSJ, A.ZXRQSJ, A.YPNM00, A.BBZT00, A.JYTXM0,A.SFDJH0, decode(sign(A.SL0000),1,NULL,decode(A.SFDJH0,0,0,1)) SFGZ00, A.BBID00, (select BBMC00 from BM_BBZD00 where BBID00 = A.BBID00) BBMC00,b.SFQZX0, A.JCZID0, A.YYID00, A.HBXHID, A.YYZT00, A.HBDJH0,A.YYBZ00,A.JCSQDH,A.KDKSBH, A.KDYS00,A.JCLBID,A.SFZTMC,decode(A.HBZYXM,'2','是','否') HBZYXM from VW_YJ_YW0000 A, BM_ZLZD00 B where B.ZLXMID = A.ZLXMID and ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=1 and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID=b.ZLXMID and b.SFQZX0='Y' and A.MZZYBZ='0' ) and instr(',0,',',499,')>0))and (1=1 and ( A.MZZYBZ = '0' or A.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(A.CXDJH0,0) = 0 and (A.SL0000-A.CXSL00)>0 and KDRQ00 between '20200801' and '20200826' order by XMZT00,YJDJH0 Desc 85 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31821531 86 17:32:18 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL from YJ_YWJJ00 A, BM_YYSFXM B where A.SFXMID = B.SFXMID and YJDJH0 = ? 87 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23284507 88 17:32:18 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 31821531 YJDJH0 from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 89 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 823269 90 17:32:18 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 91 17:32:18 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(2728092,'1',823269) from dual 92 17:32:18 SQL Execute: ORACLE - select '2728092' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13400546146' BRLXDH,'2004666' ZYHGHH, '钱静仁' BRXM00, '女' BRXB00, '81岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '2728092') FBMC00 , '09-11' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=485) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='2728092' ) JZFPBZ from dual 93 17:32:18 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(2728092,'1',823269) from dual 94 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31821531 95 17:32:18 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL from YJ_YWJJ00 A, BM_YYSFXM B where A.SFXMID = B.SFXMID and YJDJH0 = ? 96 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23284507 97 17:32:18 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 31821531 YJDJH0 from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 98 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 823269 99 17:32:18 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 100 17:32:18 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(2728092,'1',823269) from dual 101 17:32:18 SQL Execute: ORACLE - select '2728092' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13400546146' BRLXDH,'2004666' ZYHGHH, '钱静仁' BRXM00, '女' BRXB00, '81岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '2728092') FBMC00 , '09-11' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=485) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='2728092' ) JZFPBZ from dual 102 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31821531 103 17:32:18 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL from YJ_YWJJ00 A, BM_YYSFXM B where A.SFXMID = B.SFXMID and YJDJH0 = ? 104 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23284507 105 17:32:18 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 31821531 YJDJH0 from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 106 17:32:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 823269 107 17:32:18 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 108 17:32:18 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(2728092,'1',823269) from dual 109 17:32:18 SQL Execute: ORACLE - select '2728092' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13400546146' BRLXDH,'2004666' ZYHGHH, '钱静仁' BRXM00, '女' BRXB00, '81岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '2728092') FBMC00 , '09-11' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=485) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='2728092' ) JZFPBZ from dual