1       12:53:47  SQL Execute: ORACLE - SELECT * FROM BM_YPYL00
 WHERE LBBH00=''

2       12:53:47  SQL Execute: ORACLE - SELECT * FROM BM_YPJX00
 WHERE LBBH00=''

3       12:53:47  SQL Execute: ORACLE - select a.*,  
 (SELECT Round(Sum(Nvl(b.FCSL00*b.ZHL000/b.K2J000,0)),3) FROM VW_YK_YFYPSYL b,YF_YPKCXX c WHERE b.YFBMBH=670and c.LSDJ00=a.LSJ000 and b.YFBMBH=c.YFBMBH and b.YPNM00=c.YPNM00 and b.YPNM00=a.YPNM00 AND b.JZRQ00 BETWEEN '20170516' AND '20170523' GROUP BY b.YPNM00) YFSYL0 
 from VW_YF_YPKCXX a
 where a.LBBH00 like '%'
 and a.YLBH00 like '%'
 and a.JXBH00 like '%'
 and a.YFBMBH=670
 and a.PDXH00<>'0' 
 order by a.YPBM00 

4       12:53:52  SQL Execute: ORACLE - select BMMC00,K2J000,Round(Sum(Nvl(SJKCSL,0))/c.K2J000,3) KCSL00
 from  YF_YPKCXX a,BM_BMBM00 b,BM_YD0000 c where a.YPNM00=25
 and a.LSDJ00=3.42
 and a.YFBMBH=b.BMBH00 AND Nvl(SJKCSL,0)>0 
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,K2J000,PXXH00,BH0000 order by PXXH00,BH0000

5       12:53:52  SQL Execute: ORACLE - select b.BMMC00,c.K2J000,Round(Sum(Nvl(a.FCSL00*a.ZHL000,0))/c.K2J000,3) FCSL00
 from  VW_YK_YFYPSYL a,BM_BMBM00 b,BM_YD0000 c,YF_YPKCXX d where a.YPNM00=25
 and a.YFBMBH=b.BMBH00 and JZRQ00 BETWEEN '20170516'  AND '20170523'
 and c.YPNM00=d.YPNM00 and b.BMBH00=d.YFBMBH  
 and d.LSDJ00=3.42
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,c.K2J000,PXXH00,BH0000 order by PXXH00,BH0000

6       12:53:52  SQL Execute: ORACLE - select BMMC00,K2J000,Round(Sum(Nvl(SJKCSL,0))/c.K2J000,3) KCSL00
 from  YF_YPKCXX a,BM_BMBM00 b,BM_YD0000 c where a.YPNM00=25
 and a.LSDJ00=3.42
 and a.YFBMBH=b.BMBH00 AND Nvl(SJKCSL,0)>0 
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,K2J000,PXXH00,BH0000 order by PXXH00,BH0000

7       12:53:52  SQL Execute: ORACLE - select b.BMMC00,c.K2J000,Round(Sum(Nvl(a.FCSL00*a.ZHL000,0))/c.K2J000,3) FCSL00
 from  VW_YK_YFYPSYL a,BM_BMBM00 b,BM_YD0000 c,YF_YPKCXX d where a.YPNM00=25
 and a.YFBMBH=b.BMBH00 and JZRQ00 BETWEEN '20170516'  AND '20170523'
 and c.YPNM00=d.YPNM00 and b.BMBH00=d.YFBMBH  
 and d.LSDJ00=3.42
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,c.K2J000,PXXH00,BH0000 order by PXXH00,BH0000

8       12:53:52  SQL Execute: ORACLE - select BMMC00,K2J000,Round(Sum(Nvl(SJKCSL,0))/c.K2J000,3) KCSL00
 from  YF_YPKCXX a,BM_BMBM00 b,BM_YD0000 c where a.YPNM00=25
 and a.LSDJ00=3.42
 and a.YFBMBH=b.BMBH00 AND Nvl(SJKCSL,0)>0 
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,K2J000,PXXH00,BH0000 order by PXXH00,BH0000

