1 09:04:13 SQL Execute: ORACLE - select SQ_BM_YYSFTJ_ID0000.nextval DJH000 from dual 2 09:04:13 SQL Execute: ORACLE - Insert into BM_YYSFTJ(ID0000,BMBH00,SFXM02,SFXM199,SFXM03,SFXM04,BZSM01) select 3907307,kdzxys,xmbh00,kdzxks,sum(hjje00),Sum(SF_SF_YDYPXZ(BRID00,DJH000,kdzxys,kdzxks,xmbh00,1,0))JSYJE0,'0' from( select e.brid00,e.kdzxys,e.xmbh00,e.kdzxks,e.DJH000,sum(e.hjje00)hjje00,Sum(e.JSYJE0)JSYJE0,'0' from (select b.brid00,a.kdys00 kdzxys,a.xmbh00,a.kdks00 kdzxks,b.DJH000,sum(a.hjje00) hjje00,0 JSYJE0 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and ( ( A.CZRQ00>='20180615' and A.CZRQ00<='20180615' and A.CZRQ00||A.CZSJ00 >='2018061500:00:00' and A.CZRQ00||A.CZSJ00 <= '2018061523:59:59') ) group by b.brid00,a.kdys00,a.xmbh00,a.kdks00,b.DJH000) e, (select brid00 from bm_brxxb0 where (fbbh00,yblb00) in (select fbbh00,yblb00 from ic_ybbrlb where (ybmc00='所有病人' or '所有病人'='所有病人'))) f where e.brid00=f.brid00 group by e.brid00,e.kdzxys,e.xmbh00,e.kdzxks,e.DJH000 ) group by kdzxys,xmbh00,kdzxks 3 09:04:15 SQL Data In: ORACLE - Rows affected = 1480 4 09:04:15 SQL Data In: ORACLE - Param = 1, Name = AD_INID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3907307.000000 5 09:04:15 SQL Data In: ORACLE - Param = 2, Name = AS_TJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6 09:04:15 SQL Data In: ORACLE - Param = 3, Name = AS_HSLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 7 09:04:15 SQL Data In: ORACLE - Param = 4, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 8 09:04:15 SQL Data In: ORACLE - Param = 5, Name = AD_XSNR00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 挂号科室,就诊医生, 9 09:04:15 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 09:04:15 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 09:04:15 SQL Execute: ORACLE - BEGIN "SP_SF_MZYS00_TJ0000" (AD_INID00 => :AD_INID00,AS_TJLB00 => :AS_TJLB00,AS_HSLB00 => :AS_HSLB00,AD_ID0000 => :AD_ID0000,AD_XSNR00 => :AD_XSNR00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 12 09:04:18 SQL Execute: ORACLE - update BM_YYSFTJ A set SFXM179=(SELECT sum(GHCS00) from VW_SF_GHLSXX B,BM_BRXXB0 C where B.BRID00+0=C.BRID00 and B.JZYS00=A.BMBH00 AND B.ghks00=a.sfxm199 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.CZRQ00>='20180615' and B.CZRQ00<= '20180615' ) and ( B.CZRQ00||B.CZSJ00 >='2018061500:00:00' and B.CZRQ00||B.CZSJ00 <= '2018061523:59:59' ) ) where A.ID0000 =3907308 13 09:04:18 SQL Data In: ORACLE - Rows affected = 82 14 09:04:18 SQL Execute: ORACLE - update BM_YYSFTJ A set SFXM179=(SELECT sum(GHCS00) from VW_SF_GHLSXX B,BM_BRXXB0 C where B.BRID00+0=C.BRID00 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.CZRQ00>='20180615' and B.CZRQ00<= '20180615' ) and ( B.CZRQ00||B.CZSJ00 >='2018061500:00:00' and B.CZRQ00||B.CZSJ00 <= '2018061523:59:59' ) ) where A.BMBH00=9999999999 AND A.ID0000 =3907308 15 09:04:18 SQL Data In: ORACLE - Rows affected = 1 16 09:04:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3907308.000000 17 09:04:18 SQL Execute: ORACLE - select C.PXXH00,B.YGBH00,C.BMBH00,C.BMMC00,DECODE(A.BMBH00,9999999999,'总 计',B.ZWXM00) ZWXM00,B.XKH000, sum(A.XMHJ00)XMHJ00,sum(A.SFXM179)SFXM179,round(decode(sum(SFXM179),0,0,sum(A.XMHJ00)/sum(A.SFXM179)),2) SFXM181, A.SFXM177,round(decode(A.YPHJ00,0,0,A.SFXM177/A.YPHJ00),2) SFXM178, sum(A.YPHJ00)YPHJ00,round((sum(A.YPHJ00)/nvl(DECODE(sum(A.XMHJ00),0,1,sum(A.XMHJ00)),1)),2) YPBL00, sum(A.SFXM01)SFXM01,sum(A.SFXM02)SFXM02,sum(A.SFXM03)SFXM03,sum(A.SFXM04)SFXM04,sum(A.SFXM05)SFXM05, sum(A.SFXM06)SFXM06,sum(A.SFXM07)SFXM07,sum(A.SFXM08)SFXM08,sum(A.SFXM09)SFXM09,sum(A.SFXM10)SFXM10, sum(A.SFXM11)SFXM11,sum(A.SFXM12)SFXM12,sum(A.SFXM13)SFXM13,sum(A.SFXM14)SFXM14,sum(A.SFXM15)SFXM15, sum(A.SFXM16)SFXM16,sum(A.SFXM17)SFXM17,sum(A.SFXM18)SFXM18,sum(A.SFXM19)SFXM19,sum(A.SFXM20)SFXM20, sum(A.SFXM21)SFXM21,sum(A.SFXM22)SFXM22,sum(A.SFXM23)SFXM23,sum(A.SFXM24)SFXM24,sum(A.SFXM25)SFXM25, sum(A.SFXM26)SFXM26,sum(A.SFXM27)SFXM27,sum(A.SFXM28)SFXM28,sum(A.SFXM29)SFXM29,sum(A.SFXM30)SFXM30, sum(A.SFXM31)SFXM31,sum(A.SFXM32)SFXM32,sum(A.SFXM33)SFXM33,sum(A.SFXM34)SFXM34,sum(A.SFXM35)SFXM35, sum(A.SFXM36)SFXM36,sum(A.SFXM37)SFXM37,sum(A.SFXM38)SFXM38,sum(A.SFXM39)SFXM39,sum(A.SFXM40)SFXM40, sum(A.SFXM41)SFXM41,sum(A.SFXM42)SFXM42,sum(A.SFXM43)SFXM43,sum(A.SFXM44)SFXM44,sum(A.SFXM45)SFXM45, sum(A.SFXM46)SFXM46,sum(A.SFXM47)SFXM47,sum(A.SFXM48)SFXM48,sum(A.SFXM49)SFXM49,sum(A.SFXM50)SFXM50, sum(A.SFXM300)SFXM300, sum(A.SFXM301)SFXM301,sum(A.SFXM302)SFXM302,sum(A.SFXM303)SFXM303,sum(A.SFXM304)SFXM304,sum(A.SFXM305)SFXM305, sum(A.SFXM306)SFXM306,sum(A.SFXM307)SFXM307,sum(A.SFXM308)SFXM308,sum(A.SFXM309)SFXM309,sum(A.SFXM310)SFXM310, sum(A.SFXM311)SFXM311,sum(A.SFXM312)SFXM312,sum(A.SFXM313)SFXM313,sum(A.SFXM314)SFXM314,sum(A.SFXM315)SFXM315, sum(A.SFXM316)SFXM316,sum(A.SFXM317)SFXM317,sum(A.SFXM318)SFXM318,sum(A.SFXM319)SFXM319,sum(A.SFXM320)SFXM320, sum(A.SFXM321)SFXM321,sum(A.SFXM322)SFXM322,sum(A.SFXM323)SFXM323,sum(A.SFXM324)SFXM324,sum(A.SFXM325)SFXM325, sum(A.SFXM326)SFXM326,sum(A.SFXM327)SFXM327,sum(A.SFXM328)SFXM328,sum(A.SFXM329)SFXM329,sum(A.SFXM330)SFXM330, sum(A.SFXM331)SFXM331,sum(A.SFXM332)SFXM332,sum(A.SFXM333)SFXM333,sum(A.SFXM334)SFXM334,sum(A.SFXM335)SFXM335, sum(A.SFXM336)SFXM336,sum(A.SFXM337)SFXM337,sum(A.SFXM338)SFXM338,sum(A.SFXM339)SFXM339,sum(A.SFXM340)SFXM340 from BM_YYSFTJ A,BM_YGBM00 B,BM_BMBM00 C where A.BMBH00 = B.YGBH00(+) and B.BMBH00=C.BMBH00(+) and A.ID0000 =? and a.XMHJ00<>0 group by C.PXXH00,B.YGBH00,c.BMBH00,C.BMMC00,DECODE(A.BMBH00,9999999999,'总 计',B.ZWXM00),B.XKH000 order by B.XKH000,C.PXXH00,C.BMBH00 18 09:04:18 SQL Error: ORACLE - ORA-00979: 不是 GROUP BY 表达式 19 09:04:18 SQL Error: ORACLE - Unmapped SQL Error Code: 979 20 09:04:18 SQL Data In: ORACLE - Rows affected = 0 21 09:04: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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)