1       17:40:32  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 = '2') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',497,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '497')
  AND (INSTR (',' || a.jsksbh || ',',',497,') > 0 or a.jsksbh is null)  

2       17:40:33  SQL Execute: ORACLE - delete from  YF_YPCKMX_TEMP 

3       17:40:33  SQL Data In: ORACLE - Rows affected = 2
4       17:40:33  SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=497

5       17:40:33  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6696
6       17:40:33  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10.79
7       17:40:33  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
8       17:40:33  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
9       17:40:33  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6.95
10      17:40:33  SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,GJDJ00)
 VALUES(?,?,?,?,?)

11      17:40:33  SQL Data In: ORACLE - Rows affected = 1
12      17:40:33  SQL Execute: ORACLE - commit

13      17:40:33  SQL Data In: ORACLE - Rows affected = 0
14      17:40:33  SQL Execute: ORACLE - SELECT SUM(A.CKSL00*A.ZHL000) RKSL00
 FROM YF_YPCKMX_TEMP A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00
 AND A.YPNM00=6696
 GROUP BY A.YPNM00

15      17:40:33  SQL Execute: ORACLE - SELECT K2J000 FROM BM_YD0000
 WHERE YPNM00=6696

16      17:40:33  SQL Execute: ORACLE - SELECT ROUND(NVL(SJKCSL,0)/1,6)-25 SJKCSL,(25-ROUND(NVL(SJKCSL,0)/1,6))/5 jdKCSL FROM YF_YPKCXX
 WHERE YFBMBH=497 AND YPNM00=6696

17      17:40:33  SQL Execute: ORACLE -  SELECT RKSL00*ZHL000 RKSL00,PCKCSL+ (5*5 ) PCKCSL FROM YK_YPRKMX WHERE YPRKPC=124527