1 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 2 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 3 10:21:45 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 4 10:21:45 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13720821 5 10:21:45 SQL Execute: ORACLE - select count(1) TsbzNum from VW_SF_YBTZBZ A,sf_brfy00 c where 1=1 and a.djh000=c.djh000 and c.jzdh00+0=0 and A.BRID00 = ? and trim(a.tsbzbh) is not null and c.CZRQ00>= ? and c.CZRQ00<= ? and c.MZH000=? 6 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000218.000000 7 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 8 10:21:45 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 9 10:21:45 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 10 10:21:45 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 11 10:21:45 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13720821 12 10:21:45 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0 <> ? and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( MZH000 = ? or MZH000 = '0') 13 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 14 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13720821 15 10:21:45 SQL Execute: ORACLE - select sum(ZFJE00) ZFJE00,sum(JZJE00) JZJE00 FROM SF_BRFY00 WHERE BRID00=? and JZDH00+0=0 AND CXPJR0='999999' and ( MZH000 =?) 16 10:21:45 SQL Execute: ORACLE - update SF_BRFY00 SET CZRQ00='20201022' WHERE BRID00=31947 and JZDH00+0=0 AND CZRQ00='19990101' and ( MZH000 = '13720821') 17 10:21:45 SQL Data In: ORACLE - Rows affected = 0 18 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 19 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000218.000000 20 10:21:45 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 21 10:21:45 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 22 10:21:45 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 23 10:21:45 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 24 10:21:45 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13720821 25 10:21:45 SQL Execute: ORACLE - select 0 FPXMID,'ºÏ¼Æ' XMMC00, ? JE0000 from dual union all select C.FPXMID,C.XMMC00,sum(A.HJJE00) JE0000 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0<> ? and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( MZH000 = ? or MZH000='0') group by C.FPXMID, C.XMMC00 26 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000218.000000 27 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 28 10:21:45 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 29 10:21:45 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 30 10:21:45 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 31 10:21:45 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13720821 32 10:21:45 SQL Execute: ORACLE - select A.*,D.CZYXM0,D.MZH000,(select CZRQ00 CXCZRQ from SF_BRFY00 where DJH000=D.CXDJH0 and BRID00=D.BRID00 and rownum=1) CXCZRQ,D.CXDJH0 from sf_fymx00 A,bm_yysfxm B,sf_brfy00 D where A.XMBH00 = B.SFXMID and a.xmbh00+0<> ? and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( D.MZH000 = ? or MZH000='0') 33 10:21:45 SQL Execute: ORACLE - select count(*) RCOUNT from BM_YYSFXM A where SFXMID in (-1,686) and MZFPID<>'6' 34 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 35 10:21:45 SQL Execute: ORACLE - select b.SFXNH0,b.FBBH00,b.ybmc00 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.brid00=? 36 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 37 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 38 10:21:45 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 39 10:21:45 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 40 10:21:45 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 41 10:21:45 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13720821 42 10:21:45 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 43 10:21:45 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 44 10:21:45 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 45 10:21:45 SQL Execute: ORACLE - select SF_SF_SFMRYBJS(?,?,?,?,?,?,?,?,?) FSLX00 from dual 46 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 47 10:21:45 SQL Execute: ORACLE - select SF_SF_MSZFKQ(?)FHJG00 from dual 48 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 49 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13720821 50 10:21:45 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 51 10:21:45 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 52 10:21:45 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 53 10:21:45 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 54 10:21:45 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual 55 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 56 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201022 57 10:21:45 SQL Execute: ORACLE - Select (nvl(sum(HJJE00),0)-nvl(sum(ybyl19),0)) HJJE00 from sf_jzb000 where BRID00=? and JZRQ00=? and FBBH00=3 AND YBDJH0<>'0' 58 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 59 10:21:45 SQL Execute: ORACLE - select tyje01 from VW_SF_BRZHXX where BRID00=? 60 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 61 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 62 10:21:45 SQL Execute: ORACLE - select sum(CFZJE0)+sum(NVL(ZYDJFY,0)) JE0000,sum(NVL(ZYDJFY,0)) ZYDJFY from VW_SF_YFMZCF A where (A.BCCFH0 is null) and A.CFZT00 = '0' and A.BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?) 63 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 64 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 65 10:21:45 SQL Execute: ORACLE - select sum(ZJE000) JE0000 from VW_SF_YJYW00 where (CXDJH0 is null) and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?) 66 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 67 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 68 10:21:45 SQL Execute: ORACLE - select SUM(ROUND(B.YPZSL0*B.LSDJ00,2)*B.ZFBL00) JE0000 from VW_SF_YFMZCF A,YF_MZCFMX B where A.CFLSH0=B.CFLSH0 AND (A.BCCFH0 is null) and A.CFZT00 = '0' and B.SFZBY0='N' and A.BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?) 69 10:21:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 70 10:21:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000 71 10:21:45 SQL Execute: ORACLE - select SUM(ZFJE00) JE0000 from VW_SF_YJYW00 A,YJ_YWJJ00 B where A.YJDJH0=B.YJDJH0 AND (CXDJH0 is null) and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?)