1       17:08:17  SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual 

2       17:08:17  SQL Execute: ORACLE - select (select VALUE0 from XT_XTCS00 where NAME00='XT_XNDK') VALUE0,SF_BM_SQXQTSXX('XT_XNDK','0',1143,'327382782') TSXX00   from dual 

3       17:08:17  SQL Execute: ORACLE - Select SYSDATE from Dual

4       17:08:17  SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'

5       17:08:17  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')

6       17:08:17  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = '0222137100144937'
and ICKNBH = '0222137100144937'

7       17:08:17  SQL Execute: ORACLE - select  count(*) NUM,NVL(max(ICKJE0),0) ICKJE0  from  IC_YHXX00  where  ICKH00 = '0222137100144937' and ZT0000='0'

8       17:08:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
9       17:08:19  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证
10      17:08:19  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 123
11      17:08:19  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 1231231231
12      17:08:19  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
13      17:08:19  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
14      17:08:19  SQL Execute: ORACLE -  select SF_SF_BRSFZJY(?,?,?,?,?,?) BRZJBH from dual

15      17:08:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872590.000000
16      17:08:19  SQL Execute: ORACLE -  select  NVL(ZYE000,0) YE0000  from  SF_BRZHXX  where  brid00 =? and  JFLBID = 1 

17      17:08:20  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 = '4') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '44')
  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  

18      17:08:26  SQL Execute: ORACLE -  select * from  BM_YHKDM0 ORDER BY  YHKDH0 

19      17:08:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000
20      17:08:26  SQL Execute: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 7  and  PJSYR0 = ?
 and  SYBZ00 = 'Y'

21      17:08:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872590.000000
22      17:08:26  SQL Execute: ORACLE -  select   A.*,B.FBMC00   from  BM_BRXXB0 A, BM_BRFBB0 B where  A.fbbh00 = B.fbbh00 
 and  A.BRID00 =?  

23      17:08:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872590.000000
24      17:08:26  SQL Execute: ORACLE -  select TBLBMC from  VW_BM_BRXXB2 where  BRID00 =? 

25      17:08:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872590.000000
26      17:08:26  SQL Execute: ORACLE -  select   *  from  SF_BRZHXX   where JFLBID = 1  and  BRID00 = ?

27      17:08:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872590.000000
28      17:08:26  SQL Execute: ORACLE -  select tyje01,YBSBK0,ICKH00 from VW_SF_BRZHXX where brid00= ?

29      17:08:26  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

30      17:08:26  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

31      17:08:26  SQL Execute: ORACLE -  select  *  from  vw_sf_brjflb  

32      17:08:26  SQL Execute: ORACLE - select * from  VW_BM_BRZFFS  where 1=1
 and ZFFSBH<>18 
order by nvl(XSXH00,0),ZFFSBH

33      17:08:26  SQL Execute: ORACLE -  select *  from  BM_TYZD00  where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000  

34      17:08:30  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 = '4') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '44')
  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)