1 03:35:26 SQL Data In: ORACLE - Param = 1, Name = P_YKBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 169.000000 2 03:35:26 SQL Data In: ORACLE - Param = 2, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 3 03:35:26 SQL Data In: ORACLE - Param = 3, Name = P_LBBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 4 03:35:26 SQL Data In: ORACLE - Param = 4, Name = P_YLBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 5 03:35:26 SQL Data In: ORACLE - Param = 5, Name = P_JXBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 6 03:35:26 SQL Data In: ORACLE - Param = 6, Name = P_ZDFD00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 7 03:35:26 SQL Data In: ORACLE - Param = 7, Name = P_CKYF00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999999 8 03:35:26 SQL Data In: ORACLE - Param = 8, Name = P_SYYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 9 03:35:26 SQL Data In: ORACLE - Param = 9, Name = P_CGJHDH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 03:35:26 SQL Data In: ORACLE - Param = 10, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 03:35:26 SQL Data In: ORACLE - Param = 11, Name = P_GHDW00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 03:35:26 SQL Data In: ORACLE - Param = 12, Name = P_GHZQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 13 03:35:26 SQL Data In: ORACLE - Param = 13, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 223455 14 03:35:26 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,P_YYID00 => :P_YYID00); END; 15 03:35:26 SQL Execute: ORACLE - Commit 16 03:35:26 SQL Data In: ORACLE - Rows affected = 0 17 03:35:26 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=169 AND CGJHDH='003063' AND D.GHDWNM=W.GHDWNM(+) 18 03:35:26 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 19 03:35:26 SQL Execute: ORACLE - SELECT To_Char(SYSDATE-30, 'YYYYMMDD') OraSysDate FROM DUAL 20 03:35:26 SQL Execute: ORACLE - select bmbh00 from bm_bmbm00 where yyid00='223455' and bmxz00 in ('2','3') 21 03:35:26 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, D.YFZSL0, (select MAX(JZRQ00) ZHCKRQ FROM YK_YPMXZ0 WHERE YKBMBH=D.YKBMBH AND YPNM00=C.YPNM00 AND JZXZ00='C') ZHCKRQ,E.SFZBYP, nvl(c.YFSYL0,DECODE('Y','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 a.JZRQ00 BETWEEN '20220523' AND '20220530' 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 '20220430' AND '20220530' AND yfbmbh in (165,166,5,173,179,226,1329,163,1389,2809,2909,2910,2972)) JQYL00 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YD0000 E WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=169 AND CGJHDH='003063' AND C.YPNM00=E.YPNM00 ORDER BY GHDWNM,CGMXXH 22 03:36:16 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '3') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',169,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '169') AND (INSTR (',' || a.jsksbh || ',',',169,') > 0 or a.jsksbh is null) 23 03:36:18 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '3') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',169,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '169') AND (INSTR (',' || a.jsksbh || ',',',169,') > 0 or a.jsksbh is null) 24 03:36:30 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '3') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',169,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '169') AND (INSTR (',' || a.jsksbh || ',',',169,') > 0 or a.jsksbh is null) 25 03:36:32 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=24216 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 26 03:36:32 SQL Execute: ORACLE - select b.BMMC00,c.K2J000,Round(Sum(Nvl(a.FCSL00*a.ZHL000,0))/a.K2J000,3) FCSL00 from VW_YK_YFYPSYL a,BM_BMBM00 b,BM_YD0000 c where a.YPNM00=24216 and a.YFBMBH=b.BMBH00 and JZRQ00 BETWEEN '20220523' AND '20220530' and a.ypnm00=c.ypnm00 GROUP BY b.BMMC00,c.K2J000,PXXH00,BH0000 order by PXXH00,BH0000 27 03:36:32 SQL Error: ORACLE - ORA-00979: 不是 GROUP BY 表达式 28 03:36:32 SQL Error: ORACLE - Unmapped SQL Error Code: 979 29 03:36:32 SQL Data In: ORACLE - Rows affected = 0