264 16:45:39 SQL Data In: ORACLE - Param = 1, Name = AS_TJRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200501 265 16:45:39 SQL Data In: ORACLE - Param = 2, Name = AS_TJSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:00:00 266 16:45:39 SQL Data In: ORACLE - Param = 3, Name = AS_TJLB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 267 16:45:39 SQL Data In: ORACLE - Param = 4, Name = as_TJKS00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 268 16:45:39 SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 269 16:45:39 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 270 16:45:39 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 271 16:45:39 SQL Data In: ORACLE - Param = 8, Name = as_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 272 16:45:39 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; 273 16:48:35 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=1956498 ORDER BY decode(B.bmbh00,-1,'-1',-2,'-1',-3,'-1',A.BMXZ00) desc ,A.BMBH00 desc 274 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='01' 275 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='02' 276 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='03' 277 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='04' 278 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='05' 279 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='06' 280 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='07' 281 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='08' 282 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='09' 283 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='10' 284 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='11' 285 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='12' 286 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='13' 287 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='14' 288 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='15' 289 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='16' 290 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='17' 291 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='18' 292 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='19' 293 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='20' 294 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='21' 295 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='22' 296 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='23' 297 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='24' 298 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='25' 299 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='26' 300 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='27' 301 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='28' 302 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='29' 303 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='30' 304 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='31' 305 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='32' 306 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='33' 307 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='34' 308 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='35' 309 16:48:35 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='36' 310 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='37' 311 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='38' 312 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='39' 313 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='40' 314 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='41' 315 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='42' 316 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='43' 317 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='44' 318 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='45' 319 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='46' 320 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='47' 321 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='48' 322 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='49' 323 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='50' 324 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='51' 325 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='52' 326 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='53' 327 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='54' 328 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='55' 329 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='56' 330 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='57' 331 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='58' 332 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='59' 333 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='60' 334 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='61' 335 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='62' 336 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='63' 337 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='64' 338 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='65' 339 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='66' 340 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='67' 341 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='68' 342 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='69' 343 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='70' 344 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='71' 345 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='72' 346 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='73' 347 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='74' 348 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='75' 349 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='76' 350 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='77' 351 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='78' 352 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='79' 353 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='80' 354 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='81' 355 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='82' 356 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='83' 357 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='84' 358 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='85' 359 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='86' 360 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='87' 361 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='88' 362 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='89' 363 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='90' 364 16:48:36 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='91' 365 16:48:37 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='92' 366 16:48:37 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='93' 367 16:48:37 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='94' 368 16:48:37 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='95' 369 16:48:37 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='96' 370 16:48:37 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='97' 371 16:48:37 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='98' 372 16:48:37 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000 ='99'