1 18:13:24 SQL Execute: ORACLE - select * from VW_ZY_BQMC00 WHERE BMXZ00 = '9' order by bh0000 2 18:13:24 SQL Execute: ORACLE - select * from IC_YBBRLB order by YBLB00 3 18:13:26 SQL Execute: ORACLE - select count(*) Num from bm_params 4 18:13:26 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 5 18:13:26 SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 6 18:13:26 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 7 18:13:26 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 8 18:13:26 SQL Data In: ORACLE - Param = 5, Name = AS_KSMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 9 18:13:26 SQL Data In: ORACLE - Param = 6, Name = AS_ZYH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 10 18:13:26 SQL Data In: ORACLE - Param = 7, Name = AS_SFCY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 11 18:13:26 SQL Data In: ORACLE - Param = 8, Name = AS_SFYB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 所有 12 18:13:26 SQL Data In: ORACLE - Param = 9, Name = AS_SFKDBQ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 13 18:13:26 SQL Data In: ORACLE - Param = 10, Name = AS_SFJZSJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 14 18:13:26 SQL Data In: ORACLE - Param = 11, Name = as_TSTJFS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 15 18:13:26 SQL Data In: ORACLE - Param = 12, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 16 18:13:26 SQL Data In: ORACLE - Param = 13, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 17 18:13:26 SQL Data In: ORACLE - Param = 14, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 18 18:13:26 SQL Execute: ORACLE - BEGIN "SP_ZY_ZYHSXM_SRTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_KSMC00 => :AS_KSMC00,AS_ZYH000 => :AS_ZYH000,AS_SFCY00 => :AS_SFCY00,AS_SFYB00 => :AS_SFYB00,AS_SFKDBQ => :AS_SFKDBQ,AS_SFJZSJ => :AS_SFJZSJ,as_TSTJFS => :as_TSTJFS,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 19 18:13:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 20 18:13:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 21 18:13:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1956596.000000 22 18:13:27 SQL Execute: ORACLE - select B.CYRQ00,A.BMBH00,NVL(B.ZYH000,' 总 计') ZYH000,B.YBZYH0,B.XM0000,B.XB0000, (select aa.YBMC00 from IC_YBBRLB aa where aa.FBBH00=b.FBBH00 and aa.YBLB00=b.YBLB00 and rownum=1)YBMC00, (select decode(trim(BRGFZH),'0',null,trim(BRGFZH)) from bm_brxxb0 f where f.brid00=b.brid00 and rownum=1)BRGFZH, B.RYCWH0,C.BMMC00,D.BMMC00 SZKSMC,E.BMMC00 RZKSMC,B.SXYSXM, to_char(greatest(to_date(b.RYRQ00,'YYYYMMDD'),to_date(?,'YYYYMMDD')),'YYYYMMDD') as TJKSRQ, decode(b.zyh000,null,null,to_char(least(to_date(NVL(b.CYRQ00,to_char(sysdate,'YYYYMMDD')),'YYYYMMDD'),to_date(?,'YYYYMMDD')),'YYYYMMDD')) as TJJSRQ, a.SFXM98 as ZYTS00, A.XMHJ00,A.SFXM01,A.SFXM02,A.SFXM03, (to_char((decode(nvl(A.XMHJ00,0),0,0,round((nvl(A.SFXM01,0)+nvl(A.SFXM02,0)+nvl(A.SFXM03,0))*100/A.XMHJ00,2))),'990.99'))||'%' YPBL00, A.SFXM04,A.SFXM05,A.SFXM06, A.SFXM07,A.SFXM08,A.SFXM09,A.SFXM10,A.SFXM11,A.SFXM12,A.SFXM13,A.SFXM14,A.SFXM15,A.SFXM16, A.SFXM17,A.SFXM18,A.SFXM19,A.SFXM20, A.SFXM21,A.SFXM22,A.SFXM23,A.SFXM24,A.SFXM25,A.SFXM26,A.SFXM27,A.SFXM28,A.SFXM29,A.SFXM30,A.SFXM31, A.SFXM32,A.SFXM33,A.SFXM34,A.SFXM35,A.SFXM36,A.SFXM37,A.SFXM38,A.SFXM39,A.SFXM40,A.SFXM41,A.SFXM42, A.SFXM43,A.SFXM44,A.SFXM45,A.SFXM46,A.SFXM47,A.SFXM48,A.SFXM49,A.SFXM50,A.SFXM51,A.SFXM52,A.SFXM53, A.SFXM54,A.SFXM55,A.SFXM56,A.SFXM57,A.SFXM58,A.SFXM59,A.SFXM60,A.SFXM61,A.SFXM62,A.SFXM63,A.SFXM64, A.SFXM65,A.SFXM66,A.SFXM67,A.SFXM68,A.SFXM69,A.SFXM70,A.SFXM71,A.SFXM72,A.SFXM73,A.SFXM74,A.SFXM75, A.SFXM76,A.SFXM77,A.SFXM78,A.SFXM79,A.SFXM80 from BM_YYSFTJ A,ZY_BRXXB0 B,BM_BMBM00 C ,BM_BMBM00 D,BM_BMBM00 E where A.SFXM99 = C.BMBH00(+) and A.BMBH00 = B.ZYID00(+) and B.DQKS00 = D.BMBH00(+) and B.RZKS00=E.BMBH00(+) and A.ID0000 =? order by ZYH000 23 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='01' order by XLH000 24 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='02' order by XLH000 25 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='03' order by XLH000 26 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='04' order by XLH000 27 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='05' order by XLH000 28 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='06' order by XLH000 29 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='07' order by XLH000 30 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='08' order by XLH000 31 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='09' order by XLH000 32 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='10' order by XLH000 33 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='11' order by XLH000 34 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='12' order by XLH000 35 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='13' order by XLH000 36 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='14' order by XLH000 37 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='15' order by XLH000 38 18:13:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='16' order by XLH000 39 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='17' order by XLH000 40 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='18' order by XLH000 41 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='19' order by XLH000 42 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='20' order by XLH000 43 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='21' order by XLH000 44 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='22' order by XLH000 45 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='23' order by XLH000 46 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='24' order by XLH000 47 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='25' order by XLH000 48 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='26' order by XLH000 49 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='27' order by XLH000 50 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='28' order by XLH000 51 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='29' order by XLH000 52 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='30' order by XLH000 53 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='31' order by XLH000 54 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='32' order by XLH000 55 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='33' order by XLH000 56 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='34' order by XLH000 57 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='35' order by XLH000 58 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='36' order by XLH000 59 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='37' order by XLH000 60 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='38' order by XLH000 61 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='39' order by XLH000 62 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='40' order by XLH000 63 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='41' order by XLH000 64 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='42' order by XLH000 65 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='43' order by XLH000 66 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='44' order by XLH000 67 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='45' order by XLH000 68 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='46' order by XLH000 69 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='47' order by XLH000 70 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='48' order by XLH000 71 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='49' order by XLH000 72 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='50' order by XLH000 73 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='51' order by XLH000 74 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='52' order by XLH000 75 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='53' order by XLH000 76 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='54' order by XLH000 77 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='55' order by XLH000 78 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='56' order by XLH000 79 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='57' order by XLH000 80 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='58' order by XLH000 81 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='59' order by XLH000 82 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='60' order by XLH000 83 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='61' order by XLH000 84 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='62' order by XLH000 85 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='63' order by XLH000 86 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='64' order by XLH000 87 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='65' order by XLH000 88 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='66' order by XLH000 89 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='67' order by XLH000 90 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='68' order by XLH000 91 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='69' order by XLH000 92 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='70' order by XLH000 93 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='71' order by XLH000 94 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='72' order by XLH000 95 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='73' order by XLH000 96 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='74' order by XLH000 97 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='75' order by XLH000 98 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='76' order by XLH000 99 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='77' order by XLH000 100 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='78' order by XLH000 101 18:13:28 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='79' order by XLH000 102 18:13:30 SQL Execute: ORACLE - select count(*) Num from bm_params 103 18:13:30 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 104 18:13:30 SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 105 18:13:30 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 106 18:13:30 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 107 18:13:30 SQL Data In: ORACLE - Param = 5, Name = AS_KSMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 108 18:13:30 SQL Data In: ORACLE - Param = 6, Name = AS_ZYH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 109 18:13:30 SQL Data In: ORACLE - Param = 7, Name = AS_SFCY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 110 18:13:30 SQL Data In: ORACLE - Param = 8, Name = AS_SFYB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 所有 111 18:13:30 SQL Data In: ORACLE - Param = 9, Name = AS_SFKDBQ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 112 18:13:30 SQL Data In: ORACLE - Param = 10, Name = AS_SFJZSJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 113 18:13:30 SQL Data In: ORACLE - Param = 11, Name = as_TSTJFS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 114 18:13:30 SQL Data In: ORACLE - Param = 12, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 115 18:13:30 SQL Data In: ORACLE - Param = 13, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 116 18:13:30 SQL Data In: ORACLE - Param = 14, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 117 18:13:30 SQL Execute: ORACLE - BEGIN "SP_ZY_ZYHSXM_SRTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_KSMC00 => :AS_KSMC00,AS_ZYH000 => :AS_ZYH000,AS_SFCY00 => :AS_SFCY00,AS_SFYB00 => :AS_SFYB00,AS_SFKDBQ => :AS_SFKDBQ,AS_SFJZSJ => :AS_SFJZSJ,as_TSTJFS => :as_TSTJFS,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 118 18:15:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 119 18:15:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 120 18:15:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1956597.000000 121 18:15:26 SQL Execute: ORACLE - select B.CYRQ00,A.BMBH00,NVL(B.ZYH000,' 总 计') ZYH000,B.YBZYH0,B.XM0000,B.XB0000, (select aa.YBMC00 from IC_YBBRLB aa where aa.FBBH00=b.FBBH00 and aa.YBLB00=b.YBLB00 and rownum=1)YBMC00, (select decode(trim(BRGFZH),'0',null,trim(BRGFZH)) from bm_brxxb0 f where f.brid00=b.brid00 and rownum=1)BRGFZH, B.RYCWH0,C.BMMC00,D.BMMC00 SZKSMC,E.BMMC00 RZKSMC,B.SXYSXM, to_char(greatest(to_date(b.RYRQ00,'YYYYMMDD'),to_date(?,'YYYYMMDD')),'YYYYMMDD') as TJKSRQ, decode(b.zyh000,null,null,to_char(least(to_date(NVL(b.CYRQ00,to_char(sysdate,'YYYYMMDD')),'YYYYMMDD'),to_date(?,'YYYYMMDD')),'YYYYMMDD')) as TJJSRQ, a.SFXM98 as ZYTS00, A.XMHJ00,A.SFXM01,A.SFXM02,A.SFXM03, (to_char((decode(nvl(A.XMHJ00,0),0,0,round((nvl(A.SFXM01,0)+nvl(A.SFXM02,0)+nvl(A.SFXM03,0))*100/A.XMHJ00,2))),'990.99'))||'%' YPBL00, A.SFXM04,A.SFXM05,A.SFXM06, A.SFXM07,A.SFXM08,A.SFXM09,A.SFXM10,A.SFXM11,A.SFXM12,A.SFXM13,A.SFXM14,A.SFXM15,A.SFXM16, A.SFXM17,A.SFXM18,A.SFXM19,A.SFXM20, A.SFXM21,A.SFXM22,A.SFXM23,A.SFXM24,A.SFXM25,A.SFXM26,A.SFXM27,A.SFXM28,A.SFXM29,A.SFXM30,A.SFXM31, A.SFXM32,A.SFXM33,A.SFXM34,A.SFXM35,A.SFXM36,A.SFXM37,A.SFXM38,A.SFXM39,A.SFXM40,A.SFXM41,A.SFXM42, A.SFXM43,A.SFXM44,A.SFXM45,A.SFXM46,A.SFXM47,A.SFXM48,A.SFXM49,A.SFXM50,A.SFXM51,A.SFXM52,A.SFXM53, A.SFXM54,A.SFXM55,A.SFXM56,A.SFXM57,A.SFXM58,A.SFXM59,A.SFXM60,A.SFXM61,A.SFXM62,A.SFXM63,A.SFXM64, A.SFXM65,A.SFXM66,A.SFXM67,A.SFXM68,A.SFXM69,A.SFXM70,A.SFXM71,A.SFXM72,A.SFXM73,A.SFXM74,A.SFXM75, A.SFXM76,A.SFXM77,A.SFXM78,A.SFXM79,A.SFXM80 from BM_YYSFTJ A,ZY_BRXXB0 B,BM_BMBM00 C ,BM_BMBM00 D,BM_BMBM00 E where A.SFXM99 = C.BMBH00(+) and A.BMBH00 = B.ZYID00(+) and B.DQKS00 = D.BMBH00(+) and B.RZKS00=E.BMBH00(+) and A.ID0000 =? order by ZYH000 122 18:15:26 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='01' order by XLH000 123 18:15:26 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='02' order by XLH000 124 18:15:26 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='03' order by XLH000 125 18:15:26 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='04' order by XLH000 126 18:15:26 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='05' order by XLH000 127 18:15:26 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='06' order by XLH000 128 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='07' order by XLH000 129 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='08' order by XLH000 130 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='09' order by XLH000 131 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='10' order by XLH000 132 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='11' order by XLH000 133 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='12' order by XLH000 134 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='13' order by XLH000 135 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='14' order by XLH000 136 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='15' order by XLH000 137 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='16' order by XLH000 138 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='17' order by XLH000 139 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='18' order by XLH000 140 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='19' order by XLH000 141 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='20' order by XLH000 142 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='21' order by XLH000 143 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='22' order by XLH000 144 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='23' order by XLH000 145 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='24' order by XLH000 146 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='25' order by XLH000 147 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='26' order by XLH000 148 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='27' order by XLH000 149 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='28' order by XLH000 150 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='29' order by XLH000 151 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='30' order by XLH000 152 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='31' order by XLH000 153 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='32' order by XLH000 154 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='33' order by XLH000 155 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='34' order by XLH000 156 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='35' order by XLH000 157 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='36' order by XLH000 158 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='37' order by XLH000 159 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='38' order by XLH000 160 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='39' order by XLH000 161 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='40' order by XLH000 162 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='41' order by XLH000 163 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='42' order by XLH000 164 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='43' order by XLH000 165 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='44' order by XLH000 166 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='45' order by XLH000 167 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='46' order by XLH000 168 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='47' order by XLH000 169 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='48' order by XLH000 170 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='49' order by XLH000 171 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='50' order by XLH000 172 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='51' order by XLH000 173 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='52' order by XLH000 174 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='53' order by XLH000 175 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='54' order by XLH000 176 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='55' order by XLH000 177 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='56' order by XLH000 178 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='57' order by XLH000 179 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='58' order by XLH000 180 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='59' order by XLH000 181 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='60' order by XLH000 182 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='61' order by XLH000 183 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='62' order by XLH000 184 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='63' order by XLH000 185 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='64' order by XLH000 186 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='65' order by XLH000 187 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='66' order by XLH000 188 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='67' order by XLH000 189 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='68' order by XLH000 190 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='69' order by XLH000 191 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='70' order by XLH000 192 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='71' order by XLH000 193 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='72' order by XLH000 194 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='73' order by XLH000 195 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='74' order by XLH000 196 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='75' order by XLH000 197 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='76' order by XLH000 198 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='77' order by XLH000 199 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='78' order by XLH000 200 18:15:27 SQL Execute: ORACLE - select * from BM_PARAMS where XLH000 ='79' order by XLH000 201 18:15:34 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 202 18:15:34 SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 203 18:15:34 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 204 18:15:34 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 205 18:15:34 SQL Data In: ORACLE - Param = 5, Name = AS_KSMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 206 18:15:34 SQL Data In: ORACLE - Param = 6, Name = AS_ZYH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 207 18:15:34 SQL Data In: ORACLE - Param = 7, Name = AS_SFYB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 所有 208 18:15:34 SQL Data In: ORACLE - Param = 8, Name = AS_SFCY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 209 18:15:34 SQL Data In: ORACLE - Param = 9, Name = AS_SFKDBQ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 210 18:15:34 SQL Data In: ORACLE - Param = 10, Name = AS_SFJZSJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 211 18:15:34 SQL Data In: ORACLE - Param = 11, Name = as_TSTJFS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 212 18:15:34 SQL Data In: ORACLE - Param = 12, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 213 18:15:34 SQL Data In: ORACLE - Param = 13, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 214 18:15:34 SQL Data In: ORACLE - Param = 14, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 215 18:15:34 SQL Execute: ORACLE - BEGIN "SP_ZY_BQBRFY_TJ0000" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_KSMC00 => :AS_KSMC00,AS_ZYH000 => :AS_ZYH000,AS_SFYB00 => :AS_SFYB00,AS_SFCY00 => :AS_SFCY00,AS_SFKDBQ => :AS_SFKDBQ,AS_SFJZSJ => :AS_SFJZSJ,as_TSTJFS => :as_TSTJFS,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 216 18:15:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 217 18:15:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200903 218 18:15:34 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1956598.000000 219 18:15:34 SQL Execute: ORACLE - select B.CYRQ00,A.BMBH00,NVL(B.ZYH000,' 总 计') ZYH000,B.YBZYH0,B.XM0000, B.XB0000, (select aa.YBMC00 from IC_YBBRLB aa where aa.FBBH00=b.FBBH00 and aa.YBLB00=b.YBLB00 and rownum=1)YBMC00, (select decode(trim(BRGFZH),'0',null,trim(BRGFZH)) from bm_brxxb0 f where f.brid00=b.brid00 and rownum=1)BRGFZH, B.RYCWH0,C.BMMC00,D.BMMC00 SZKSMC,E.BMMC00 RZKSMC,B.SXYSXM, a.SFXM98 as ZYTS00, to_char(greatest(to_date(b.RYRQ00,'YYYYMMDD'),to_date(?,'YYYYMMDD')),'YYYYMMDD') as TJKSRQ, decode(b.zyh000,null,null,to_char(least(to_date(NVL(b.CYRQ00,to_char(sysdate,'YYYYMMDD')),'YYYYMMDD'),to_date(?,'YYYYMMDD')),'YYYYMMDD')) as TJJSRQ, A.XMHJ00,A.SFXM01,A.SFXM02,A.SFXM03, (to_char((decode(nvl(A.XMHJ00,0),0,0,round((nvl(A.SFXM01,0)+nvl(A.SFXM02,0)+nvl(A.SFXM03,0))*100/A.XMHJ00,2))),'990.99'))||'%' YPBL00, A.SFXM04,A.SFXM05,A.SFXM06, A.SFXM07,A.SFXM08,A.SFXM09,A.SFXM10,A.SFXM11,A.SFXM12,A.SFXM13,A.SFXM14,A.SFXM15,A.SFXM16, A.SFXM17,A.SFXM18,A.SFXM19,A.SFXM20, A.SFXM21,A.SFXM22,A.SFXM23,A.SFXM24,A.SFXM25,A.SFXM26,A.SFXM27,A.SFXM28,A.SFXM29,A.SFXM30,A.SFXM31, A.SFXM32,A.SFXM33,A.SFXM34,A.SFXM35,A.SFXM36,A.SFXM37,A.SFXM38,A.SFXM39,A.SFXM40,A.SFXM41,A.SFXM42, A.SFXM43,A.SFXM44,A.SFXM45,A.SFXM46,A.SFXM47,A.SFXM48,A.SFXM49,A.SFXM50,A.SFXM51,A.SFXM52,A.SFXM53, A.SFXM54,A.SFXM55,A.SFXM56,A.SFXM57,A.SFXM58,A.SFXM59,A.SFXM60,A.SFXM61,A.SFXM62,A.SFXM63,A.SFXM64, A.SFXM65,A.SFXM66,A.SFXM67,A.SFXM68,A.SFXM69,A.SFXM70,A.SFXM71,A.SFXM72,A.SFXM73,A.SFXM74,A.SFXM75, A.SFXM76,A.SFXM77,A.SFXM78,A.SFXM79,A.SFXM80 from BM_YYSFTJ A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BMBM00 D,BM_BMBM00 E where A.SFXM99 = C.BMBH00(+) and A.BMBH00 = B.ZYID00(+) and B.DQKS00 = D.BMBH00(+) and B.RZKS00=E.BMBH00(+) and A.ID0000 =? order by ZYH000 220 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='01' order by ORDER0 221 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='02' order by ORDER0 222 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='03' order by ORDER0 223 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='04' order by ORDER0 224 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='05' order by ORDER0 225 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='06' order by ORDER0 226 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='07' order by ORDER0 227 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='08' order by ORDER0 228 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='09' order by ORDER0 229 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='10' order by ORDER0 230 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='11' order by ORDER0 231 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='12' order by ORDER0 232 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='13' order by ORDER0 233 18:15:34 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='14' order by ORDER0 234 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='15' order by ORDER0 235 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='16' order by ORDER0 236 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='17' order by ORDER0 237 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='18' order by ORDER0 238 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='19' order by ORDER0 239 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='20' order by ORDER0 240 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='21' order by ORDER0 241 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='22' order by ORDER0 242 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='23' order by ORDER0 243 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='24' order by ORDER0 244 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='25' order by ORDER0 245 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='26' order by ORDER0 246 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='27' order by ORDER0 247 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='28' order by ORDER0 248 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='29' order by ORDER0 249 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='30' order by ORDER0 250 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='31' order by ORDER0 251 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='32' order by ORDER0 252 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='33' order by ORDER0 253 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='34' order by ORDER0 254 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='35' order by ORDER0 255 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='36' order by ORDER0 256 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='37' order by ORDER0 257 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='38' order by ORDER0 258 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='39' order by ORDER0 259 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='40' order by ORDER0 260 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='41' order by ORDER0 261 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='42' order by ORDER0 262 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='43' order by ORDER0 263 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='44' order by ORDER0 264 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='45' order by ORDER0 265 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='46' order by ORDER0 266 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='47' order by ORDER0 267 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='48' order by ORDER0 268 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='49' order by ORDER0 269 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='50' order by ORDER0 270 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='51' order by ORDER0 271 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='52' order by ORDER0 272 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='53' order by ORDER0 273 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='54' order by ORDER0 274 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='55' order by ORDER0 275 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='56' order by ORDER0 276 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='57' order by ORDER0 277 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='58' order by ORDER0 278 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='59' order by ORDER0 279 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='60' order by ORDER0 280 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='61' order by ORDER0 281 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='62' order by ORDER0 282 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='63' order by ORDER0 283 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='64' order by ORDER0 284 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='65' order by ORDER0 285 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='66' order by ORDER0 286 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='67' order by ORDER0 287 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='68' order by ORDER0 288 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='69' order by ORDER0 289 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='70' order by ORDER0 290 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='71' order by ORDER0 291 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='72' order by ORDER0 292 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='73' order by ORDER0 293 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='74' order by ORDER0 294 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='75' order by ORDER0 295 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='76' order by ORDER0 296 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='77' order by ORDER0 297 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='78' order by ORDER0 298 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='79' order by ORDER0 299 18:15:35 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and BH0000='80' order by ORDER0