1 10:30:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 413670.000000 2 10:30:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 3 10:30:53 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.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, (select nvl(SHSL00,0) SHSL00 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) JHSL00 ,a.BZ0000,b.PFJ000 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,CGMXXH 4 10:30:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 033606 5 10:30:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 033606 6 10:30:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 033606 7 10:30:53 SQL Execute: ORACLE - select * from( select to_char(C.SHSL00) SHSL00,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, NULL YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0,D.YPBM00,D.YPMLBZ, (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_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=? union all select ' ' SHSL00,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.YPBM00,M.YPMLBZ,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,' ' YPBM00,' ' YPMLBZ,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=?) M )ORDER BY GHDWNM,CGMXXH 8 10:30:53 SQL Execute: ORACLE - SELECT TO_CHAR(TRUNC(TRUNC(TO_DATE('20200914','YYYYMMDD'),'MM')-1,'MM'),'YYYYMMDD') FIRSTDAY1, TO_CHAR(LAST_DAY(TRUNC(TO_DATE('20200914','YYYYMMDD'),'MM')-1),'YYYYMMDD') LASTDAY1 FROM DUAL 9 10:30:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 033606 10 10:30:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 033606 11 10:30:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 033606 12 10:30:53 SQL Execute: ORACLE - select * from( select to_char(C.SHSL00) SHSL00,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, NULL YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0,D.YPBM00,D.YPMLBZ, (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_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=? union all select ' ' SHSL00,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.YPBM00,M.YPMLBZ,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,' ' YPBM00,' ' YPMLBZ,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=?) M )ORDER BY GHDWNM,CGMXXH 13 10:30:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 413670.000000 14 10:30:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 15 10:30:53 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.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, (select nvl(SHSL00,0) SHSL00 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) JHSL00 ,a.BZ0000,b.PFJ000 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,CGMXXH