1 10:09:56 SQL Execute: ORACLE - select SF_SF_CHECKHSXM NUM from dual 2 10:09:56 SQL Execute: ORACLE - select SQ_BM_YYSFTJ_ID0000.nextval DJH000 from dual 3 10:09:56 SQL Execute: ORACLE - Insert into BM_YYSFTJ(ID0000,BMBH00,SFXM02,SFXM199,SFXM03,SFXM04,BZSM01) select 588627,kdzxys,xmbh00,kdzxks,sum(hjje00),Sum(JSYJE0),'0' from (select brid00,kdys00 kdzxys,xmbh00,kdks00 kdzxks,sum(a.hjje00) hjje00,0 JSYJE0 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and ( ( A.CZRQ00>='20220101' and A.CZRQ00<='20221231' and A.CZRQ00||A.CZSJ00 >='2022010100:00:00' and A.CZRQ00||A.CZSJ00 <= '2022123123:59:59') ) group by brid00,kdys00,xmbh00,kdks00) 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 kdzxys,xmbh00,kdzxks 4 10:09:59 SQL Data In: ORACLE - Rows affected = 6571 5 10:09:59 SQL Data In: ORACLE - Param = 1, Name = AD_INID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 588627.000000 6 10:09:59 SQL Data In: ORACLE - Param = 2, Name = AS_TJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 7 10:09:59 SQL Data In: ORACLE - Param = 3, Name = AS_HSLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 8 10:09:59 SQL Data In: ORACLE - Param = 4, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 10:09:59 SQL Data In: ORACLE - Param = 5, Name = AD_XSNR00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 挂号科室,就诊医生, 10 10:09:59 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 10:09:59 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 12 10:09:59 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; 13 10:10:07 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>='20220101' and B.CZRQ00<= '20221231' ) and ( B.CZRQ00||B.CZSJ00 >='2022010100:00:00' and B.CZRQ00||B.CZSJ00 <= '2022123123:59:59' ) ) where A.ID0000 =588630 14 10:10:29 SQL Data In: ORACLE - Rows affected = 326 15 10:10:29 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>='20220101' and B.CZRQ00<= '20221231' ) and ( B.CZRQ00||B.CZSJ00 >='2022010100:00:00' and B.CZRQ00||B.CZSJ00 <= '2022123123:59:59' ) ) where A.BMBH00=9999999999 AND A.ID0000 =588630 16 10:10:29 SQL Data In: ORACLE - Rows affected = 1 17 10:10:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 588630.000000 18 10:10:30 SQL Execute: ORACLE - select B.YGBH00,A.BMBH00,C.BMMC00, DECODE(A.BMBH00,9999999999,' 总 计',B.ZWXM00) ZWXM00,B.XKH000,A.XMHJ00,A.SFXM179,round(decode(SFXM179,0,0,A.XMHJ00/A.SFXM179),2) SFXM181,A.YPHJ00,round((A.YPHJ00/nvl(DECODE(A.XMHJ00,0,1,A.XMHJ00),1)),2) YPBL00, A.SFXM177,round(decode(A.YPHJ00,0,0,A.SFXM177/A.YPHJ00),2)SFXM178, A.SFXM01,A.SFXM02,A.SFXM03,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,A.SFXM81,A.SFXM82,A.SFXM83,A.SFXM84,A.SFXM85,A.SFXM86,A.SFXM87, A.SFXM88,A.SFXM89,A.SFXM90,A.SFXM91,A.SFXM92,A.SFXM93,A.SFXM94,A.SFXM95,A.SFXM96,A.SFXM97,A.SFXM98,A.SFXM99, A.SFXM100,A.SFXM101,A.SFXM102,A.SFXM103,A.SFXM104,A.SFXM105,A.SFXM106,A.SFXM107,A.SFXM108,A.SFXM109, A.SFXM110,A.SFXM111,A.SFXM112,A.SFXM113,A.SFXM114,A.SFXM115,A.SFXM116,A.SFXM117,A.SFXM118,A.SFXM119, A.SFXM120,A.SFXM121,A.SFXM122,A.SFXM123,A.SFXM124,A.SFXM125,A.SFXM126,A.SFXM127,A.SFXM128,A.SFXM129, A.SFXM300, A.SFXM301,A.SFXM302,A.SFXM303,A.SFXM304,A.SFXM305,A.SFXM306,A.SFXM307,A.SFXM308,A.SFXM309,A.SFXM310, A.SFXM311,A.SFXM312,A.SFXM313,A.SFXM314,A.SFXM315,A.SFXM316,A.SFXM317,A.SFXM318,A.SFXM319,A.SFXM320, A.SFXM321,A.SFXM322,A.SFXM323,A.SFXM324,A.SFXM325,A.SFXM326,A.SFXM327,A.SFXM328,A.SFXM329,A.SFXM330, A.SFXM331,A.SFXM332,A.SFXM333,A.SFXM334,A.SFXM335,A.SFXM336,A.SFXM337,A.SFXM338,A.SFXM339,A.SFXM340 from BM_YYSFTJ A,BM_YGBM00 B,BM_BMBM00 C where A.BMBH00 = B.YGBH00(+) and A.SFXM199 = C.BMBH00(+) and A.ID0000 =? order by B.XKH000,C.PXXH00,C.BMBH00,B.ZWXM00 19 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='1' 20 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='2' 21 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='3' 22 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='4' 23 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='5' 24 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='6' 25 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='7' 26 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='8' 27 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='9' 28 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='10' 29 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='11' 30 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='12' 31 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='13' 32 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='14' 33 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='15' 34 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='16' 35 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='17' 36 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='18' 37 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='19' 38 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='20' 39 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='21' 40 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='22' 41 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='23' 42 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='24' 43 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='25' 44 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='26' 45 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='27' 46 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='28' 47 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='29' 48 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='30' 49 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='31' 50 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='32' 51 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='33' 52 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='34' 53 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='35' 54 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='36' 55 10:10:30 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='37' 56 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='38' 57 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='39' 58 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='40' 59 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='41' 60 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='42' 61 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='43' 62 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='44' 63 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='45' 64 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='46' 65 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='47' 66 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='48' 67 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='49' 68 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='50' 69 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='51' 70 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='52' 71 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='53' 72 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='54' 73 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='55' 74 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='56' 75 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='57' 76 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='58' 77 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='59' 78 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='60' 79 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='61' 80 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='62' 81 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='63' 82 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='64' 83 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='65' 84 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='66' 85 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='67' 86 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='68' 87 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='69' 88 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='70' 89 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='71' 90 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='72' 91 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='73' 92 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='74' 93 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='75' 94 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='76' 95 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='77' 96 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='78' 97 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='79' 98 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='80' 99 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='81' 100 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='82' 101 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='83' 102 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='84' 103 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='85' 104 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='86' 105 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='87' 106 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='88' 107 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='89' 108 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='90' 109 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='91' 110 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='92' 111 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='93' 112 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='94' 113 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='95' 114 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='96' 115 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='97' 116 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='98' 117 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='99' 118 10:10:31 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='100' 119 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='101' 120 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='102' 121 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='103' 122 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='104' 123 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='105' 124 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='106' 125 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='107' 126 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='108' 127 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='109' 128 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='110' 129 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='111' 130 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='112' 131 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='113' 132 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='114' 133 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='115' 134 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='116' 135 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='117' 136 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='118' 137 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='119' 138 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='120' 139 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='121' 140 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='122' 141 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='123' 142 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='124' 143 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='125' 144 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='126' 145 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='127' 146 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='128' 147 10:10:32 SQL Execute: ORACLE - select A.HSXMMC XMMC00 from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=588630 AND A.YJHSBH=trim(B.GHKSMC) AND B.GHKSBH='129'