1       16:08:57  SQL Prepare: ORACLE - select g.yfid00 from bm_ypyfgx g,bm_yd0000 d where g.yzyyp0=d.yzyyp0 and d.ypnm00=

2       16:08:57  SQL Data In: ORACLE - Rows affected = 0
3       16:09:01  SQL Prepare: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = 'Z')) or XXXZ00='0')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',314,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 66168
  AND b.JSKSBH = '314')
  AND (INSTR (',' || a.jsksbh || ',',',314,') > 0 or a.jsksbh is null)  

4       16:09:01  SQL Prepare: ORACLE - select nvl(count(*),0) col from JY_YW0000 where (SQKS00+0=314or SQBQ00+0=314) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00=to_char(sysdate,'yyyymmdd')

5       16:09:11  SQL Prepare: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = 'Z')) or XXXZ00='0')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',314,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 66168
  AND b.JSKSBH = '314')
  AND (INSTR (',' || a.jsksbh || ',',',314,') > 0 or a.jsksbh is null)  

6       16:09:19  SQL Prepare: ORACLE - select nvl(count(*),0) col from JY_YW0000 where (SQKS00+0=314or SQBQ00+0=314) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00=to_char(sysdate,'yyyymmdd')

7       16:09:21  SQL Prepare: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = 'Z')) or XXXZ00='0')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',314,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 66168
  AND b.JSKSBH = '314')
  AND (INSTR (',' || a.jsksbh || ',',',314,') > 0 or a.jsksbh is null)