1 09:59:21 SQL Data In: ORACLE - Param = 1, Name = P_YKBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 515.000000 2 09:59:21 SQL Data In: ORACLE - Param = 2, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4255.000000 3 09:59:21 SQL Data In: ORACLE - Param = 3, Name = P_LBBH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 4 09:59:21 SQL Data In: ORACLE - Param = 4, Name = P_YLBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 5 09:59:21 SQL Data In: ORACLE - Param = 5, Name = P_JXBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 6 09:59:21 SQL Data In: ORACLE - Param = 6, Name = P_ZDFD00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 7 09:59:21 SQL Data In: ORACLE - Param = 7, Name = P_CKYF00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999999 8 09:59:21 SQL Data In: ORACLE - Param = 8, Name = P_SYYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 9 09:59:21 SQL Data In: ORACLE - Param = 9, Name = P_CGJHDH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 09:59:21 SQL Data In: ORACLE - Param = 10, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 09:59:21 SQL Data In: ORACLE - Param = 11, Name = P_GHDW00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 09:59:21 SQL Data In: ORACLE - Param = 12, Name = P_GHZQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 13 09:59:21 SQL Execute: ORACLE - BEGIN "SP_YK_YPCGJHSC" (P_YKBMBH => :P_YKBMBH,P_CZYBH0 => :P_CZYBH0,P_LBBH00 => :P_LBBH00,P_YLBH00 => :P_YLBH00,P_JXBH00 => :P_JXBH00,P_ZDFD00 => :P_ZDFD00,P_CKYF00 => :P_CKYF00,P_SYYP00 => :P_SYYP00,P_CGJHDH => :P_CGJHDH,P_MESSAGE => :P_MESSAGE,P_GHDW00 => :P_GHDW00,P_GHZQ00 => :P_GHZQ00); END; 14 09:59:21 SQL Execute: ORACLE - Commit 15 09:59:21 SQL Data In: ORACLE - Rows affected = 0 16 09:59:21 SQL Execute: ORACLE - SELECT D.CGJHDH,D.YKBMBH,D.CZYBH0,D.QRRBH0,D.SFQR00,D.JHBZRQ,D.QRRQ00,D.GHDWNM, W.GHDWMC from YK_YPCGJH D,BM_YPGHDW W WHERE SFQR00='N' AND YKBMBH=515 AND CGJHDH='005764' AND D.GHDWNM=W.GHDWNM(+) 17 09:59:21 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 18 09:59:21 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 19 09:59:21 SQL Execute: ORACLE - select bmbh00 from bm_bmbm00 where yyid00='B' and bmxz00 in ('2','3') 20 09:59:21 SQL Execute: ORACLE - select C.CGJHDH,C.YPNM00,C.YPMC00,C.YPGG00,C.CGDW00,C.ZHL000,C.BZ0000, C.LSDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,C.CGCKSL,nvl(C.GHDWNM,1) GHDWNM,nvl(C.CGMXXH,1) CGMXXH,D.YPBM00, C.JHCGSL,C.GJDJ00,D.KCSL00,D.KCSX00,D.KCXX00,D.ZBXH00,D.PYSM00, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC, E.YPTYM0,E.ZBQMC0, ( SELECT ROUND(SUM(NVL(K.SJKCSL,0)/E.K2J000),3) FROM YF_YPKCXX K WHERE K.YPNM00=D.YPNM00 and exists (select 1 from bm_bmbm00 a where a.bmbh00=k.yfbmbh and a.yyid00='B')) YFZSL0, (select MAX(JZRQ00) ZHCKRQ FROM YK_YPMXZ0 WHERE YKBMBH=D.YKBMBH AND YPNM00=C.YPNM00 AND JZXZ00='C') ZHCKRQ,E.SFZBYP, (DECODE('N','N',0, (SELECT Round(Sum(Nvl(a.FCSL00*a.ZHL000/a.K2J000,0)),3) FROM VW_YK_YFYPSYL a WHERE a.YPNM00=C.YPNM00 and exists (select 1 from bm_bmbm00 b where b.bmbh00=a.yfbmbh and b.yyid00='B') AND a.JZRQ00 BETWEEN '20181227' AND '20190103' GROUP BY a.YPNM00))) YFSYL0,E.YPMLBZ, (SELECT Round(Sum(Nvl(FCSL00*ZHL000/K2J000,0)),3) FROM VW_YK_YFYPSYL WHERE YPNM00=C.YPNM00 AND JZRQ00 BETWEEN '20190003' AND '20190103' AND yfbmbh in (512,513,514,518)) JQYL00 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YD0000 E WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=515 AND CGJHDH='005764' AND C.YPNM00=E.YPNM00 ORDER BY GHDWNM,D.YPBM00,E.LBBH00,E.JXBH00,E.YLBH00