1       15:03:34  SQL Prepare: ORACLE - select  *  from  VW_ZY_JKB000  where 1 = 1 
 and  JKRQ00 >= :1
 and  JKRQ00 <= :2
 and  JKRQ00||JKSJ00 >= :3
 and  JKRQ00||JKSJ00 <= :4
 and  SFYXM0 = :5
 order by JKDH00,SFY000,JKRQ00||JKSJ00

2       15:03:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140507
3       15:03:34  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140507
4       15:03:34  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014050715:28:13
5       15:03:34  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014050715:37:58
6       15:03:34  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Ö£ÑÞ
7       15:03:34  SQL Execute: ORACLE - select  *  from  VW_ZY_JKB000  where 1 = 1 
 and  JKRQ00 >= ?
 and  JKRQ00 <= ?
 and  JKRQ00||JKSJ00 >= ?
 and  JKRQ00||JKSJ00 <= ?
 and  SFYXM0 = ?
 order by JKDH00,SFY000,JKRQ00||JKSJ00

8       15:03:34  SQL Prepare: ORACLE - select * from  zy_brjfb0
where JKBID0=:1

9       15:03:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 92586
10      15:03:34  SQL Execute: ORACLE - select * from  zy_brjfb0
where JKBID0=?

11      15:03:34  SQL Prepare: ORACLE -  select * from bm_jkkjmx where jkdh00=92586 and xmbh00 in ('25','26','29','35')

12      15:03:34  SQL Execute: ORACLE -  select * from bm_jkkjmx where jkdh00=92586 and xmbh00 in ('25','26','29','35')

13      15:03:35  SQL Prepare: ORACLE - select sum(XJJE00)XJJE00, sum(ZZJE00)ZZJE00  from  VW_ZY_JKB000  where  1 = 1 
 and  JKRQ00 >= :1
 and  JKRQ00 <= :2
 and  JKRQ00||JKSJ00 >= :3
 and  JKRQ00||JKSJ00 <= :4
 and  SFYXM0 = :5

14      15:03:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140507
15      15:03:35  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140507
16      15:03:35  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014050715:28:13
17      15:03:35  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014050715:37:58
18      15:03:35  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Ö£ÑÞ
19      15:03:35  SQL Execute: ORACLE - select sum(XJJE00)XJJE00, sum(ZZJE00)ZZJE00  from  VW_ZY_JKB000  where  1 = 1 
 and  JKRQ00 >= ?
 and  JKRQ00 <= ?
 and  JKRQ00||JKSJ00 >= ?
 and  JKRQ00||JKSJ00 <= ?
 and  SFYXM0 = ?

20      15:03:36  SQL Prepare: ORACLE - select * from  zy_brjfb0
where JKBID0=:1

21      15:03:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 92587
22      15:03:36  SQL Execute: ORACLE - select * from  zy_brjfb0
where JKBID0=?

23      15:03:36  SQL Prepare: ORACLE -  select * from bm_jkkjmx where jkdh00=92587 and xmbh00 in ('25','26','29','35')

24      15:03:36  SQL Execute: ORACLE -  select * from bm_jkkjmx where jkdh00=92587 and xmbh00 in ('25','26','29','35')

25      15:03:43  SQL Prepare: ORACLE - select  D.YBMC00,sum(decode(sign(Instrb(','||Trim(D.YBBHSB)||',',',14,')),1,GRZHZF+TCJJZF,GRZHZF+TCJJZF+SBGRZH+SBTCJJ)) JE0000 from  zy_jzb000 A,zy_pjsyqk B,bm_brxxb0 C,ic_ybbrlb D 
 where A.pjh000 = B.pjh000  and  A.BRID00 = C.BRID00 and  C.YBLB00 = D.YBLB00  and C.FBBH00 = D.FBBH00 and  D.YBLB00 <> '0'
   and B.JKDID0 = 92587
 group by D.YBMC00 

26      15:03:43  SQL Execute: ORACLE - select  D.YBMC00,sum(decode(sign(Instrb(','||Trim(D.YBBHSB)||',',',14,')),1,GRZHZF+TCJJZF,GRZHZF+TCJJZF+SBGRZH+SBTCJJ)) JE0000 from  zy_jzb000 A,zy_pjsyqk B,bm_brxxb0 C,ic_ybbrlb D 
 where A.pjh000 = B.pjh000  and  A.BRID00 = C.BRID00 and  C.YBLB00 = D.YBLB00  and C.FBBH00 = D.FBBH00 and  D.YBLB00 <> '0'
   and B.JKDID0 = 92587
 group by D.YBMC00 

27      15:03:43  SQL Prepare: ORACLE - select  ZPKHYH,sum(JFJE00) JFJE00  from  zy_brjfb0  where  zffs00 = 8  and jkbid0 = 92587
  group by  ZPKHYH 

28      15:03:43  SQL Execute: ORACLE - select  ZPKHYH,sum(JFJE00) JFJE00  from  zy_brjfb0  where  zffs00 = 8  and jkbid0 = 92587
  group by  ZPKHYH 

29      15:03:43  SQL Prepare: ORACLE - select  JKRQ00||' '||JKSJ00 JSSJ,czy000,SFY000  from   BM_JKB000  where  jkdh00 =92587 and mzbz00=1

30      15:03:43  SQL Execute: ORACLE - select  JKRQ00||' '||JKSJ00 JSSJ,czy000,SFY000  from   BM_JKB000  where  jkdh00 =92587 and mzbz00=1

31      15:03:43  SQL Prepare: ORACLE - select  max(JKRQ00||' '||JKSJ00) KSSJ  from  BM_JKB000  where JKDH00<92587 and mzbz00=1 and sfy000=697

32      15:03:43  SQL Execute: ORACLE - select  max(JKRQ00||' '||JKSJ00) KSSJ  from  BM_JKB000  where JKDH00<92587 and mzbz00=1 and sfy000=697

33      15:03:43  SQL Prepare: ORACLE -  select  max(SFYXM0) SFY  from  VW_ZY_JKB000  where JKDH00 = '92587'

34      15:03:43  SQL Execute: ORACLE -  select  max(SFYXM0) SFY  from  VW_ZY_JKB000  where JKDH00 = '92587'

35      15:03:43  SQL Prepare: ORACLE -  select  *  from  BM_JKKJMX  where JKDH00 = '92587' and  BZ0000 = '1'

36      15:03:43  SQL Execute: ORACLE -  select  *  from  BM_JKKJMX  where JKDH00 = '92587' and  BZ0000 = '1'