1 10:34:36 SQL Prepare: ORACLE - SELECT FPXMMC, BMMC00, ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110326' AND '20110425'GROUP BY FPXMMC, BMMC00, ZWXM00 ORDER BY FPXMMC, BMMC00, ZWXM00 2 10:34:36 SQL Execute: ORACLE - SELECT FPXMMC, BMMC00, ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110326' AND '20110425'GROUP BY FPXMMC, BMMC00, ZWXM00 ORDER BY FPXMMC, BMMC00, ZWXM00 3 10:34:42 SQL Prepare: ORACLE - SELECT FPXMMC, BMMC00, ZXYSXM ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110326' AND '20110425'GROUP BY FPXMMC, BMMC00, ZXYSXM ORDER BY FPXMMC, BMMC00, ZXYSXM 4 10:34:42 SQL Execute: ORACLE - SELECT FPXMMC, BMMC00, ZXYSXM ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110326' AND '20110425'GROUP BY FPXMMC, BMMC00, ZXYSXM ORDER BY FPXMMC, BMMC00, ZXYSXM 5 10:34:48 SQL Prepare: ORACLE - SELECT FPXMMC, BMMC00, ZXYSXM ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110301' AND '20110425'GROUP BY FPXMMC, BMMC00, ZXYSXM ORDER BY FPXMMC, BMMC00, ZXYSXM 6 10:34:48 SQL Execute: ORACLE - SELECT FPXMMC, BMMC00, ZXYSXM ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110301' AND '20110425'GROUP BY FPXMMC, BMMC00, ZXYSXM ORDER BY FPXMMC, BMMC00, ZXYSXM 7 10:34:54 SQL Prepare: ORACLE - rollback 8 10:34:54 SQL Execute: ORACLE - rollback 9 10:34:54 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2537784 10 10:34:54 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2537784 11 10:34:54 SQL Prepare: ORACLE - Commit 12 10:34:54 SQL Execute: ORACLE - Commit 13 10:34:54 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 14 10:34:54 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 15 10:34:54 SQL Prepare: ORACLE - Commit 16 10:34:54 SQL Execute: ORACLE - Commit 17 10:36:15 Log started for: 门诊挂号收费管理系统 18 10:36:15 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 19 10:36:15 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 20 10:36:15 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20110425' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) 21 10:36:15 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20110425' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) 22 10:36:15 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 23 10:36:15 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 24 10:36:15 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 25 10:36:15 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 26 10:36:15 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='4'))) 27 10:36:15 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='4'))) 28 10:36:16 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 29 10:36:16 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 30 10:36:16 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 31 10:36:16 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 32 10:36:16 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 33 10:36:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 34 10:36:16 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 35 10:36:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 36 10:36:16 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 37 10:36:16 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 38 10:36:17 SQL Prepare: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 39 10:36:17 SQL Execute: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 40 10:36:17 SQL Prepare: ORACLE - Commit 41 10:36:17 SQL Execute: ORACLE - Commit 42 10:36:17 SQL Prepare: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT', 'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT', 'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT') and STATUS = 'ENABLED' 43 10:36:17 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT', 'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT', 'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT') and STATUS = 'ENABLED' 44 10:36:17 SQL Prepare: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 45 10:36:17 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 46 10:36:17 SQL Prepare: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 47 10:36:17 SQL Execute: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 48 10:36:17 SQL Prepare: ORACLE - select sysdate nowtime from dual 49 10:36:17 SQL Execute: ORACLE - select sysdate nowtime from dual 50 10:36:17 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 51 10:36:17 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 52 10:36:17 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFYGSSYLB','SF_MZFPSFDYYJJYE','SF_YBJSSAZTSBZ','SF_FYJSWSFTSWJSFY','MZSF_SFTSDYZSFP','SF_CJFY','SF_PRINTGHHFZDXZDY','SF_MZQDSFXSJMJE','SF_MZJSSFKYCZTYDW','SF_YHKLB','SF_GHXXSFTXJT','SF_FYJSSFXXZTSBZ','SF_GHLBBH','SF_GHXMBH','SF_PJQKSFDYFS','SF_SFSYFPXMZMYHJM','SF_FPGS00','SF_YYIDPDDLKS','SF_TSBZ_SFMRSCJZTSBZ','SF_TSBZ_SFZJSBTSBZFY','SF_FYDJSFXSGQGH','SF_YBFYDJSFZDBSDJF','SF_MZFPSFXSTSBZ','SF_MZRQDSFXSZHYE','SF_MZLSCFSFCSMFH','SF_LSCLSFXZ','SF_SFQYAKYYGH','SF_YJJDLEFTTOP','SF_TYJJDLEFTTOP','SF_DYBRXX_TOPLEFT','MZSF_YJJGHFB','SF_GHCKNLDYS','SF_GHCKSFTSZFCK','SF_SFKYQZTKCZ','SF_KP_SFQDZRXDTS','SF_BRGKSFXSMMK','SF_GRZFSFBHSB','SF_SFYJXGSJQY','SF_SFYXSFCDLYJXM','SF_PJWLYBNSY','SF_SFYXCKDQPJH','SF_YJXMYXTS','SF_CSBSYBFPSFFKCL','SF_RQDZFBLSFTXNJYY','SF_YBZGTJHSFYZMTJJK','MZSF_SFJSTXJKYCX','SF_MZFPSFXSQYXX','SF_SFHANHTSBZBR','SF_YBJKSFXDYNK','SF_FPBDJSRQSFXSQSRQ','SF_BJJESFBKKQFJE','SF_JSJZTKFPSFXSQZQYJJYE','SF_LSTDBRFB','SF_GHJFYCLXJBRZYXYXJZFFS','SF_YBGRZHZWYXQFJE') 53 10:36:17 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFYGSSYLB','SF_MZFPSFDYYJJYE','SF_YBJSSAZTSBZ','SF_FYJSWSFTSWJSFY','MZSF_SFTSDYZSFP','SF_CJFY','SF_PRINTGHHFZDXZDY','SF_MZQDSFXSJMJE','SF_MZJSSFKYCZTYDW','SF_YHKLB','SF_GHXXSFTXJT','SF_FYJSSFXXZTSBZ','SF_GHLBBH','SF_GHXMBH','SF_PJQKSFDYFS','SF_SFSYFPXMZMYHJM','SF_FPGS00','SF_YYIDPDDLKS','SF_TSBZ_SFMRSCJZTSBZ','SF_TSBZ_SFZJSBTSBZFY','SF_FYDJSFXSGQGH','SF_YBFYDJSFZDBSDJF','SF_MZFPSFXSTSBZ','SF_MZRQDSFXSZHYE','SF_MZLSCFSFCSMFH','SF_LSCLSFXZ','SF_SFQYAKYYGH','SF_YJJDLEFTTOP','SF_TYJJDLEFTTOP','SF_DYBRXX_TOPLEFT','MZSF_YJJGHFB','SF_GHCKNLDYS','SF_GHCKSFTSZFCK','SF_SFKYQZTKCZ','SF_KP_SFQDZRXDTS','SF_BRGKSFXSMMK','SF_GRZFSFBHSB','SF_SFYJXGSJQY','SF_SFYXSFCDLYJXM','SF_PJWLYBNSY','SF_SFYXCKDQPJH','SF_YJXMYXTS','SF_CSBSYBFPSFFKCL','SF_RQDZFBLSFTXNJYY','SF_YBZGTJHSFYZMTJJK','MZSF_SFJSTXJKYCX','SF_MZFPSFXSQYXX','SF_SFHANHTSBZBR','SF_YBJKSFXDYNK','SF_FPBDJSRQSFXSQSRQ','SF_BJJESFBKKQFJE','SF_JSJZTKFPSFXSQZQYJJYE','SF_LSTDBRFB','SF_GHJFYCLXJBRZYXYXJZFFS','SF_YBGRZHZWYXQFJE') 54 10:36:17 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','GHYXTS','YJ_XMYXTS','SF_PJHSC0','SF_DYYBFP','SF_MZBLH0','XT_JEQZ00','XT_YBJEQZ','SF_ZHTYJE','SF_ZHBJJE','SF_PJDKDY','YF_CFZJE_SRWS_YB','YF_CFZJE_CZFS_YB','YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFZJE_CZFS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','SF_SFYJS0_BZ0000','SF_GHD000_PRINT0','SF_PRINTSCALE','SF_TKPAR0_CZY000','SF_PARAMS_GHYXTS','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','SF_GHDLX0','SF_GHDSFTD','SF_JHFPSFTD','SF_SFSYJZK','SF_TJKSSJ','SF_TJJSSJ','SF_SFGLGZGHD','SF_YBGHFJF','SF_YBBRXB','SF_FPWidth','SF_FPHeigh','SF_NEWFPWidth','SF_NEWFPHeigh','SF_GHDWidth','SF_GHDHeigh','YF_ZYFJF_YPNM00','ZY_PJLYXYLYQR','SF_GHXGSFBRCZ','SF_JKDSFTD','SF_JKDJSFZDJS','SF_JKSFAJJBSJ','SF_NEWFPGS','SF_MZSFJJBSJ','SF_SYDJSBBGBF','SF_FYBXMSFSYYBBH','SF_GHCZSBBGBF','SF_MZJKDGS0','SF_YJJDGS0','SF_FYJSMR0','IC_YBYYJKLM','SF_COMMIT_READICK','SF_YBDJSLJE','SF_SFSYICK','SF_FPLXBZ0','XT_YBFSJK','XT_SGLRKH','XT_XYCYTCF','SF_XJGHSK','SF_BLHSFZDSC','SF_MZBLSYGS','XT_GZYJJYXTJK','SF_KHBLHXT','SF_SSWUTSCL','SF_SFCYSSWR','SF_HKSFTF0','SF_SFTKZDSP','SF_SFDYQD','SF_GHSSFSBLDGGH','SF_SFCFFP','SF_DYQBFP','SF_SFPDYB_CF0000','SF_ZY_SFZDXS','ZY_YJJPJ0','SF_SFSYYBYKT','SF_XJJSSFDYZHYE','SF_SFSYYGKJ','SF_KFSFKQ','SF_YBSFYXQF','ZY_YBFPBH','SF_CKBRSYGHD','IC_SFDM','SF_SFTSWF','SF_YBSFAGHDJS','SF_SFYDDYJ','SFYBZHYE','SF_MZYJJXZ','SF_SFDYTSJKD','SF_MZJSTSNY','SF_SFZDTJYJD','SF_TYJJDYYE','SF_SFDYZLD','SF_SFSYJZSX','SF_EJBBSFCF','SF_EJBBCFLS','SF_EJBBCFHS','SF_FPLEFT','SF_FPTOP','SF_TKAZFFS','SF_JSATSBZ','SF_MZJKCZKZ','XT_JKTQSJ','SF_YJJGHZXJ','SF_SFCKJDDW','SF_DKZDDW','SF_ZY_FFJJ','SF_LSCFHJBRYF','SF_LSCFSFNFSRBRXM','SF_SFXMCGSXSFCF','SF_BRJKSFYXXDZ','SF_FYYFNFAZEYF','SF_YBFYDJSFLJJS','SF_YJJDSFDYPJH','SF_FYDJYSSFWK','SF_MZFPSFDYYBGRZHYE','SF_DEFAULT_HKSQKF','SF_YBBRJSSFTSDTJSFY','SF_YJJFXJZFZDXE','SF_YSXDHGHKSSFYXXG','SF_GHSYSXMSFYXWK','SF_BRNLSFXSDY','SF_SFYXXGBRBLH','SF_JZBRDTFPXZZS','SF_GHAXJYSXZLB','SF_SFQYCZPJKPJK','SF_KP_MZFPDYPLBH','SF_KP_FPZRDYMS','SF_KP_LJDLKPXTFS','XT_BRBYKFB','MZSF_FYBXJJZYXQC','SF_NNGHDTL','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','SF_YBJSSFYXQZHTK','SF_YBBNCZSSFZXJJZ','SF_SFYXTZZJE','SF_PRINTBLSYZDY','SF_PTBRSFAGHHJS','SF_YJJGHFYDJQDQYBZH','SF_GHFTC','SF_YJJTKQKYSPZSZ','SF_NLXDYSBSFXTLXR','SF_CKBRABLHJS','SF_FPDYGHRQ','SF_FYDJSSFBSYFYGH','SF_YJJDSFTD','SF_YJJTKDSFTD','SF_GYBRDTGHXDCS','SF_CGXESFYXQR','SF_LRSFXMSFABHPX','TJ_GRTJYXTS','SF_FZFPSFDYFYQZRQ','SF_PRINTYJJPJZDY','SF_PRINTYJJPJTKZDY','SF_FZFPDYPJXHLX','SF_HKSFKXZSQKF','XT_TJGHLB','SF_KP_CXZRSFZFYFP','SF_PRINTTJDWPJZDY','YS_SFYXPTBRTQGH','SF_MZFPSFXSFYBF','SF_XMFPSFXSYJJZE','SF_QSJDYJJZELB','SF_XMFPQDSFXSZLXM','MZ_FPGS00','SF_SFXMYBJK','IC_SFDM','SF_KP_ICKFSFDDLC','SF_SFCGHYSTHSQBZ','SF_XMYBFYDJSFKXZHLX','SF_GYZHPDBZ','SF_FPDYXS','SF_YJJPJ0','SF_XMYBZLFID','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM') 55 10:36:17 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','GHYXTS','YJ_XMYXTS','SF_PJHSC0','SF_DYYBFP','SF_MZBLH0','XT_JEQZ00','XT_YBJEQZ','SF_ZHTYJE','SF_ZHBJJE','SF_PJDKDY','YF_CFZJE_SRWS_YB','YF_CFZJE_CZFS_YB','YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFZJE_CZFS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','SF_SFYJS0_BZ0000','SF_GHD000_PRINT0','SF_PRINTSCALE','SF_TKPAR0_CZY000','SF_PARAMS_GHYXTS','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','SF_GHDLX0','SF_GHDSFTD','SF_JHFPSFTD','SF_SFSYJZK','SF_TJKSSJ','SF_TJJSSJ','SF_SFGLGZGHD','SF_YBGHFJF','SF_YBBRXB','SF_FPWidth','SF_FPHeigh','SF_NEWFPWidth','SF_NEWFPHeigh','SF_GHDWidth','SF_GHDHeigh','YF_ZYFJF_YPNM00','ZY_PJLYXYLYQR','SF_GHXGSFBRCZ','SF_JKDSFTD','SF_JKDJSFZDJS','SF_JKSFAJJBSJ','SF_NEWFPGS','SF_MZSFJJBSJ','SF_SYDJSBBGBF','SF_FYBXMSFSYYBBH','SF_GHCZSBBGBF','SF_MZJKDGS0','SF_YJJDGS0','SF_FYJSMR0','IC_YBYYJKLM','SF_COMMIT_READICK','SF_YBDJSLJE','SF_SFSYICK','SF_FPLXBZ0','XT_YBFSJK','XT_SGLRKH','XT_XYCYTCF','SF_XJGHSK','SF_BLHSFZDSC','SF_MZBLSYGS','XT_GZYJJYXTJK','SF_KHBLHXT','SF_SSWUTSCL','SF_SFCYSSWR','SF_HKSFTF0','SF_SFTKZDSP','SF_SFDYQD','SF_GHSSFSBLDGGH','SF_SFCFFP','SF_DYQBFP','SF_SFPDYB_CF0000','SF_ZY_SFZDXS','ZY_YJJPJ0','SF_SFSYYBYKT','SF_XJJSSFDYZHYE','SF_SFSYYGKJ','SF_KFSFKQ','SF_YBSFYXQF','ZY_YBFPBH','SF_CKBRSYGHD','IC_SFDM','SF_SFTSWF','SF_YBSFAGHDJS','SF_SFYDDYJ','SFYBZHYE','SF_MZYJJXZ','SF_SFDYTSJKD','SF_MZJSTSNY','SF_SFZDTJYJD','SF_TYJJDYYE','SF_SFDYZLD','SF_SFSYJZSX','SF_EJBBSFCF','SF_EJBBCFLS','SF_EJBBCFHS','SF_FPLEFT','SF_FPTOP','SF_TKAZFFS','SF_JSATSBZ','SF_MZJKCZKZ','XT_JKTQSJ','SF_YJJGHZXJ','SF_SFCKJDDW','SF_DKZDDW','SF_ZY_FFJJ','SF_LSCFHJBRYF','SF_LSCFSFNFSRBRXM','SF_SFXMCGSXSFCF','SF_BRJKSFYXXDZ','SF_FYYFNFAZEYF','SF_YBFYDJSFLJJS','SF_YJJDSFDYPJH','SF_FYDJYSSFWK','SF_MZFPSFDYYBGRZHYE','SF_DEFAULT_HKSQKF','SF_YBBRJSSFTSDTJSFY','SF_YJJFXJZFZDXE','SF_YSXDHGHKSSFYXXG','SF_GHSYSXMSFYXWK','SF_BRNLSFXSDY','SF_SFYXXGBRBLH','SF_JZBRDTFPXZZS','SF_GHAXJYSXZLB','SF_SFQYCZPJKPJK','SF_KP_MZFPDYPLBH','SF_KP_FPZRDYMS','SF_KP_LJDLKPXTFS','XT_BRBYKFB','MZSF_FYBXJJZYXQC','SF_NNGHDTL','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','SF_YBJSSFYXQZHTK','SF_YBBNCZSSFZXJJZ','SF_SFYXTZZJE','SF_PRINTBLSYZDY','SF_PTBRSFAGHHJS','SF_YJJGHFYDJQDQYBZH','SF_GHFTC','SF_YJJTKQKYSPZSZ','SF_NLXDYSBSFXTLXR','SF_CKBRABLHJS','SF_FPDYGHRQ','SF_FYDJSSFBSYFYGH','SF_YJJDSFTD','SF_YJJTKDSFTD','SF_GYBRDTGHXDCS','SF_CGXESFYXQR','SF_LRSFXMSFABHPX','TJ_GRTJYXTS','SF_FZFPSFDYFYQZRQ','SF_PRINTYJJPJZDY','SF_PRINTYJJPJTKZDY','SF_FZFPDYPJXHLX','SF_HKSFKXZSQKF','XT_TJGHLB','SF_KP_CXZRSFZFYFP','SF_PRINTTJDWPJZDY','YS_SFYXPTBRTQGH','SF_MZFPSFXSFYBF','SF_XMFPSFXSYJJZE','SF_QSJDYJJZELB','SF_XMFPQDSFXSZLXM','MZ_FPGS00','SF_SFXMYBJK','IC_SFDM','SF_KP_ICKFSFDDLC','SF_SFCGHYSTHSQBZ','SF_XMYBFYDJSFKXZHLX','SF_GYZHPDBZ','SF_FPDYXS','SF_YJJPJ0','SF_XMYBZLFID','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM') 56 10:36:17 SQL Prepare: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 57 10:36:17 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 58 10:36:17 SQL Prepare: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 59 10:36:17 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 60 10:36:17 SQL Prepare: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 61 10:36:17 SQL Execute: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 62 10:36:17 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('SF_YCZYBKDYBFZX','SF_SFQYPYYBJK','SF_PYYBSFSFJYYBDY','SF_XEXMHZMXBZDY','SF_GFBRXJJSSFKXFB','SF_GFBRXJJSSFKXGZFBL','SF_GFBRSFKAZFGH','SF_HFLJCYBJSDZDY','SF_FYQDBZXXNR','SF_GHSFZNCLBYYS','SF_MZPBGLSFZNCLBYYS','SF_MZHBGLSFZNCLBYYS','SF_SRYSSFXSBYYS','SF_FYDJXZCFD','SF_XZXGTBLBCS','SF_SFXYBFSJMJE','YJ_XMZJYSWSSKS','SF_FPJHJZYHKPTSFXS','SF_JMYBYFCS','SF_JMYBSCJG','SF_JMYBSCJEXZ','SF_JMYBMNJEXZ','SF_JMYBMYYSCCSXZ','SF_JMYBCXESFSF','SF_JMYBNFCS','SF_MZBRJKYJJW0','SF_FPSFXSDYRQ','SF_SFYJSGNZDQY','SF_MZBRZHWHTKMM','SF_BRZFFSXS','SF_MZRSRBBSFXSJZKYJ','SF_SFDYGEDZBB','SF_SFQYGTYBJK','SF_GTYBSFSFJYYBDY','SF_GTYBBRTKSFDYJK','SF_MZJSSFXSBFSYB','SF_BRCFQDSFXSTXM','SF_YJKTKZYXTSTK','SF_YJJCLCESFAZFJS','SF_ZCNHBRFYSFCSGYB','SF_SFQYPYJMYBJK','SF_PYJMYBSFSFJYYBDY','SF_TYDWBRSFJYJJJK','TJ_ZEJMXMID','SF_TJFYDZHSFKYTK','SF_TJPJDYSFTSXS','SF_ICKSFCYJS','SF_LEDDISPJK','SF_ZFJSSFYXQZHTK','SF_MZFPPDSFXYBR','SF_YBTKSFSYYGH','SF_HKSFSH','SF_YJJTKJESFXSFS','SF_JKRQSFGBCXGJKRQ','SF_ZFBRXB','SF_BBTJSFJQZDS','SF_ZZSRSFNYXJTC','SF_JKDYFWSFYZTYZDZ','SF_JYJJSFTSJFCG','SF_MZBKMZFSFSQKF','SF_MZRQDSFXSJFJE','SF_MZQZTKMRWZ','SF_MZQDSFXSZFJE','SF_PJJHPJSFYZSFPQF','SF_PYMTJSDZDY','SF_JKDJNLSFBT','SF_SFCLYBJKDFS','SF_SFSYSFXMZMYHJM','SF_SFCLYBJKDFS_BC','SF_JKDSFSYFR3XS','SF_SFXMJKYL','SF_MZBRQXJSSFYDK','SF_SFYJKRBBASFYHZ','SF_BRGHDJDKYJJ','SF_YBJSRBBZJYS','SF_YJJ_ZYJTDZWKSFTS','SF_FPSFDYGWYJE','SF_YBBRTSBZSFXSYJXM','ZY_XNHCSLX','SF_TSBRFYDJXMWH','ZY_XNHFZXMC','SF_YJJPZXS','SF_SFQYXFP_GZ','SF_TSBRFYDJ','SF_MZYSGZLTJ_KS','SF_MZYSGZLTJ_YS','SF_SFQYDZQB','SF_DZQBTKFS','SF_XNHBRBXSYBZHJE','SF_DZQBJKXSYE','SF_YJJFPSFSYXGS','SF_MZFYGZTFCL','SF_ZGFBJLKKHXZ','SF_YJJYEQKBSTFK','SF_FYJSQZGNSFQY','YJ_XMAPSFAKSCX','YJ_XMYXTS','XT_ZYXTGBDW','YJ_XMAPDYZDYID','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YXCXTS','YJ_YJCXD_ZDY','YS_SFTHHCCX','SF_YJCXDYMBID','SF_MZQDXJSFXSZDYH','SF_MZYJJJKSYBLH','SF_ZZJESFYXJTK','ZY_QDDYSFGJNRCDZDHH','SF_ZHWHQX') 63 10:36:17 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('SF_YCZYBKDYBFZX','SF_SFQYPYYBJK','SF_PYYBSFSFJYYBDY','SF_XEXMHZMXBZDY','SF_GFBRXJJSSFKXFB','SF_GFBRXJJSSFKXGZFBL','SF_GFBRSFKAZFGH','SF_HFLJCYBJSDZDY','SF_FYQDBZXXNR','SF_GHSFZNCLBYYS','SF_MZPBGLSFZNCLBYYS','SF_MZHBGLSFZNCLBYYS','SF_SRYSSFXSBYYS','SF_FYDJXZCFD','SF_XZXGTBLBCS','SF_SFXYBFSJMJE','YJ_XMZJYSWSSKS','SF_FPJHJZYHKPTSFXS','SF_JMYBYFCS','SF_JMYBSCJG','SF_JMYBSCJEXZ','SF_JMYBMNJEXZ','SF_JMYBMYYSCCSXZ','SF_JMYBCXESFSF','SF_JMYBNFCS','SF_MZBRJKYJJW0','SF_FPSFXSDYRQ','SF_SFYJSGNZDQY','SF_MZBRZHWHTKMM','SF_BRZFFSXS','SF_MZRSRBBSFXSJZKYJ','SF_SFDYGEDZBB','SF_SFQYGTYBJK','SF_GTYBSFSFJYYBDY','SF_GTYBBRTKSFDYJK','SF_MZJSSFXSBFSYB','SF_BRCFQDSFXSTXM','SF_YJKTKZYXTSTK','SF_YJJCLCESFAZFJS','SF_ZCNHBRFYSFCSGYB','SF_SFQYPYJMYBJK','SF_PYJMYBSFSFJYYBDY','SF_TYDWBRSFJYJJJK','TJ_ZEJMXMID','SF_TJFYDZHSFKYTK','SF_TJPJDYSFTSXS','SF_ICKSFCYJS','SF_LEDDISPJK','SF_ZFJSSFYXQZHTK','SF_MZFPPDSFXYBR','SF_YBTKSFSYYGH','SF_HKSFSH','SF_YJJTKJESFXSFS','SF_JKRQSFGBCXGJKRQ','SF_ZFBRXB','SF_BBTJSFJQZDS','SF_ZZSRSFNYXJTC','SF_JKDYFWSFYZTYZDZ','SF_JYJJSFTSJFCG','SF_MZBKMZFSFSQKF','SF_MZRQDSFXSJFJE','SF_MZQZTKMRWZ','SF_MZQDSFXSZFJE','SF_PJJHPJSFYZSFPQF','SF_PYMTJSDZDY','SF_JKDJNLSFBT','SF_SFCLYBJKDFS','SF_SFSYSFXMZMYHJM','SF_SFCLYBJKDFS_BC','SF_JKDSFSYFR3XS','SF_SFXMJKYL','SF_MZBRQXJSSFYDK','SF_SFYJKRBBASFYHZ','SF_BRGHDJDKYJJ','SF_YBJSRBBZJYS','SF_YJJ_ZYJTDZWKSFTS','SF_FPSFDYGWYJE','SF_YBBRTSBZSFXSYJXM','ZY_XNHCSLX','SF_TSBRFYDJXMWH','ZY_XNHFZXMC','SF_YJJPZXS','SF_SFQYXFP_GZ','SF_TSBRFYDJ','SF_MZYSGZLTJ_KS','SF_MZYSGZLTJ_YS','SF_SFQYDZQB','SF_DZQBTKFS','SF_XNHBRBXSYBZHJE','SF_DZQBJKXSYE','SF_YJJFPSFSYXGS','SF_MZFYGZTFCL','SF_ZGFBJLKKHXZ','SF_YJJYEQKBSTFK','SF_FYJSQZGNSFQY','YJ_XMAPSFAKSCX','YJ_XMYXTS','XT_ZYXTGBDW','YJ_XMAPDYZDYID','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YXCXTS','YJ_YJCXD_ZDY','YS_SFTHHCCX','SF_YJCXDYMBID','SF_MZQDXJSFXSZDYH','SF_MZYJJJKSYBLH','SF_ZZJESFYXJTK','ZY_QDDYSFGJNRCDZDHH','SF_ZHWHQX') 64 10:36:17 SQL Prepare: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 65 10:36:17 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 66 10:36:17 SQL Prepare: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK' 67 10:36:17 SQL Execute: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK' 68 10:36:21 SQL Prepare: ORACLE - select * from ic_ybbrlb 69 10:36:21 SQL Execute: ORACLE - select * from ic_ybbrlb 70 10:36:21 SQL Prepare: ORACLE - select MZSJID,MZSJ00 from BM_MZSJB0 where SFYX00='Y' 71 10:36:21 SQL Execute: ORACLE - select MZSJID,MZSJ00 from BM_MZSJB0 where SFYX00='Y' 72 10:36:21 SQL Prepare: ORACLE - select * from XT_YYXX00 where 1=1 73 10:36:21 SQL Execute: ORACLE - select * from XT_YYXX00 where 1=1 74 10:36:25 SQL Prepare: ORACLE - select SQ_BM_YYSFTJ_ID0000.nextval DJH000 from dual 75 10:36:25 SQL Execute: ORACLE - select SQ_BM_YYSFTJ_ID0000.nextval DJH000 from dual 76 10:36:25 SQL Prepare: ORACLE - Insert into BM_YYSFTJ(ID0000,BMBH00,SFXM02,SFXM99,SFXM03) select 695690,kdzxys,xmbh00,kdzxks,sum(hjje00) from (select brid00,kdys00 kdzxys,xmbh00,kdks00 kdzxks,sum(a.hjje00) hjje00 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and ( ( A.CZRQ00>='20110401' and A.CZRQ00<='20110425' and A.CZRQ00||A.CZSJ00 >='2011040100:00:00' and A.CZRQ00||A.CZSJ00 <= '2011042523: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 77 10:36:25 SQL Execute: ORACLE - Insert into BM_YYSFTJ(ID0000,BMBH00,SFXM02,SFXM99,SFXM03) select 695690,kdzxys,xmbh00,kdzxks,sum(hjje00) from (select brid00,kdys00 kdzxys,xmbh00,kdks00 kdzxks,sum(a.hjje00) hjje00 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and ( ( A.CZRQ00>='20110401' and A.CZRQ00<='20110425' and A.CZRQ00||A.CZSJ00 >='2011040100:00:00' and A.CZRQ00||A.CZSJ00 <= '2011042523: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 78 10:36:42 SQL Prepare: 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; 79 10:36:42 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; 80 10:36:54 SQL Prepare: ORACLE - update BM_YYSFTJ A set SFXM79=(SELECT sum(GHCS00) from VW_SF_GHLSXX B,BM_BRXXB0 C where B.BRID00=C.BRID00 and B.JZYS00=A.BMBH00 AND B.ghks00=a.sfxm99 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.CZRQ00>='20110401' and B.CZRQ00<= '20110425' ) and ( B.CZRQ00||B.CZSJ00 >='2011040100:00:00' and B.CZRQ00||B.CZSJ00 <= '2011042523:59:59' ) ) where A.ID0000 =695691 81 10:36:54 SQL Execute: ORACLE - update BM_YYSFTJ A set SFXM79=(SELECT sum(GHCS00) from VW_SF_GHLSXX B,BM_BRXXB0 C where B.BRID00=C.BRID00 and B.JZYS00=A.BMBH00 AND B.ghks00=a.sfxm99 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.CZRQ00>='20110401' and B.CZRQ00<= '20110425' ) and ( B.CZRQ00||B.CZSJ00 >='2011040100:00:00' and B.CZRQ00||B.CZSJ00 <= '2011042523:59:59' ) ) where A.ID0000 =695691 82 10:37:19 SQL Prepare: ORACLE - update BM_YYSFTJ A set SFXM79=(SELECT sum(GHCS00) from VW_SF_GHLSXX B,BM_BRXXB0 C where B.BRID00=C.BRID00 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.CZRQ00>='20110401' and B.CZRQ00<= '20110425' ) and ( B.CZRQ00||B.CZSJ00 >='2011040100:00:00' and B.CZRQ00||B.CZSJ00 <= '2011042523:59:59' ) ) where A.BMBH00=9999999999 AND A.ID0000 =695691 83 10:37:19 SQL Execute: ORACLE - update BM_YYSFTJ A set SFXM79=(SELECT sum(GHCS00) from VW_SF_GHLSXX B,BM_BRXXB0 C where B.BRID00=C.BRID00 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.CZRQ00>='20110401' and B.CZRQ00<= '20110425' ) and ( B.CZRQ00||B.CZSJ00 >='2011040100:00:00' and B.CZRQ00||B.CZSJ00 <= '2011042523:59:59' ) ) where A.BMBH00=9999999999 AND A.ID0000 =695691 84 10:37:21 SQL Prepare: 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.SFXM79)SFXM79,decode(sum(SFXM79),0,0,sum(A.XMHJ00)/sum(A.SFXM79)) SFXM81, sum(A.YPHJ00)YPHJ00,(sum(A.YPHJ00)/nvl(DECODE(sum(A.XMHJ00),0,1,sum(A.XMHJ00)),1)) 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 from BM_YYSFTJ A,BM_YGBM00 B,BM_BMBM00 C where A.BMBH00 = B.YGBH00(+) and B.BMBH00=C.BMBH00(+) and A.ID0000 =:1 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 85 10:37:21 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.SFXM79)SFXM79,decode(sum(SFXM79),0,0,sum(A.XMHJ00)/sum(A.SFXM79)) SFXM81, sum(A.YPHJ00)YPHJ00,(sum(A.YPHJ00)/nvl(DECODE(sum(A.XMHJ00),0,1,sum(A.XMHJ00)),1)) 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 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 86 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='01' 87 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='01' 88 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='02' 89 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='02' 90 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='03' 91 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='03' 92 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='04' 93 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='04' 94 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='05' 95 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='05' 96 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='06' 97 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='06' 98 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='07' 99 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='07' 100 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='08' 101 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='08' 102 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='09' 103 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='09' 104 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='10' 105 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='10' 106 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='11' 107 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='11' 108 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='12' 109 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='12' 110 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='13' 111 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='13' 112 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='14' 113 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='14' 114 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='15' 115 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='15' 116 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='16' 117 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='16' 118 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='17' 119 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='17' 120 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='18' 121 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='18' 122 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='19' 123 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='19' 124 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='20' 125 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='20' 126 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='21' 127 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='21' 128 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='22' 129 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='22' 130 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='23' 131 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='23' 132 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='24' 133 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='24' 134 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='25' 135 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='25' 136 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='26' 137 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='26' 138 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='27' 139 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='27' 140 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='28' 141 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='28' 142 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='29' 143 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='29' 144 10:37:21 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='30' 145 10:37:21 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='30' 146 10:38:17 Log started for: 住院收费管理系统 147 10:38:17 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.156','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110425','10:38:14','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 148 10:38:17 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.156','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110425','10:38:14','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 149 10:38:17 SQL Prepare: ORACLE - Commit 150 10:38:17 SQL Execute: ORACLE - Commit 151 10:38:18 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 152 10:38:18 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 153 10:38:18 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 154 10:38:18 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 155 10:38:18 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 156 10:38:18 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 157 10:38:18 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.156','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110425','10:38:14','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 158 10:38:18 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.156','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110425','10:38:14','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 159 10:38:18 SQL Prepare: ORACLE - Commit 160 10:38:18 SQL Execute: ORACLE - Commit 161 10:38:18 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5' 162 10:38:18 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5' 163 10:38:18 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 164 10:38:18 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 165 10:38:18 SQL Prepare: ORACLE - Select SYSDATE from Dual 166 10:38:18 SQL Execute: ORACLE - Select SYSDATE from Dual 167 10:38:18 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 168 10:38:18 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 169 10:38:18 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 170 10:38:18 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 171 10:38:18 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 172 10:38:18 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 173 10:38:18 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 174 10:38:18 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 175 10:38:18 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 176 10:38:18 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 177 10:38:18 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('4') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 178 10:38:18 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('4') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 179 10:38:18 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '5' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 180 10:38:18 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '5' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 181 10:38:18 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 182 10:38:18 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 183 10:38:18 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 184 10:38:18 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 185 10:38:18 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 186 10:38:18 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 187 10:38:18 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 188 10:38:18 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 189 10:38:18 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 190 10:38:18 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 191 10:38:18 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 192 10:38:18 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 193 10:38:18 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2537835,476,'wlzx-1','5',nvl('3809694',' '),'192.168.14.156#589:4588@PrjZY_ZYSF.exe+住院收费管理系统',43) 194 10:38:18 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2537835,476,'wlzx-1','5',nvl('3809694',' '),'192.168.14.156#589:4588@PrjZY_ZYSF.exe+住院收费管理系统',43) 195 10:38:18 SQL Prepare: ORACLE - Commit 196 10:38:18 SQL Execute: ORACLE - Commit 197 10:38:18 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 198 10:38:18 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 199 10:38:18 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 200 10:38:18 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 201 10:38:18 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 202 10:38:18 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 203 10:38:18 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.156' 204 10:38:18 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.156' 205 10:38:18 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 206 10:38:18 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 207 10:38:18 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 208 10:38:18 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 209 10:38:18 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 210 10:38:18 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 211 10:38:18 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 212 10:38:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 213 10:38:19 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 214 10:38:19 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 215 10:38:19 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20110425' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',43,' )>0 ) 216 10:38:19 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20110425' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',43,' )>0 ) 217 10:38:19 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 218 10:38:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 219 10:38:19 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 220 10:38:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 221 10:38:20 SQL Prepare: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 222 10:38:20 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 223 10:38:20 SQL Prepare: ORACLE - select sysdate nowtime from dual 224 10:38:20 SQL Execute: ORACLE - select sysdate nowtime from dual 225 10:38:20 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 226 10:38:20 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 227 10:38:20 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_PJHSC0','ZY_MRNZYH','ZY_DYYBFP','XT_JEQZ00','SF_ZHTYJE','SF_ZHBJJE','ZY_YBJSTKD','ZY_SFYJS0_BZ0000','ZY_WJZBNCY','ZY_PRINTSCALE','ZY_XTDBQX','ZY_XTQFQX','ZY_QXCYQX','ZY_TKPAR0_CZY000','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_YTFSFYXCY','SF_SFSYJZK','ZY_TJKSSJ','ZY_TJJSSJ','SF_YBBRXB','ZY_FPWidth','ZY_FPHeigh','ZY_ZYSFJJBSJ','ZY_SYDJKYDBQF','ZY_PJLYXYLYQR','XT_QDXXZHYE','XT_QDXXZHYE_LX','ZY_JKDSFTD','ZY_JKSFAJJBSJ','ZY_ZYJKDGS0','ZY_YJJDJGS','ZY_YBRQDFS','IC_YBYYJKLM','ZY_RYDJSFFZ','ZY_YBBRZFXMFS','SF_ZY_SFZDXS','SF_SFCFFP','ZY_FPTOP','ZY_SFFSXM','ZY_YBFPBH','ZY_SFQZGSYB','ZY_RQDGSCS','YF_ZYFJF_YPNM00','YF_CFMXJE_CZFS','XT_XYCYTCF','ZY_JMXMFS','ZY_EJBBSFCF','ZY_EJBBCFLS','ZY_EJBBCFHS','ZY_CYBRQFMXBB_SFCF','ZY_CYBRQFMXBBLS','ZY_CYBRQFMXBBHS','YF_CFMXJE_SRWS','YF_CFZJE_CZFS','ZY_RQDFPXMSFDY','SF_GFBRJKBXSRDW','YF_CFZJE_SRWS_YB','YF_CFZJE_SRWS','XT_ZYXTSFSYZLK',+'YF_CFZJE_CZFS_YB','ZY_RQDMX0_ZFHB','ZY_ZYDJBLHPB','ZY_ZYHSFZDSC','XT_JKTQSJ','ZY_CXJSSFDYDJ','ZY_YBRYSFSYDT','ZY_DYQBFP','ZY_FPLEFT','ZY_SFDYZLD','XT_TFXYSHBZ','ZY_RYDJTCTS','ZY_YJJGS0_SFDYYE','YF_AutoMatch','ZY_SFHHXMMX','ZY_SFDYTKTZS','ZY_JSTKAYJJFS','ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','ZY_SFDYBASY','ZY_SFDYJZD','ZY_FBZHXTYZ','ZY_SFMHEYJKD','ZY_NPYBCYJSXSYBZHZF','ZYSF_TDXMTDKS_YXQF','ZY_CRYTJSFAKS','ZY_PJWLYBNSY','ZY_PRINTBASYZDY','ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS','ZY_ZYFPSFXSFYBF','ZY_QDDYGJBMXSFS','ZY_JSBBSFXSJCJE','ZY_YYBRSFYWFY','BQ_YBCYSFBXLRCYZD','ZY_YBCYJSHZDCSBASY','ZY_JZSRKSSRSFCF','ZY_JZSRKSSRSFZDZTJKD','ZY_YBJKSFJHZHDK','ZY_YBCXJZRQ','ZY_YBFSKSMCZDHZS','ZYSF_RYDJMS','ZYSF_RYDJMRBQ','ZYSF_RYDJMRKS','ZY_WSZBRSFKYXGRYXX') 228 10:38:20 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_PJHSC0','ZY_MRNZYH','ZY_DYYBFP','XT_JEQZ00','SF_ZHTYJE','SF_ZHBJJE','ZY_YBJSTKD','ZY_SFYJS0_BZ0000','ZY_WJZBNCY','ZY_PRINTSCALE','ZY_XTDBQX','ZY_XTQFQX','ZY_QXCYQX','ZY_TKPAR0_CZY000','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_YTFSFYXCY','SF_SFSYJZK','ZY_TJKSSJ','ZY_TJJSSJ','SF_YBBRXB','ZY_FPWidth','ZY_FPHeigh','ZY_ZYSFJJBSJ','ZY_SYDJKYDBQF','ZY_PJLYXYLYQR','XT_QDXXZHYE','XT_QDXXZHYE_LX','ZY_JKDSFTD','ZY_JKSFAJJBSJ','ZY_ZYJKDGS0','ZY_YJJDJGS','ZY_YBRQDFS','IC_YBYYJKLM','ZY_RYDJSFFZ','ZY_YBBRZFXMFS','SF_ZY_SFZDXS','SF_SFCFFP','ZY_FPTOP','ZY_SFFSXM','ZY_YBFPBH','ZY_SFQZGSYB','ZY_RQDGSCS','YF_ZYFJF_YPNM00','YF_CFMXJE_CZFS','XT_XYCYTCF','ZY_JMXMFS','ZY_EJBBSFCF','ZY_EJBBCFLS','ZY_EJBBCFHS','ZY_CYBRQFMXBB_SFCF','ZY_CYBRQFMXBBLS','ZY_CYBRQFMXBBHS','YF_CFMXJE_SRWS','YF_CFZJE_CZFS','ZY_RQDFPXMSFDY','SF_GFBRJKBXSRDW','YF_CFZJE_SRWS_YB','YF_CFZJE_SRWS','XT_ZYXTSFSYZLK',+'YF_CFZJE_CZFS_YB','ZY_RQDMX0_ZFHB','ZY_ZYDJBLHPB','ZY_ZYHSFZDSC','XT_JKTQSJ','ZY_CXJSSFDYDJ','ZY_YBRYSFSYDT','ZY_DYQBFP','ZY_FPLEFT','ZY_SFDYZLD','XT_TFXYSHBZ','ZY_RYDJTCTS','ZY_YJJGS0_SFDYYE','YF_AutoMatch','ZY_SFHHXMMX','ZY_SFDYTKTZS','ZY_JSTKAYJJFS','ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','ZY_SFDYBASY','ZY_SFDYJZD','ZY_FBZHXTYZ','ZY_SFMHEYJKD','ZY_NPYBCYJSXSYBZHZF','ZYSF_TDXMTDKS_YXQF','ZY_CRYTJSFAKS','ZY_PJWLYBNSY','ZY_PRINTBASYZDY','ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS','ZY_ZYFPSFXSFYBF','ZY_QDDYGJBMXSFS','ZY_JSBBSFXSJCJE','ZY_YYBRSFYWFY','BQ_YBCYSFBXLRCYZD','ZY_YBCYJSHZDCSBASY','ZY_JZSRKSSRSFCF','ZY_JZSRKSSRSFZDZTJKD','ZY_YBJKSFJHZHDK','ZY_YBCXJZRQ','ZY_YBFSKSMCZDHZS','ZYSF_RYDJMS','ZYSF_RYDJMRBQ','ZYSF_RYDJMRKS','ZY_WSZBRSFKYXGRYXX') 229 10:38:20 SQL Prepare: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 230 10:38:20 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 231 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_SFYDDYJ' 232 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_SFYDDYJ' 233 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 234 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 235 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY' 236 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY' 237 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS' 238 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS' 239 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY' 240 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY' 241 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY' 242 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY' 243 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD' 244 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD' 245 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS' 246 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS' 247 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS' 248 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS' 249 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW' 250 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW' 251 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM' 252 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM' 253 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY' 254 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY' 255 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY' 256 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY' 257 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY' 258 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY' 259 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD' 260 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD' 261 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD' 262 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD' 263 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH' 264 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH' 265 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL' 266 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL' 267 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE' 268 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE' 269 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD' 270 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD' 271 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE' 272 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE' 273 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL' 274 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL' 275 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX' 276 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX' 277 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB' 278 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB' 279 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 280 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 281 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 282 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 283 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 284 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 285 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP' 286 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP' 287 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP' 288 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP' 289 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD' 290 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD' 291 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR' 292 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR' 293 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM' 294 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM' 295 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS' 296 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS' 297 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 298 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 299 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 300 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 301 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY' 302 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY' 303 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ' 304 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ' 305 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE' 306 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE' 307 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00' 308 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00' 309 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ' 310 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ' 311 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY' 312 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY' 313 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ' 314 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ' 315 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM' 316 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM' 317 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM' 318 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM' 319 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY' 320 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY' 321 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL' 322 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL' 323 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ' 324 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ' 325 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ' 326 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ' 327 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK' 328 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK' 329 10:38:20 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 330 10:38:20 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 331 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB' 332 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB' 333 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH' 334 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH' 335 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR' 336 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR' 337 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY' 338 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY' 339 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR' 340 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR' 341 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF' 342 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF' 343 10:38:20 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE' 344 10:38:20 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE' 345 10:38:20 SQL Prepare: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 346 10:38:20 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 347 10:38:20 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('ZY_CSBSYBFPSFFKCL','ZY_PRINTYYFYMXZZDY','ZY_WCKSFYXCYJS','ZY_SFQYBASYCSJK','ZY_SFYJKTJ_SFCF','ZY_SFYJKTJLS','ZY_SFYJKTJHS','ZY_YXLFYZFBRCYJS','ZY_QDHZSHTSDY','ZY_ZYYSJZSRXSCYRS','ZY_NHBRSFCSJBZD','ZY_JKJHSFXSJKDH','ZY_ZYBRSFKYZHBRID','ZY_BASYNHBRSFCSICKH','ZY_FPRQDYSFXSDYRQ','ZY_XNHBRSFCSICKH','ZY_YJJYHKTCSFYXJTC','ZY_RYDJZDCSDBJE','ZY_YJJSKSFXSYLMXZ','ZY_SZCYBRSFKYRY','ZY_BRLDTJ_BQ_KS','ZY_YJJYEMXBTITLE','ZY_JKRQXSSFALNYYFS','ZY_NHBRSFFSCYDJRQ','ZY_NBBRXB','ZY_QDDYSFMRQTDYJ','ZY_YBJSRBBSFXSCZYB','ZY_ZFZYBXMTSSB','ZY_JKRQSFGBCXGJKRQ','ZY_ZFBRXB','ZY_BASY_LEFTPAGE','ZY_BASY_TOPPAGE','ZY_PJJHYJJSFXSCXLL','SF_MZFPPDSFXYBR','ZY_CYJSTKAYJJ','ZY_JKDYFWSFYZTYZDZ','ZY_FZFZYBSFXZ','ZY_FPTHBJXX','ZY_NHBRSFMRXM','ZY_FYGZJSSFTSJX','SF_SFSYSFXMZMYHJM','ZY_YBFBZHLBBTSFTS','ZY_YJJSKDJXSZLCK','ZY_SZCYBRTJDYFS','ZY_YJJCKDGS','ZY_ZYBRFBXGYB','ZY_FPSFDYGWYJE','ZY_XNHCSLX','ZY_JKDSFSYFR3XS','ZY_YBFSRYKSSFSYBQ','ZY_GFMZFYWJSSFYXRY','ZY_SFBKGFBR','ZY_BRCYJSTS','ZY_XNHFZXMC','ZY_ZYRQDHZJMJE','ZY_ZYBRXXWFSBASFBHXNH','ZY_XNHBRSFXSYBZHJE','ZY_HSFPJGS','ZY_CYJSSFTSSNBBR','ZY_QDDYSFGJNRCDZDHH','ZY_KZMZFBBRCFFP','ZY_YBBRCYJSSFBCWJ','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM') 348 10:38:20 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('ZY_CSBSYBFPSFFKCL','ZY_PRINTYYFYMXZZDY','ZY_WCKSFYXCYJS','ZY_SFQYBASYCSJK','ZY_SFYJKTJ_SFCF','ZY_SFYJKTJLS','ZY_SFYJKTJHS','ZY_YXLFYZFBRCYJS','ZY_QDHZSHTSDY','ZY_ZYYSJZSRXSCYRS','ZY_NHBRSFCSJBZD','ZY_JKJHSFXSJKDH','ZY_ZYBRSFKYZHBRID','ZY_BASYNHBRSFCSICKH','ZY_FPRQDYSFXSDYRQ','ZY_XNHBRSFCSICKH','ZY_YJJYHKTCSFYXJTC','ZY_RYDJZDCSDBJE','ZY_YJJSKSFXSYLMXZ','ZY_SZCYBRSFKYRY','ZY_BRLDTJ_BQ_KS','ZY_YJJYEMXBTITLE','ZY_JKRQXSSFALNYYFS','ZY_NHBRSFFSCYDJRQ','ZY_NBBRXB','ZY_QDDYSFMRQTDYJ','ZY_YBJSRBBSFXSCZYB','ZY_ZFZYBXMTSSB','ZY_JKRQSFGBCXGJKRQ','ZY_ZFBRXB','ZY_BASY_LEFTPAGE','ZY_BASY_TOPPAGE','ZY_PJJHYJJSFXSCXLL','SF_MZFPPDSFXYBR','ZY_CYJSTKAYJJ','ZY_JKDYFWSFYZTYZDZ','ZY_FZFZYBSFXZ','ZY_FPTHBJXX','ZY_NHBRSFMRXM','ZY_FYGZJSSFTSJX','SF_SFSYSFXMZMYHJM','ZY_YBFBZHLBBTSFTS','ZY_YJJSKDJXSZLCK','ZY_SZCYBRTJDYFS','ZY_YJJCKDGS','ZY_ZYBRFBXGYB','ZY_FPSFDYGWYJE','ZY_XNHCSLX','ZY_JKDSFSYFR3XS','ZY_YBFSRYKSSFSYBQ','ZY_GFMZFYWJSSFYXRY','ZY_SFBKGFBR','ZY_BRCYJSTS','ZY_XNHFZXMC','ZY_ZYRQDHZJMJE','ZY_ZYBRXXWFSBASFBHXNH','ZY_XNHBRSFXSYBZHJE','ZY_HSFPJGS','ZY_CYJSSFTSSNBBR','ZY_QDDYSFGJNRCDZDHH','ZY_KZMZFBBRCFFP','ZY_YBBRCYJSSFBCWJ','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM') 349 10:38:20 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='5' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='5'))) 350 10:38:20 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='5' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='5'))) 351 10:38:20 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 352 10:38:20 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 353 10:38:20 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 354 10:38:20 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 355 10:38:20 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 356 10:38:20 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 357 10:38:20 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 358 10:38:20 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 359 10:38:20 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 360 10:38:20 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 361 10:38:22 SQL Prepare: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 362 10:38:22 SQL Execute: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 363 10:38:22 SQL Prepare: ORACLE - Commit 364 10:38:22 SQL Execute: ORACLE - Commit 365 10:38:39 SQL Prepare: ORACLE - select BMBH00,BH0000,BMMC00 from BM_BMBM00 where BMXZ00 IN ('9') AND FLAG00='1' AND CZBZ00<>'2' order by BMXZ00,BH0000 366 10:38:39 SQL Execute: ORACLE - select BMBH00,BH0000,BMMC00 from BM_BMBM00 where BMXZ00 IN ('9') AND FLAG00='1' AND CZBZ00<>'2' order by BMXZ00,BH0000 367 10:38:40 SQL Prepare: ORACLE - BEGIN "SP_ZY_ZYYSBFGZLTJ" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_KSBH00 => :AS_KSBH00,AS_HSLB00 => :AS_HSLB00,AD_ID0000 => :AD_ID0000,AD_YHMSG0 => :AD_YHMSG0,AD_SYSMSG => :AD_SYSMSG); END; 368 10:38:40 SQL Execute: ORACLE - BEGIN "SP_ZY_ZYYSBFGZLTJ" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_KSBH00 => :AS_KSBH00,AS_HSLB00 => :AS_HSLB00,AD_ID0000 => :AD_ID0000,AD_YHMSG0 => :AD_YHMSG0,AD_SYSMSG => :AD_SYSMSG); END; 369 10:38:44 SQL Prepare: ORACLE - select A.BMBH00,decode(A.BMBH00,999999999,'总 计',0,'其 它',NVL(B.BMMC00,'无对应科室')) BMMC00, decode(A.SFXM99,0,' ',NVL(C.ZWXM00,'无对应医生')) ZWXM00, A.XMHJ00,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.SFXM87,A.SFXM88,A.SFXM89,A.SFXM90,A.SFXM91,A.SFXM92,A.SFXM93,A.SFXM94,A.SFXM95,A.SFXM96,A.SFXM97,A.SFXM98, C.YGBH00, A.ID0000 from BM_YYSFTJ A, BM_BMBM00 B, BM_YGBM00 C where A.BMBH00 = B.BMBH00(+) AND A.SFXM99=C.YGBH00(+) and A.ID0000 =:1 order by A.BMBH00,C.XKH000 370 10:38:44 SQL Execute: ORACLE - select A.BMBH00,decode(A.BMBH00,999999999,'总 计',0,'其 它',NVL(B.BMMC00,'无对应科室')) BMMC00, decode(A.SFXM99,0,' ',NVL(C.ZWXM00,'无对应医生')) ZWXM00, A.XMHJ00,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.SFXM87,A.SFXM88,A.SFXM89,A.SFXM90,A.SFXM91,A.SFXM92,A.SFXM93,A.SFXM94,A.SFXM95,A.SFXM96,A.SFXM97,A.SFXM98, C.YGBH00, A.ID0000 from BM_YYSFTJ A, BM_BMBM00 B, BM_YGBM00 C where A.BMBH00 = B.BMBH00(+) AND A.SFXM99=C.YGBH00(+) and A.ID0000 =? order by A.BMBH00,C.XKH000 371 10:38:44 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='1' 372 10:38:44 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='1' 373 10:38:44 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='2' 374 10:38:44 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='2' 375 10:38:44 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='3' 376 10:38:44 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='3' 377 10:38:44 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='4' 378 10:38:44 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='4' 379 10:38:44 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='5' 380 10:38:44 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='5' 381 10:38:44 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='6' 382 10:38:44 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='6' 383 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='7' 384 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='7' 385 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='8' 386 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='8' 387 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='9' 388 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='9' 389 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='10' 390 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='10' 391 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='11' 392 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='11' 393 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='12' 394 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='12' 395 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='13' 396 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='13' 397 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='14' 398 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='14' 399 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='15' 400 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='15' 401 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='16' 402 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='16' 403 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='17' 404 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='17' 405 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='18' 406 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='18' 407 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='19' 408 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='19' 409 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='20' 410 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='20' 411 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='21' 412 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='21' 413 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='22' 414 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='22' 415 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='23' 416 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='23' 417 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='24' 418 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='24' 419 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='25' 420 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='25' 421 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='26' 422 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='26' 423 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='27' 424 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='27' 425 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='28' 426 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='28' 427 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='29' 428 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='29' 429 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='30' 430 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='30' 431 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='31' 432 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='31' 433 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='32' 434 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='32' 435 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='33' 436 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='33' 437 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='34' 438 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='34' 439 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='35' 440 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='35' 441 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='36' 442 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='36' 443 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='37' 444 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='37' 445 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='38' 446 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='38' 447 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='39' 448 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='39' 449 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='40' 450 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='40' 451 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='41' 452 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='41' 453 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='42' 454 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='42' 455 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='43' 456 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='43' 457 10:38:45 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='44' 458 10:38:45 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='44' 459 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='45' 460 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='45' 461 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='46' 462 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='46' 463 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='47' 464 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='47' 465 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='48' 466 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='48' 467 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='49' 468 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='49' 469 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='50' 470 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='50' 471 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='51' 472 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='51' 473 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='52' 474 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='52' 475 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='53' 476 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='53' 477 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='54' 478 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='54' 479 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='55' 480 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='55' 481 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='56' 482 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='56' 483 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='57' 484 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='57' 485 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='58' 486 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='58' 487 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='59' 488 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='59' 489 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='60' 490 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='60' 491 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='61' 492 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='61' 493 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='62' 494 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='62' 495 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='63' 496 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='63' 497 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='64' 498 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='64' 499 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='65' 500 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='65' 501 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='66' 502 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='66' 503 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='67' 504 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='67' 505 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='68' 506 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='68' 507 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='69' 508 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='69' 509 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='70' 510 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='70' 511 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='71' 512 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='71' 513 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='72' 514 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='72' 515 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='73' 516 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='73' 517 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='74' 518 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='74' 519 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='75' 520 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='75' 521 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='87' 522 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='87' 523 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='88' 524 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='88' 525 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='89' 526 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='89' 527 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='90' 528 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='90' 529 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='91' 530 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='91' 531 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='92' 532 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='92' 533 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='93' 534 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='93' 535 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='94' 536 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='94' 537 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='95' 538 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='95' 539 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='96' 540 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='96' 541 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='97' 542 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='97' 543 10:38:46 SQL Prepare: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='98' 544 10:38:46 SQL Execute: ORACLE - select a.* from VW_BM_YJHSXM A,BM_GHKSTJ_KSDY00 B where B.ID0000=672714 AND A.YJHSBH=trim(B.GHKSMC) and B.GHKSBH='98' 545 10:39:19 SQL Prepare: ORACLE - SELECT FPXMMC, BMMC00, ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110301' AND '20110331'GROUP BY FPXMMC, BMMC00, ZWXM00 ORDER BY FPXMMC, BMMC00, ZWXM00 546 10:39:19 SQL Execute: ORACLE - SELECT FPXMMC, BMMC00, ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110301' AND '20110331'GROUP BY FPXMMC, BMMC00, ZWXM00 ORDER BY FPXMMC, BMMC00, ZWXM00 547 10:39:41 SQL Prepare: ORACLE - SELECT FPXMMC, BMMC00, ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110301' AND '20110331'GROUP BY FPXMMC, BMMC00, ZWXM00 ORDER BY FPXMMC, BMMC00, ZWXM00 548 10:39:41 SQL Execute: ORACLE - SELECT FPXMMC, BMMC00, ZWXM00, SUM(HJJE00) FROM VW_ZY_YSGZL0_FPXM00 WHERE CZRQ00 BETWEEN '20110301' AND '20110331'GROUP BY FPXMMC, BMMC00, ZWXM00 ORDER BY FPXMMC, BMMC00, ZWXM00