1       13:30:59  SQL Execute: ORACLE - select  ZFFS00,count(*) NUM,sum(NVL((JFJE00),0)) JE0000  from SF_brjfb0  where  jflbid = 1 
 and ZFFS00 IN (1,2,3,4,10,11,8,18,24) and JFBZ00 in ('0','2') AND JFRQ00>='20160415'
 and  JFRQ00 <= '20160415'
 and  JFRQ00||JFSJ00 >= '2016041500:00:00'
 and  JFRQ00||JFSJ00 <= '2016041523:59:59'
  group by  ZFFS00
 union all 
select  ZFFS00,count(*) NUM,sum(NVL((JFJE00),0)) JE0000  from SF_brjfb0  where  jflbid = 1 
 and  ZFFS00 IN (1,2,3,4,10,11,8,18,24) and JFBZ00 in ('1','3') AND  JFRQ00 >= '20160415'
 and  JFRQ00 <= '20160415'
 and  JFRQ00||JFSJ00 >= '2016041500:00:00'
 and  JFRQ00||JFSJ00 <= '2016041523:59:59'
  group by  ZFFS00

2       13:31:07  SQL Execute: ORACLE -  select  'ÊÕÈë' XM, 138499.95 HJ, 37939.72 XJJE, 202 XJZS, 
11400 YHJE, 28 YHZS, 84580.23 YBJE, 445 YBZS, 4580 KJE, 8 KZS, 0 WXZFJE,0 WXZFZS,0 DZQBJE, 0 DZQBZS  from  dual 
 union all 
 select  'Í˳ö' XM, -2869.49 HJ, -1430.02 XJJE, 15 XJZS, 
0 YHJE, 0 YHZS, -1439.47 YBJE, 6 YBZS, 0 KJE, 0 KZS, 0 WXZFJE,0 WXZFZS,0 DZQBJE, 0 DZQBZS  from  dual 

3       13:31:07  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 ||',', ',493,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '493')
  AND (INSTR (',' || a.jsksbh || ',',',493,') > 0 or a.jsksbh is null)  

4       13:31:14  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 ||',', ',493,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '493')
  AND (INSTR (',' || a.jsksbh || ',',',493,') > 0 or a.jsksbh is null)  

5       13:31:24  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 ||',', ',493,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '493')
  AND (INSTR (',' || a.jsksbh || ',',',493,') > 0 or a.jsksbh is null)  

6       13:31:34  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 ||',', ',493,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '493')
  AND (INSTR (',' || a.jsksbh || ',',',493,') > 0 or a.jsksbh is null)