1 11:06:33 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_SFYJKDGSFYXJK' and Value0='N' 2 11:06:33 SQL Execute: ORACLE - select to_char(sysdate,'YYYY.MM.DD' ) xtdate,to_char(sysdate-0/1440,'HH24:MI:SS' ) now from dual 3 11:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZSFJJBSJ' 4 11:06:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 661.000000 5 11:06:33 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 5 and PJSYR0 = ? and SYBZ00 = 'Y' 6 11:06:33 SQL Execute: ORACLE - select distinct (B.ZWXM00||'_'||B.XKH000) CZYXM0 from BM_YGBM00 B where B.YGBH00 in ( select JFCZY0 from SF_BRJFB0 where JKBID0 = 0 ) 7 11:06:39 SQL Execute: ORACLE - select XMJE00 from bm_jkkjmx where xmbh00='07' and jkdh00=(select max(jkdh00) from bm_jkb000 where mzbz00='0' and sfy000=(select ygbh00 from bm_ygbm00 where xkh000='s373')) 8 11:06:41 SQL Execute: ORACLE - select to_char(sysdate-0/1440,'YYYYMMDDHH24:MI:SS' ) now from dual 9 11:06:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20121015 10 11:06:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012101511:06:33 11 11:06:41 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = 自助机01_s373 12 11:06:41 SQL Execute: ORACLE - select * from VW_SF_BRJFXX A, BM_YGBM00 B where A.JFCZY0 = B.YGBH00 and A.JKBID0 = 0 and A.JFRQ00 <= ? and A.JFRQ00||A.JFSJ00 <= ? and B.ZWXM00||'_'||B.XKH000 = ? and A.JFJE00 <> 0 order by A.JFRQ00 desc,A.JFSJ00 desc 13 11:06:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20121015 14 11:06:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012101511:06:33 15 11:06:41 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = 自助机01_s373 16 11:06:41 SQL Execute: ORACLE - select A.ZFFS00,A.ZFFSMC,sum(JFJE00)HJJE00 from VW_SF_BRJFXX A, BM_YGBM00 B where A.JFCZY0 = B.YGBH00 and A.JKBID0 = 0 and A.JFRQ00 <= ? and A.JFRQ00||A.JFSJ00 <= ? and B.ZWXM00||'_'||B.XKH000 = ? group by A.ZFFS00,A.ZFFSMC 17 11:06:46 SQL Execute: ORACLE - select to_char(sysdate-0/1440,'YYYYMMDDHH24:MI:SS' ) now from dual 18 11:06:46 SQL Data In: ORACLE - Param = 1, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20121015 19 11:06:46 SQL Data In: ORACLE - Param = 2, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11:06:33 20 11:06:46 SQL Data In: ORACLE - Param = 3, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 661.000000 21 11:06:46 SQL Data In: ORACLE - Param = 4, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 黄晓辉 22 11:06:46 SQL Data In: ORACLE - Param = 5, Name = AS_SFY000, Type = fldZSTRING, Precision = 13, Scale = 0, Data = 自助机01_s373 23 11:06:46 SQL Data In: ORACLE - Param = 6, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 24 11:06:46 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 25 11:06:46 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 26 11:06:46 SQL Data In: ORACLE - Param = 9, Name = AS_JKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 27 11:06:46 SQL Execute: ORACLE - BEGIN "SP_SF_JKB000_REG000_YJ" (AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_SFY000 => :AS_SFY000,AS_YJJXH0 => :AS_YJJXH0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JKDH00 => :AS_JKDH00); END; 28 11:07:40 SQL Execute: ORACLE - select JKRQ00||' '||JKSJ00 JSSJ,sfy000 from BM_JKB000 where mzbz00='0' and jkdh00 =44169 29 11:07:40 SQL Execute: ORACLE - select max(JKRQ00||' '||JKSJ00) KSSJ from BM_JKB000 where (mzbz00='0' or mzbz00='9') and pjh000<>0 and JKDH00<44169 and sfy000=1226 30 11:07:40 SQL Execute: ORACLE - select * from VW_SF_JKB000 where JKDH00 = 44169 order by pjmc00 31 11:07:40 SQL Execute: ORACLE - select PLBH00,ltrim(PJXH00,'-') PJXH00,-(XJJE00+ZZJE00) JE0000 from sf_pjsyqk where pjzt00 = '1' and xjje00>=0 and jkdid0 =44169 32 11:07:40 SQL Execute: ORACLE - select sum(PJHJJE) HJ,sum(XJJE00) XJ,sum(ZZJE00) ZZ,sum(YHKJE0) YHK,sum(JZJE00) JZJE,sum(GFJE00) GFJE, sum(YBZF00) YB,sum(PJZFH0) ZFH,sum(PJZFJE) ZFJE,sum(HSZFH0) HSH,sum(HSZFJE) HSJE,sum(JKJE00) JKE ,sum(hsyhk0) hsyhk0,SUM(DZQBJE) DZQB from VW_SF_JKB000 where JKDH00 = '44169' 33 11:07:40 SQL Execute: ORACLE - select * from bm_jkb000 where pjbh00=1 and jkdh00=44169 34 11:07:56 SQL Execute: ORACLE - ROLLBACK 35 11:07:56 SQL Data In: ORACLE - Rows affected = 0