1       15:09:33  SQL Execute: ORACLE - SELECT X.*,(select ypmlbz from bm_yd0000 where ypnm00=X.ypnm00) ypmlbz FROM YK_YPRKMX X WHERE X.RKDH00=''

2       15:09:35  SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,YKYPKC,SPM000,PFJ000,YPMLBZ from VW_YF_YPSLSRTS where (PYSM00 Like ?) and( YKBMBH=78 and  YFBMBH=58 )  Order By PYSM00) where Rownum<=1000

3       15:09:36  SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,YKYPKC,SPM000,PFJ000,YPMLBZ from VW_YF_YPSLSRTS where (PYSM00 Like ?) and( YKBMBH=78 and  YFBMBH=58 )  Order By PYSM00) where Rownum<=1000

4       15:09:36  SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,YKYPKC,SPM000,PFJ000,YPMLBZ from VW_YF_YPSLSRTS where (PYSM00 Like ?) and( YKBMBH=78 and  YFBMBH=58 )  Order By PYSM00) where Rownum<=1000

5       15:09:37  SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,YKYPKC,SPM000,PFJ000,YPMLBZ from VW_YF_YPSLSRTS where (PYSM00 Like ?) and( YKBMBH=78 and  YFBMBH=58 )  Order By PYSM00) where Rownum<=1000

6       15:09:45  SQL Execute: ORACLE - Select * from (select YPNM00,YPMC00,SCPH00,LSDJ00,YKSL00,SJSL00,YPSXRQ,GJDJ00 from VW_YF_PCKCMX where (SCPH00 Like ?) and(   YPNM00=1151 and YFBMBH=58 )  Order By SCPH00) where Rownum<=1000

7       15:09:47  SQL Execute: ORACLE - delete from  YF_YPCKMX_TEMP 

8       15:09:47  SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,SCPH00,GJDJ00)
 VALUES(?,?,?,?,?,?)

9       15:09:47  SQL Execute: ORACLE - commit

10      15:09:47  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=1151
 AND A.SCPH00='120529'
 AND ROUND(A.LSDJ00/A.ZHL000,2)=ROUND(0.814583333333333,2)
 AND ROUND(A.GJDJ00/A.ZHL000,2)=ROUND(0.708333333333333,2)
 GROUP BY A.YPNM00,A.SCPH00,round(A.LSDJ00/A.ZHL000,20),round(A.GJDJ00/A.ZHL000,20)

11      15:09:47  SQL Execute: ORACLE - SELECT K2J000 FROM BM_YD0000
 WHERE YPNM00=1151

12      15:09:47  SQL Execute: ORACLE - SELECT ROUND(NVL(SJKCSL,0)/1,3)-96 SJKCSL FROM YF_PCKCMX 
 WHERE YFBMBH=58 AND YPNM00=1151
 AND SCPH00='120529' AND Round(LSDJ00,2)=9.77
 AND  Round(GJDJ00,2)=8.5