1       11:43:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20181010
2       11:43:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20181010
3       11:43:11  SQL Execute: ORACLE -  select  A.*,B.PJZT00 from  VW_ZY_BRJFB0 A,ZY_PJSYQK B  where A.PJH000 = B.PJH000 and A.ZFFS00 IN (1,2,8,24,25) and A.JZDH00 = 0 and A.JFLBID  = 2 
 and  A.JFRQ00 >= ?
 and  A.JFRQ00 <= ?
 order  by  A.DJH000  DESC 

4       11:43:12  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 = '5') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',494,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1913,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1913 AND b.JSKSBH = '494')
  AND (INSTR (',' || a.jsksbh || ',',',494,') > 0 or a.jsksbh is null)