1 16:38:32 SQL Execute: ORACLE - select count(*) from XT_MRJKSJ where mzzybz='1' 2 16:38:32 SQL Execute: ORACLE - Select to_date(MRJKSJ,'HH24:MI:SS') from XT_MRJKSJ where XQMC00=to_char(to_date('20231228','yyyymmdd'),'day') and MZZYBZ='1' 3 16:38:32 SQL Execute: ORACLE - select * from XT_YYXX00 a where exists(select 1 from BM_BMBM00 where YYID00=a.YYID00) 4 16:39:04 SQL Data In: ORACLE - Param = 1, Name = AS_TJRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20231228 5 16:39:04 SQL Data In: ORACLE - Param = 2, Name = AS_TJSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:00:00 6 16:39:04 SQL Data In: ORACLE - Param = 3, Name = AS_TJLB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 7 16:39:04 SQL Data In: ORACLE - Param = 4, Name = as_TJKS00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 8 16:39:04 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 16:39:04 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 16:39:04 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 16:39:04 SQL Data In: ORACLE - Param = 8, Name = as_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 12 16:39:04 SQL Execute: ORACLE - BEGIN "SP_ZY_WJFYBB" (AS_TJRQ00 => :AS_TJRQ00,AS_TJSJ00 => :AS_TJSJ00,AS_TJLB00 => :AS_TJLB00,as_TJKS00 => :as_TJKS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYID00 => :as_YYID00); END; 13 16:50:38 SQL Execute: ORACLE - select nvl(A.BMMC00,decode(B.bmbh00,-1,'本期合计数',-2,'上月合计数',-3,'与上月差额'))BMMC00,decode(B.bmbh00,-1,'-1',-2,'-1',-3,'-1',A.BMXZ00) XZSX00, B.ID0000,B.BMBH00,B.XMHJ00,B.YPHJ00,B.SFXM01,B.SFXM02,B.SFXM03,B.SFXM04,B.SFXM05,B.SFXM06,B.SFXM07,B.SFXM08,B.SFXM09,B.SFXM10,B.SFXM11,B.SFXM12,B.SFXM13,B.SFXM14,B.SFXM15,B.SFXM16, B.SFXM17,B.SFXM18,B.SFXM19,B.SFXM20,B.SFXM21,B.SFXM22,B.SFXM23,B.SFXM24,B.SFXM25,B.SFXM26, B.SFXM27,B.SFXM28,B.SFXM29,B.SFXM30,B.SFXM31,B.SFXM32,B.SFXM33,B.SFXM34,B.SFXM35,B.SFXM36, B.SFXM37,B.SFXM38,B.SFXM39,B.SFXM40,B.SFXM41,B.SFXM42,B.SFXM43,B.SFXM44,B.SFXM45,B.SFXM46, B.SFXM47,B.SFXM48,B.SFXM49,B.SFXM50,B.SFXM51,B.SFXM52,B.SFXM53,B.SFXM54,B.SFXM55,B.SFXM56, B.SFXM57,B.SFXM58,B.SFXM59,B.SFXM60,B.SFXM61,B.SFXM62,B.SFXM63,B.SFXM64,B.SFXM65,B.SFXM66, B.SFXM67,B.SFXM68,B.SFXM69,B.SFXM70,B.SFXM71,B.SFXM72,B.SFXM73,B.SFXM74,B.SFXM75,B.SFXM76, B.SFXM77,B.SFXM78,B.SFXM79,B.SFXM80,B.SFXM81,B.SFXM82,B.SFXM83,B.SFXM84,B.SFXM85,B.SFXM86, B.SFXM87,B.SFXM88,B.SFXM89,B.SFXM90,B.SFXM91,B.SFXM92,B.SFXM93,B.SFXM94,B.SFXM95,B.SFXM96, B.SFXM97,B.SFXM98,B.SFXM99,B.SJYSXM from BM_BMBM00 A,BM_YYSFTJ B where A.BMBH00(+)=B.BMBH00 AND B.ID0000=50088610 ORDER BY decode(B.bmbh00,-1,'-1',-2,'-1',-3,'-1',A.BMXZ00) desc ,A.BMBH00 desc 14 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='01' 15 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='02' 16 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='03' 17 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='04' 18 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='05' 19 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='06' 20 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='07' 21 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='08' 22 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='09' 23 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='10' 24 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='11' 25 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='12' 26 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='13' 27 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='14' 28 16:50:38 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='15' 29 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='16' 30 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='17' 31 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='18' 32 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='19' 33 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='20' 34 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='21' 35 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='22' 36 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='23' 37 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='24' 38 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='25' 39 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='26' 40 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='27' 41 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='28' 42 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='29' 43 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='30' 44 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='31' 45 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='32' 46 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='33' 47 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='34' 48 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='35' 49 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='36' 50 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='37' 51 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='38' 52 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='39' 53 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='40' 54 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='41' 55 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='42' 56 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='43' 57 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='44' 58 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='45' 59 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='46' 60 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='47' 61 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='48' 62 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='49' 63 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='50' 64 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='51' 65 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='52' 66 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='53' 67 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='54' 68 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='55' 69 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='56' 70 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='57' 71 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='58' 72 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='59' 73 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='60' 74 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='61' 75 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='62' 76 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='63' 77 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='64' 78 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='65' 79 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='66' 80 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='67' 81 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='68' 82 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='69' 83 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='70' 84 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='71' 85 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='72' 86 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='73' 87 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='74' 88 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='75' 89 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='76' 90 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='77' 91 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='78' 92 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='79' 93 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='80' 94 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='81' 95 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='82' 96 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='83' 97 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='84' 98 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='85' 99 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='86' 100 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='87' 101 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='88' 102 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='89' 103 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='90' 104 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='91' 105 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='92' 106 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='93' 107 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='94' 108 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='95' 109 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='96' 110 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='97' 111 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='98' 112 16:50:39 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='99'