9       12:53:52  SQL Execute: ORACLE - select b.BMMC00,c.K2J000,Round(Sum(Nvl(a.FCSL00*a.ZHL000,0))/c.K2J000,3) FCSL00
 from  VW_YK_YFYPSYL a,BM_BMBM00 b,BM_YD0000 c,YF_YPKCXX d where a.YPNM00=25
 and a.YFBMBH=b.BMBH00 and JZRQ00 BETWEEN '20170516'  AND '20170523'
 and c.YPNM00=d.YPNM00 and b.BMBH00=d.YFBMBH  
 and d.LSDJ00=3.42
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,c.K2J000,PXXH00,BH0000 order by PXXH00,BH0000

10      12:53:52  SQL Execute: ORACLE - select BMMC00,K2J000,Round(Sum(Nvl(SJKCSL,0))/c.K2J000,3) KCSL00
 from  YF_YPKCXX a,BM_BMBM00 b,BM_YD0000 c where a.YPNM00=3223
 and a.LSDJ00=22.02
 and a.YFBMBH=b.BMBH00 AND Nvl(SJKCSL,0)>0 
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,K2J000,PXXH00,BH0000 order by PXXH00,BH0000

11      12:53:52  SQL Execute: ORACLE - select b.BMMC00,c.K2J000,Round(Sum(Nvl(a.FCSL00*a.ZHL000,0))/c.K2J000,3) FCSL00
 from  VW_YK_YFYPSYL a,BM_BMBM00 b,BM_YD0000 c,YF_YPKCXX d where a.YPNM00=3223
 and a.YFBMBH=b.BMBH00 and JZRQ00 BETWEEN '20170516'  AND '20170523'
 and c.YPNM00=d.YPNM00 and b.BMBH00=d.YFBMBH  
 and d.LSDJ00=22.02
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,c.K2J000,PXXH00,BH0000 order by PXXH00,BH0000

12      12:53:54  SQL Execute: ORACLE - select BMMC00,K2J000,Round(Sum(Nvl(SJKCSL,0))/c.K2J000,3) KCSL00
 from  YF_YPKCXX a,BM_BMBM00 b,BM_YD0000 c where a.YPNM00=5398
 and a.LSDJ00=7.69
 and a.YFBMBH=b.BMBH00 AND Nvl(SJKCSL,0)>0 
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,K2J000,PXXH00,BH0000 order by PXXH00,BH0000

13      12:53:54  SQL Execute: ORACLE - select b.BMMC00,c.K2J000,Round(Sum(Nvl(a.FCSL00*a.ZHL000,0))/c.K2J000,3) FCSL00
 from  VW_YK_YFYPSYL a,BM_BMBM00 b,BM_YD0000 c,YF_YPKCXX d where a.YPNM00=5398
 and a.YFBMBH=b.BMBH00 and JZRQ00 BETWEEN '20170516'  AND '20170523'
 and c.YPNM00=d.YPNM00 and b.BMBH00=d.YFBMBH  
 and d.LSDJ00=7.69
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,c.K2J000,PXXH00,BH0000 order by PXXH00,BH0000

14      12:53:56  SQL Execute: ORACLE - select BMMC00,K2J000,Round(Sum(Nvl(SJKCSL,0))/c.K2J000,3) KCSL00
 from  YF_YPKCXX a,BM_BMBM00 b,BM_YD0000 c where a.YPNM00=481
 and a.LSDJ00=1.58
 and a.YFBMBH=b.BMBH00 AND Nvl(SJKCSL,0)>0 
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,K2J000,PXXH00,BH0000 order by PXXH00,BH0000

15      12:53:56  SQL Execute: ORACLE - select b.BMMC00,c.K2J000,Round(Sum(Nvl(a.FCSL00*a.ZHL000,0))/c.K2J000,3) FCSL00
 from  VW_YK_YFYPSYL a,BM_BMBM00 b,BM_YD0000 c,YF_YPKCXX d where a.YPNM00=481
 and a.YFBMBH=b.BMBH00 and JZRQ00 BETWEEN '20170516'  AND '20170523'
 and c.YPNM00=d.YPNM00 and b.BMBH00=d.YFBMBH  
 and d.LSDJ00=1.58
 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,c.K2J000,PXXH00,BH0000 order by PXXH00,BH0000