1       09:29:03  SQL Data In: ORACLE - Param = 1, Name = PKSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200401
2       09:29:03  SQL Data In: ORACLE - Param = 2, Name = PJSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200429
3       09:29:03  SQL Data In: ORACLE - Param = 3, Name = PSTRSQL, Type = fldZSTRING, Precision = 65, Scale = 0, Data =  and a.BBCYRQ between '20200401' and '20200429'  and a.yjksbh=71 
4       09:29:03  SQL Execute: ORACLE - BEGIN "SP_JY_ZZSJTJ" (PKSRQ00 => :PKSRQ00,PJSRQ00 => :PJSRQ00,PSTRSQL => :PSTRSQL); END;
5       09:29:33  SQL Execute: ORACLE -  select ZYZBMC,ZZSJLB,JQZZZS,SNZZZS,JQZZBF,SNZZBF,         JQFHSL,SNFHSL,XMZS00,JQFHL0,SNFHL0  from JY_ZZSJTJ 

6       09:29:33  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 = 'J') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',71,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1496,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1496 AND b.JSKSBH = '71')
  AND (INSTR (',' || a.jsksbh || ',',',71,') > 0 or a.jsksbh is null)  

7       09:29:36  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 = 'J') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',71,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1496,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1496 AND b.JSKSBH = '71')
  AND (INSTR (',' || a.jsksbh || ',',',71,') > 0 or a.jsksbh is null)  

8       09:29:46  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 = 'J') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',71,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1496,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1496 AND b.JSKSBH = '71')
  AND (INSTR (',' || a.jsksbh || ',',',71,') > 0 or a.jsksbh is null)  

9       09:29:56  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 = 'J') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',71,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1496,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1496 AND b.JSKSBH = '71')
  AND (INSTR (',' || a.jsksbh || ',',',71,') > 0 or a.jsksbh is null)  

