1 14:29:31 SQL Execute: ORACLE - select SF_SF_GETYNFPPJXH(951,32) as PJXH00 from dual 2 14:29:34 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='2001617' 3 14:29:34 SQL Data In: ORACLE - Param = 1, Name = PJZDH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 3662833,3640540, 4 14:29:34 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 355564.000000 5 14:29:34 SQL Data In: ORACLE - Param = 3, Name = PXM0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 李芳 6 14:29:34 SQL Data In: ORACLE - Param = 4, Name = PXB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 7 14:29:34 SQL Data In: ORACLE - Param = 5, Name = PYJJXH0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 141984 8 14:29:34 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 951.000000 9 14:29:34 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 李艳 10 14:29:34 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 32.000000 11 14:29:34 SQL Data In: ORACLE - Param = 9, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 12 14:29:34 SQL Data In: ORACLE - Param = 10, Name = PPJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 13 14:29:34 SQL Data In: ORACLE - Param = 11, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 14 14:29:34 SQL Data In: ORACLE - Param = 12, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 15 14:29:34 SQL Data In: ORACLE - Param = 13, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 14:29:34 SQL Execute: ORACLE - BEGIN "SP_SF_BRFPHB" (PJZDH00 => :PJZDH00,PBRID00 => :PBRID00,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PYJJXH0 => :PYJJXH0,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PPJH000 => :PPJH000,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 17 14:29:34 SQL Execute: ORACLE - select * from vw_sf_fp0000 where jzdh00=3662833 18 14:29:34 SQL Execute: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00 =355564 19 14:29:34 SQL Execute: ORACLE - select nvl(sum(a.hjje00),0) ickje0 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and a.XMBH00=8000000001 and b.jzdh00+0=0 and b.brid00= 355564 20 14:29:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31953771.000000 21 14:29:35 SQL Execute: ORACLE - select B.LBMC00 from SF_BRXXB0 A,BM_GHLBB0 B where A.GHLB00=B.LBBH00 AND A.GHID00= ? AND A.BRID00= 355564 22 14:29:35 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='SF_TJPJDYXSFPBH' 23 14:29:35 SQL Execute: ORACLE - select * from SF_PJSYMX where xmje00<>0 and PJH000 =32310455 order by XMBH00 24 14:29:35 SQL Execute: ORACLE - select * from vw_sf_rqdmx3 where jzdh00=3662833 25 14:29:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 004098 26 14:29:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3662833.000000 27 14:29:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08288576 28 14:29:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 951.000000 29 14:29:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 李艳 30 14:29:35 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 31 14:29:35 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 32 14:29:35 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 200, Scale = 0, Data = 成功:004098,08288576,454.13,闽财（2019）票字第037号 33 14:29:35 SQL Execute: ORACLE - insert into sf_zrkpqk(zrkpid,plbh00,jzdh00,pjxh00,zrrq00,zrsj00,czy000,czyxm0,pjzt00,cgbz00,bz0000) values(sq_sf_zrkpqk_zrkpid.nextval,?,?,?,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),?,?,?,?,?) 34 14:29:35 SQL Data In: ORACLE - Rows affected = 1 35 14:29:35 SQL Execute: ORACLE - commit 36 14:29:35 SQL Data In: ORACLE - Rows affected = 0 37 14:29:35 SQL Execute: ORACLE - select pjh000 from sf_jzb000 where jzdh00=3662833 38 14:29:35 SQL Execute: ORACLE - update sf_pjsyqk set pjxh00='08288576' where pjzt00='0' and fzpjh0 in (32310455) 39 14:29:35 SQL Data In: ORACLE - Rows affected = 1 40 14:29:35 SQL Execute: ORACLE - commit 41 14:29:35 SQL Data In: ORACLE - Rows affected = 0 42 14:29:35 SQL Execute: ORACLE - select SF_SF_GETYNFPPJXH(951,32) as PJXH00 from dual 43 14:29:35 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='2001617' 44 14:29:35 SQL Execute: ORACLE - select a.BRID00,a.BRXM00,a.BRXB00,a.BRCSRQ,c.YBMC00,a.FBBH00,substr(SF_XT_CSRQTONL(a.BRCSRQ,to_char(sysdate,'yyyymmdd')),1,10) as BRNL00 from BM_BRXXB0 a,IC_YBBRLB C where a.fbbh00=c.fbbh00 and a.yblb00=c.yblb00 and a.BRID00 in ( select BRID00 from IC_YHXX00 where ICKH00 = 'FZYBA99204945' and ZT0000 = '1' ) and a.BRXM00 like '李芳%' 45 14:29:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 355564 46 14:29:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200809 47 14:29:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200908 48 14:29:35 SQL Execute: ORACLE - select 'N' XZ0000,a.* from VW_SF_JZB000 a where a.BRID00 = ? and a.JZRQ00 between ? and ? order by JZDH00 desc 49 14:29:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3662833 50 14:29:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,a.XMSL00,a.HJJE00,a.ZFBL00,a.XMZT00,a.FYRQSJ,a.FPXMMC,a.KDKSMC,a.KFYXM0,a.KFKSMC,a.ZXKSMC,a.YBXJ00 from VW_SF_RQDMX7 a where JZDH00 = ? order by BH0000,GJBM01