1       09:50:34  SQL Execute: ORACLE - delete from  YF_YPCKMX_TEMP 

2       09:50:34  SQL Data In: ORACLE - Rows affected = 1
3       09:50:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 622
4       09:50:34  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 15.525
5       09:50:34  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10
6       09:50:34  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 120
7       09:50:34  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 130103
8       09:50:34  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 13.5
9       09:50:34  SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,SCPH00,GJDJ00)
 VALUES(?,?,?,?,?,?)

10      09:50:34  SQL Data In: ORACLE - Rows affected = 1
11      09:50:34  SQL Execute: ORACLE - commit

12      09:50:34  SQL Data In: ORACLE - Rows affected = 0
13      09:50:34  SQL Execute: ORACLE - SELECT SUM(A.CKSL00*A.ZHL000) RKSL00,round(A.LSDJ00/A.ZHL000,20) LSDJ00 ,round(A.GJDJ00/A.ZHL000,20) GJDJ00
 FROM YF_YPCKMX_TEMP A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00
 AND A.YPNM00=622
 AND A.SCPH00='130103'
 AND ROUND(A.LSDJ00/A.ZHL000,2)=ROUND(0.129375,2)
 AND ROUND(A.GJDJ00/A.ZHL000,2)=ROUND(0.1125,2)
 GROUP BY A.YPNM00,A.SCPH00,round(A.LSDJ00/A.ZHL000,20),round(A.GJDJ00/A.ZHL000,20)

14      09:50:34  SQL Execute: ORACLE - SELECT K2J000 FROM BM_YD0000
 WHERE YPNM00=622

15      09:50:34  SQL Execute: ORACLE - SELECT ROUND(NVL(SJKCSL,0)/1,6)-1200 SJKCSL,(1200-ROUND(NVL(SJKCSL,0)/1,6))/120 jdKCSL FROM YF_PCKCMX 
 WHERE YFBMBH=48 AND YPNM00=622
 AND SCPH00='130103' AND Round(LSDJ00,2)=15.52
 AND  Round(GJDJ00,2)=13.5

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