1       10:32:47  SQL Execute: ORACLE - SELECT X.*,(select ypmlbz from bm_yd0000 where ypnm00=X.ypnm00) ypmlbz,(select K2ZJJL from BM_YD0000 where YPNM00=X.YPNM00) K2ZJJL FROM YK_YPRKMX X WHERE X.RKDH00=''

2       10:32:48  SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

3       10:32:49  SQL Execute: ORACLE - select CZFLMC,YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,SJKCSL,SPM000,PFJ000,YPMLBZ,ZJJLDW,ZJJL2J,K2ZJJL from VW_YF_YPSLSRTS1 where (PYSM00 Like '%%' or YPBM00 Like '%%') and ( YKBMBH=356 and YFBMBH=355 )  and Rownum<=200

4       10:32:51  SQL Execute: ORACLE - select CZFLMC,YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,SJKCSL,SPM000,PFJ000,YPMLBZ,ZJJLDW,ZJJL2J,K2ZJJL from VW_YF_YPSLSRTS1 where (PYSM00 Like '%b%') and ( YKBMBH=356 and YFBMBH=355 )  and Rownum<=200

5       10:32:51  SQL Execute: ORACLE - select CZFLMC,YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,SJKCSL,SPM000,PFJ000,YPMLBZ,ZJJLDW,ZJJL2J,K2ZJJL from VW_YF_YPSLSRTS1 where (PYSM00 Like '%bn%') and ( YKBMBH=356 and YFBMBH=355 )  and Rownum<=200

6       10:32:51  SQL Execute: ORACLE - select CZFLMC,YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,SJKCSL,SPM000,PFJ000,YPMLBZ,ZJJLDW,ZJJL2J,K2ZJJL from VW_YF_YPSLSRTS1 where (PYSM00 Like '%bnp%') and ( YKBMBH=356 and YFBMBH=355 )  and Rownum<=200

7       10:32:51  SQL Execute: ORACLE - select CZFLMC,YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,SJKCSL,SPM000,PFJ000,YPMLBZ,ZJJLDW,ZJJL2J,K2ZJJL from VW_YF_YPSLSRTS1 where (PYSM00 Like '%bnpl%') and ( YKBMBH=356 and YFBMBH=355 )  and Rownum<=200

8       10:32:55  SQL Execute: ORACLE - select YPMC00,LSDJ00,SCPH00,QRRQ00,YPSXRQ,YPRKPC,SCCJBH,SCCJZW,YPQLDH,GJDJ00,CKSL00,ZHL000,SJKCXX,SFYX00,colour from VW_YF_YPTKPHTS  S where (SCPH00 Like '%%') and ( YKBMBH=356 and YPNM00=100113348 and YFBMBH=355 )  and Rownum<=200

9       10:33:19  SQL Execute: ORACLE - delete from  YF_YPCKMX_TEMP 

10      10:33:19  SQL Data In: ORACLE - Rows affected = 1
11      10:33:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 100113348
12      10:33:19  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 38.22
13      10:33:19  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 136.143000
14      10:33:19  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 14
15      10:33:19  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3140800
16      10:33:19  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 38.2
17      10:33:19  SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,SCPH00,GJDJ00)
 VALUES(?,?,?,?,?,?)

18      10:33:19  SQL Data In: ORACLE - Rows affected = 1
19      10:33:19  SQL Execute: ORACLE - commit

20      10:33:19  SQL Data In: ORACLE - Rows affected = 0
21      10:33:19  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=100113348
 AND A.SCPH00='3140800'
 AND ROUND(A.LSDJ00/A.ZHL000,2)=ROUND(2.73,2)
 AND ROUND(A.GJDJ00/A.ZHL000,2)=ROUND(2.72857142857143,2)
 GROUP BY A.YPNM00,A.SCPH00,round(A.LSDJ00/A.ZHL000,20),round(A.GJDJ00/A.ZHL000,20)

22      10:33:19  SQL Execute: ORACLE - SELECT K2J000 FROM BM_YD0000
 WHERE YPNM00=100113348

23      10:33:19  SQL Execute: ORACLE - SELECT ROUND(sum(NVL(YKKCSL,0)/1),3)-1906.002 YKKCSL FROM YF_PCKCMX 
 WHERE YFBMBH=355 AND YPNM00=100113348
 AND SCPH00='3140800' AND Round(LSDJ00,2)=38.22
 AND  Round(GJDJ00,2)=38.2