1 10:24:01 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',1027,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',653,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =653 AND b.JSKSBH = '1027') AND (INSTR (',' || a.jsksbh || ',',',1027,') > 0 or a.jsksbh is null) 2 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(697871) BRXMYS from dual 3 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698116) BRXMYS from dual 4 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(697296) BRXMYS from dual 5 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698247) BRXMYS from dual 6 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698286) BRXMYS from dual 7 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698177) BRXMYS from dual 8 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698262) BRXMYS from dual 9 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698234) BRXMYS from dual 10 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(697608) BRXMYS from dual 11 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(697901) BRXMYS from dual 12 10:24:02 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698148) BRXMYS from dual 13 10:24:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 多点结算接口参数 14 10:24:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = CBJSDBZYXJSCS 15 10:24:05 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 16 10:24:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 多点结算接口参数 17 10:24:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = CBJSDBZCXEXZ 18 10:24:05 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 19 10:24:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1682605.000000 20 10:24:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 698141.000000 21 10:24:05 SQL Execute: ORACLE - select sum(HJJE00)HJJE00 from ZY_BRFY00 where BRID00=? and ZYID00=? and JZDH00=0 22 10:24:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 698141.000000 23 10:24:05 SQL Execute: ORACLE - select count(1) as num from yf_zycf00 where CFZT00='1' and ZYID00=? 24 10:24:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 698141.000000 25 10:24:05 SQL Execute: ORACLE - select count(*) NUM from YF_YZYPSQ where ZYID00 =? and QLZT00 in ('0','5') and CXBZ00 <> 'Z' 26 10:24:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 698141.000000 27 10:24:05 SQL Execute: ORACLE - select count(*) NUM from YF_ZYCF00 A where A.ZYID00 = ? and A.CFZT00 in ('0','5') and A.BCCFH0 in (select CFLSH0 from yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00 = 0 and F.ZYID00 = A.ZYID00 ) 28 10:24:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 698141.000000 29 10:24:05 SQL Execute: ORACLE - select count(*) NUM from VW_ZY_YJYW00 A where A.ZYID00 = ? and A.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.ZYID00 and SFDJH0 in ( select DJH000 from ZY_BRFY00 where JZDH00 = 0 and ZYID00=A.ZYID00)) and A.SFDJH0+0 = 0 30 10:24:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 698141.000000 31 10:24:05 SQL Execute: ORACLE - select count(*) NUM from bq_yjyz00 A where A.ZYID00 = ? and A.ZLXMID = 0 and A.ZLXMJC like '%垫付%' 32 10:24:11 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',1027,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',653,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =653 AND b.JSKSBH = '1027') AND (INSTR (',' || a.jsksbh || ',',',1027,') > 0 or a.jsksbh is null) 33 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(697871) BRXMYS from dual 34 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698116) BRXMYS from dual 35 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(697296) BRXMYS from dual 36 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698247) BRXMYS from dual 37 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698286) BRXMYS from dual 38 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698177) BRXMYS from dual 39 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698262) BRXMYS from dual 40 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698234) BRXMYS from dual 41 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(697608) BRXMYS from dual 42 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(697901) BRXMYS from dual 43 10:24:12 SQL Execute: ORACLE - select SF_BQ_GETBRXMXSYS(698148) BRXMYS from dual 44 10:24:46 Log started for: SQL Navigator for Oracle