1       08:40:35  SQL Prepare: ORACLE - ROLLBACK

2       08:40:35  SQL Execute: ORACLE - ROLLBACK

3       08:40:37  SQL Prepare: ORACLE - select  *  from  VW_SF_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

4       08:40:37  SQL Execute: ORACLE - select  *  from  VW_SF_JKB000  where 1 = 1 
 and  JKRQ00 >= ?
 and  JKRQ00 <= ?
 and  JKRQ00||JKSJ00 >= ?
 and  JKRQ00||JKSJ00 <= ?
 and  SFYXM0 = ?
 order by JKDH00,SFY000,JKRQ00||JKSJ00

5       08:40:37  SQL Prepare: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =:1 and b.plbh00=:2
   order by a.jfrq00 desc ,a.jfsj00 desc

6       08:40:37  SQL Execute: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =? and b.plbh00=?
   order by a.jfrq00 desc ,a.jfsj00 desc

7       08:40:38  SQL Prepare: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =:1 and b.plbh00=:2
   order by a.jfrq00 desc ,a.jfsj00 desc

8       08:40:38  SQL Execute: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =? and b.plbh00=?
   order by a.jfrq00 desc ,a.jfsj00 desc

9       08:40:39  SQL Prepare: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =:1 and b.plbh00=:2
   order by a.jfrq00 desc ,a.jfsj00 desc

10      08:40:39  SQL Execute: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =? and b.plbh00=?
   order by a.jfrq00 desc ,a.jfsj00 desc

11      08:40:39  SQL Prepare: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =:1 and b.plbh00=:2
   order by a.jfrq00 desc ,a.jfsj00 desc

12      08:40:39  SQL Execute: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =? and b.plbh00=?
   order by a.jfrq00 desc ,a.jfsj00 desc

13      08:40:42  SQL Prepare: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =:1 and b.plbh00=:2
   order by a.jfrq00 desc ,a.jfsj00 desc

14      08:40:42  SQL Execute: ORACLE - select * from  sf_brjfb0 A, sf_pjsyqk B
 where A.PJH000 = B.PJH000 
   and B.JKDID0 =? and b.plbh00=?
   order by a.jfrq00 desc ,a.jfsj00 desc

15      08:40:43  SQL Prepare: ORACLE - select  JKRQ00||' '||JKSJ00 JSSJ,sfy000  from   BM_JKB000  where  jkdh00 =75959

16      08:40:43  SQL Execute: ORACLE - select  JKRQ00||' '||JKSJ00 JSSJ,sfy000  from   BM_JKB000  where  jkdh00 =75959

17      08:40:43  SQL Prepare: ORACLE - select  max(JKRQ00||' '||JKSJ00) KSSJ  from  BM_JKB000  where mzbz00='0'  and pjh000<>0 and JKDH00<75959 and sfy000=1036

18      08:40:43  SQL Execute: ORACLE - select  max(JKRQ00||' '||JKSJ00) KSSJ  from  BM_JKB000  where mzbz00='0'  and pjh000<>0 and JKDH00<75959 and sfy000=1036

19      08:40:43  SQL Prepare: ORACLE -  select  *  from  VW_SF_JKB000  where JKDH00 = '75959'
 order  by  pjmc00  

20      08:40:43  SQL Execute: ORACLE -  select  *  from  VW_SF_JKB000  where JKDH00 = '75959'
 order  by  pjmc00  

21      08:40:43  SQL Prepare: ORACLE -  select  PLBH00,ltrim(PJXH00,'-') PJXH00,-(XJJE00+ZZJE00) JE0000  from  sf_pjsyqk  where  pjzt00 = '1' and xjje00>=0 and jkdid0 =75959

22      08:40:43  SQL Execute: ORACLE -  select  PLBH00,ltrim(PJXH00,'-') PJXH00,-(XJJE00+ZZJE00) JE0000  from  sf_pjsyqk  where  pjzt00 = '1' and xjje00>=0 and jkdid0 =75959

23      08:40:43  SQL Prepare: ORACLE - select nvl(sum(PJHJJE),0) HJ,nvl(sum(XJJE00),0) XJ,nvl(sum(ZZJE00),0) ZZ,nvl(sum(YHKJE0),0) YHK,nvl(sum(JZJE00),0) JZJE,nvl(sum(GFJE00),0) GFJE, 
 nvl(sum(YBZF00),0) YB,nvl(sum(PJZFH0),0) ZFH,nvl(sum(PJZFJE),0) ZFJE,nvl(sum(HSZFH0),0) HSH,nvl(sum(HSZFJE),0) HSJE,nvl(sum(JKJE00),0) JKE 
,nvl(sum(hsyhk0),0) hsyhk0,nvl(sum(dzqbje),0) dzqb from  VW_SF_JKB000   where JKDH00 = '75959'

24      08:40:43  SQL Execute: ORACLE - select nvl(sum(PJHJJE),0) HJ,nvl(sum(XJJE00),0) XJ,nvl(sum(ZZJE00),0) ZZ,nvl(sum(YHKJE0),0) YHK,nvl(sum(JZJE00),0) JZJE,nvl(sum(GFJE00),0) GFJE, 
 nvl(sum(YBZF00),0) YB,nvl(sum(PJZFH0),0) ZFH,nvl(sum(PJZFJE),0) ZFJE,nvl(sum(HSZFH0),0) HSH,nvl(sum(HSZFJE),0) HSJE,nvl(sum(JKJE00),0) JKE 
,nvl(sum(hsyhk0),0) hsyhk0,nvl(sum(dzqbje),0) dzqb from  VW_SF_JKB000   where JKDH00 = '75959'