1       16:34:49  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and XXXZ00='0'  and (xtdm00 = '-1' OR xtdm00 = 'C')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',15,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '15')
  AND (INSTR (',' || a.jsksbh || ',',',15,') > 0 or a.jsksbh is null)  

2       16:34:49  SQL Execute: ORACLE - Delete xt_zlsfgx where zlxmid=(select zlxmid from bm_zlzd00 where zlxmbh='Z024107')

3       16:34:49  SQL Data In: ORACLE - Rows affected = 0
4       16:34:49  SQL Execute: ORACLE - delete from BM_YBFYYZ where ZLXMID=(select zlxmid from bm_zlzd00 where zlxmbh='Z024107')

5       16:34:49  SQL Data In: ORACLE - Rows affected = 0
6       16:34:49  SQL Execute: ORACLE - Delete bm_zlzd00 where zlxmbh='Z024107'

7       16:35:24  SQL Data In: ORACLE - Rows affected = 1
8       16:35:24  SQL Execute: ORACLE - commit

9       16:35:24  SQL Data In: ORACLE - Rows affected = 0
10      16:35:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 224465
11      16:35:24  SQL Execute: ORACLE - Select zlxmid,zlxmbh,zlxmjc,lbbz00 "flag00" FROM bm_zlzd00 
where ( lbbz00='0' or (lbbz00='1' and tzrq00 is null)) and
 (rpad(nvl(FYID00,'0'),6,' ')=rpad('0',6,' ')  or FYID00=rpad(?,6,' '))
 order by zlxmbh

12      16:35:30  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Z024105
13      16:35:30  SQL Execute: ORACLE - Select g.sfxmid,g.zlxmid,xmmc00,zlxmjc,zlxmbh,gxid00,s.fymc00
from xt_zlsfgx g,vw_bm_zlzd00 z,vw_bm_yysfxm s
where g.zlxmid=z.zlxmid and g.sfxmid=s.sfxmid
and z.zlxmbh=?

14      16:35:30  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and XXXZ00='0'  and (xtdm00 = '-1' OR xtdm00 = 'C')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',15,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '15')
  AND (INSTR (',' || a.jsksbh || ',',',15,') > 0 or a.jsksbh is null)  

15      16:35:39  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and XXXZ00='0'  and (xtdm00 = '-1' OR xtdm00 = 'C')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',15,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '15')
  AND (INSTR (',' || a.jsksbh || ',',',15,') > 0 or a.jsksbh is null)  

16      16:35:49  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and XXXZ00='0'  and (xtdm00 = '-1' OR xtdm00 = 'C')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',15,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '15')
  AND (INSTR (',' || a.jsksbh || ',',',15,') > 0 or a.jsksbh is null)