1 14:50:40 SQL Prepare: ORACLE - select * from (select a.CGDBH0,a.YPNM00,a.YPMC00,a.JXMC00,a.YPGG00, a.KCDW00,a.JLDW00,a.ZHL000,a.SCCJBH,a.SCCJMC,a.YKBMMC, a.YKBMBH,a.ZBJ000,a.GJJ000,a.LSJ000,a.JHSL00, a.GHDWNM,a.GHDWMC,b.LBBH00,b.YLBH00,b.JXBH00,c.SXH000, (select nvl(CGMXXH,1) CGMXXH from YK_CGJHMX c, YK_YPCGJH d WHERE c.CGJHDH=d.CGJHDH and d.cgdbh0=a.CGDBH0 and c.ypnm00=b.YPNM00 and ROWNUM=1) CGMXXH from YK_YPCGD0 a,bm_yd0000 b,BM_YPJX00 c where a.CGDBH0=:1 and a.YKBMBH=:2 and a.ypnm00=b.ypnm00 and b.lbbh00=c.lbbh00 and b.jxbh00=c.jxbh00) ORDER BY GHDWNM,LBBH00,SXH000,JXBH00,YLBH00 2 14:50:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33101.000000 3 14:50:40 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 522.000000 4 14:50:40 SQL Execute: ORACLE - select * from (select a.CGDBH0,a.YPNM00,a.YPMC00,a.JXMC00,a.YPGG00, a.KCDW00,a.JLDW00,a.ZHL000,a.SCCJBH,a.SCCJMC,a.YKBMMC, a.YKBMBH,a.ZBJ000,a.GJJ000,a.LSJ000,a.JHSL00, a.GHDWNM,a.GHDWMC,b.LBBH00,b.YLBH00,b.JXBH00,c.SXH000, (select nvl(CGMXXH,1) CGMXXH from YK_CGJHMX c, YK_YPCGJH d WHERE c.CGJHDH=d.CGJHDH and d.cgdbh0=a.CGDBH0 and c.ypnm00=b.YPNM00 and ROWNUM=1) CGMXXH from YK_YPCGD0 a,bm_yd0000 b,BM_YPJX00 c where a.CGDBH0=? and a.YKBMBH=? and a.ypnm00=b.ypnm00 and b.lbbh00=c.lbbh00 and b.jxbh00=c.jxbh00) ORDER BY GHDWNM,LBBH00,SXH000,JXBH00,YLBH00 5 14:50:40 SQL Prepare: ORACLE - select * from( select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL, to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL, to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,C.YFZSL0 YFZSL1, (SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0, (SELECT to_char(Round(Sum(Nvl(FCSL00*ZHL000/K2J000,0)),3),'9999990.999') FROM VW_YK_YFYPSYL WHERE YPNM00=C.YPNM00 AND JZRQ00 BETWEEN '20100401' AND '20100430' GROUP BY YPNM00) YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, (SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 from YK_CGJHMX C,VW_YK_YPZKC0 D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=522 AND C.CGJHDH=:1 union all select M.CGMXXH,M.CGJHDH,M.YPMC00,M.YPGG00,M.CGDW00,M.JHCGSL,M.GJDJ00,M.SCCJBH,M.SCCJZW,M.GMP000,M.JHSYSL,M.GJJE00,M.GHDWNM,YFZSL1, (select ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=:2) YFZSL0, ' ' YFSYL0,M.KCSL00,M.ZBXH00,M.ZBQMC0,M.YPTYM0,M.GHDWMC,M.LBBH00,M.YLBH00,M.JXBH00,M.SXH000 from ( select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL, ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM,SUM(C.YFZSL0) YFZSL1, ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=522 AND C.CGJHDH=:3) M )ORDER BY GHDWNM,LBBH00,SXH000,JXBH00,YLBH00 6 14:50:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 001299 7 14:50:40 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 001299 8 14:50:40 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 001299 9 14:50:40 SQL Execute: ORACLE - select * from( select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL, to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL, to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,C.YFZSL0 YFZSL1, (SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0, (SELECT to_char(Round(Sum(Nvl(FCSL00*ZHL000/K2J000,0)),3),'9999990.999') FROM VW_YK_YFYPSYL WHERE YPNM00=C.YPNM00 AND JZRQ00 BETWEEN '20100401' AND '20100430' GROUP BY YPNM00) YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, (SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 from YK_CGJHMX C,VW_YK_YPZKC0 D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=522 AND C.CGJHDH=? union all select M.CGMXXH,M.CGJHDH,M.YPMC00,M.YPGG00,M.CGDW00,M.JHCGSL,M.GJDJ00,M.SCCJBH,M.SCCJZW,M.GMP000,M.JHSYSL,M.GJJE00,M.GHDWNM,YFZSL1, (select ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=?) YFZSL0, ' ' YFSYL0,M.KCSL00,M.ZBXH00,M.ZBQMC0,M.YPTYM0,M.GHDWMC,M.LBBH00,M.YLBH00,M.JXBH00,M.SXH000 from ( select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL, ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM,SUM(C.YFZSL0) YFZSL1, ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=522 AND C.CGJHDH=?) M )ORDER BY GHDWNM,LBBH00,SXH000,JXBH00,YLBH00 10 14:50:40 SQL Prepare: ORACLE - SELECT TO_CHAR(TRUNC(TRUNC(TO_DATE('20100524','YYYYMMDD'),'MM')-1,'MM'),'YYYYMMDD') FIRSTDAY, TO_CHAR(LAST_DAY(TRUNC(TO_DATE('20100524','YYYYMMDD'),'MM')-1),'YYYYMMDD') LASTDAY FROM DUAL 11 14:50:40 SQL Execute: ORACLE - SELECT TO_CHAR(TRUNC(TRUNC(TO_DATE('20100524','YYYYMMDD'),'MM')-1,'MM'),'YYYYMMDD') FIRSTDAY, TO_CHAR(LAST_DAY(TRUNC(TO_DATE('20100524','YYYYMMDD'),'MM')-1),'YYYYMMDD') LASTDAY FROM DUAL 12 14:50:40 SQL Prepare: ORACLE - select * from( select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL, to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL, to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,C.YFZSL0 YFZSL1, (SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0, (SELECT to_char(Round(Sum(Nvl(FCSL00*ZHL000/K2J000,0)),3),'9999990.999') FROM VW_YK_YFYPSYL WHERE YPNM00=C.YPNM00 AND JZRQ00 BETWEEN '20100401' AND '20100430' GROUP BY YPNM00) YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, (SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 from YK_CGJHMX C,VW_YK_YPZKC0 D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=522 AND C.CGJHDH=:1 union all select M.CGMXXH,M.CGJHDH,M.YPMC00,M.YPGG00,M.CGDW00,M.JHCGSL,M.GJDJ00,M.SCCJBH,M.SCCJZW,M.GMP000,M.JHSYSL,M.GJJE00,M.GHDWNM,YFZSL1, (select ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=:2) YFZSL0, ' ' YFSYL0,M.KCSL00,M.ZBXH00,M.ZBQMC0,M.YPTYM0,M.GHDWMC,M.LBBH00,M.YLBH00,M.JXBH00,M.SXH000 from ( select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL, ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM,SUM(C.YFZSL0) YFZSL1, ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=522 AND C.CGJHDH=:3) M )ORDER BY GHDWNM,LBBH00,SXH000,JXBH00,YLBH00 13 14:50:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 001299 14 14:50:40 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 001299 15 14:50:40 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 001299 16 14:50:40 SQL Execute: ORACLE - select * from( select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL, to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL, to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,C.YFZSL0 YFZSL1, (SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0, (SELECT to_char(Round(Sum(Nvl(FCSL00*ZHL000/K2J000,0)),3),'9999990.999') FROM VW_YK_YFYPSYL WHERE YPNM00=C.YPNM00 AND JZRQ00 BETWEEN '20100401' AND '20100430' GROUP BY YPNM00) YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, (SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 from YK_CGJHMX C,VW_YK_YPZKC0 D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=522 AND C.CGJHDH=? union all select M.CGMXXH,M.CGJHDH,M.YPMC00,M.YPGG00,M.CGDW00,M.JHCGSL,M.GJDJ00,M.SCCJBH,M.SCCJZW,M.GMP000,M.JHSYSL,M.GJJE00,M.GHDWNM,YFZSL1, (select ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=?) YFZSL0, ' ' YFSYL0,M.KCSL00,M.ZBXH00,M.ZBQMC0,M.YPTYM0,M.GHDWMC,M.LBBH00,M.YLBH00,M.JXBH00,M.SXH000 from ( select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL, ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM,SUM(C.YFZSL0) YFZSL1, ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=522 AND C.CGJHDH=?) M )ORDER BY GHDWNM,LBBH00,SXH000,JXBH00,YLBH00 17 14:50:40 SQL Prepare: ORACLE - select * from (select a.CGDBH0,a.YPNM00,a.YPMC00,a.JXMC00,a.YPGG00, a.KCDW00,a.JLDW00,a.ZHL000,a.SCCJBH,a.SCCJMC,a.YKBMMC, a.YKBMBH,a.ZBJ000,a.GJJ000,a.LSJ000,a.JHSL00, a.GHDWNM,a.GHDWMC,b.LBBH00,b.YLBH00,b.JXBH00,c.SXH000, (select nvl(CGMXXH,1) CGMXXH from YK_CGJHMX c, YK_YPCGJH d WHERE c.CGJHDH=d.CGJHDH and d.cgdbh0=a.CGDBH0 and c.ypnm00=b.YPNM00 and ROWNUM=1) CGMXXH from YK_YPCGD0 a,bm_yd0000 b,BM_YPJX00 c where a.CGDBH0=:1 and a.YKBMBH=:2 and a.ypnm00=b.ypnm00 and b.lbbh00=c.lbbh00 and b.jxbh00=c.jxbh00) ORDER BY GHDWNM,LBBH00,SXH000,JXBH00,YLBH00 18 14:50:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33101.000000 19 14:50:40 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 522.000000 20 14:50:40 SQL Execute: ORACLE - select * from (select a.CGDBH0,a.YPNM00,a.YPMC00,a.JXMC00,a.YPGG00, a.KCDW00,a.JLDW00,a.ZHL000,a.SCCJBH,a.SCCJMC,a.YKBMMC, a.YKBMBH,a.ZBJ000,a.GJJ000,a.LSJ000,a.JHSL00, a.GHDWNM,a.GHDWMC,b.LBBH00,b.YLBH00,b.JXBH00,c.SXH000, (select nvl(CGMXXH,1) CGMXXH from YK_CGJHMX c, YK_YPCGJH d WHERE c.CGJHDH=d.CGJHDH and d.cgdbh0=a.CGDBH0 and c.ypnm00=b.YPNM00 and ROWNUM=1) CGMXXH from YK_YPCGD0 a,bm_yd0000 b,BM_YPJX00 c where a.CGDBH0=? and a.YKBMBH=? and a.ypnm00=b.ypnm00 and b.lbbh00=c.lbbh00 and b.jxbh00=c.jxbh00) ORDER BY GHDWNM,LBBH00,SXH000,JXBH00,YLBH00