1 10:04:41 Log started for: 后台维护系统 2 10:04:49 Log started for: 门诊挂号收费管理系统 3 10:04:49 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110701','10:04:50','scott@6603:665DB8654B9B5AD27D3285F273372C79' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 10:04:49 SQL Execute: ORACLE - Commit 5 10:04:49 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 6 10:04:49 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 7 10:04:49 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='6603' and CZBZ00 in ('1') 8 10:04:49 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110701','10:04:50','sd_Hospital@6603:F33F977F4ACDFAE8D154003D0F913C30' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 9 10:04:49 SQL Execute: ORACLE - Commit 10 10:04:49 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 11 10:04:49 SQL Execute: ORACLE - Commit 12 10:04:49 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 13 10:04:49 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='6603' and CZBZ00 in ('1') 14 10:04:49 SQL Execute: ORACLE - Select SYSDATE from Dual 15 10:04:49 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 16 10:04:49 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 17 10:04:49 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 18 10:04:49 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 19 10:04:49 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 20 10:04:49 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6603')) 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='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6603')) order by b.PLXH00,a.BH0000 21 10:04:49 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '6603'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6603')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6603') 22 10:04:49 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=272 23 10:04:49 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 24 10:04:49 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 25 10:04:49 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 26 10:04:49 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 27 10:04:49 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')) 28 10:04:49 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2616834,272,'wlzx-2','4',nvl('4674411',' '),'192.168.15.15#568:37688@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44) 29 10:04:49 SQL Execute: ORACLE - Commit 30 10:04:49 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44 31 10:04:49 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 32 10:04:49 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 33 10:04:49 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 34 10:04:49 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 35 10:04:49 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 44 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 36 10:04:49 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 37 10:04:49 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 38 10:04:50 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='272' and name00='SYSTEMSKIN' 39 10:04:50 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20110701' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) 40 10:04:50 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 41 10:04:50 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 42 10:04:50 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 272= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=272 and XTDM00='4'))) 43 10:04:50 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 44 10:04:50 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 ((272= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=272 and XTDM00='0 '))) 45 10:04:50 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 46 10:04:50 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 272= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=272 and XTDM00='+ '))) 47 10:04:50 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 48 10:04:50 SQL Execute: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 49 10:04:50 SQL Execute: ORACLE - Commit 50 10:04:50 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' 51 10:04:50 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 52 10:04:50 SQL Execute: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 53 10:04:50 SQL Execute: ORACLE - select sysdate nowtime from dual 54 10:04:50 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 272 55 10:04:50 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') 56 10:04:50 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') 57 10:04:50 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 58 10:04:50 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 59 10:04:50 SQL Execute: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 60 10:04:50 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') 61 10:04:50 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 62 10:04:50 SQL Execute: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK' 63 10:05:47 SQL Execute: ORACLE - rollback 64 10:05:47 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2616834 65 10:05:47 SQL Execute: ORACLE - Commit 66 10:05:48 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 67 10:05:48 SQL Execute: ORACLE - Commit 68 10:55:35 Log started for: Gysystem 69 10:55:50 SQL Execute: ORACLE - select '0' flag00,a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,a.qlsj00,a.qlksmc,a.sfsl00,a.wpmc00,a.wpgg00,b.wpdw00, a.wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,a.zt0000,a.ffrq00,a.ffsj00,a.wpbh00, trunc(a.sfsl00/nvl(b.zhl000,1)) bzsl00,mod(a.sfsl00,nvl(b.zhl000,1)) jlsl00,b.zhl000,b.wpbzdw from ( select a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,qlsj00,a.qlksmc,sum(b.sfsl00) sfsl00,wpmc00,wpgg00, wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,a.zt0000,a.ffrq00,a.ffsj00,b.wpbh00 from vw_gy_kswply a,vw_gy_wplymx b where a.qldh00=b.qldh00 and a.qlksbh=? and a.ffrq00>=? and a.ffrq00<=? and wpxz00 like ? and a.ZT0000 LIKE ? and a.FFKSBH = ? group by a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,a.qlsj00,a.qlksmc,wpmc00,wpgg00,wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0, a.zt0000,a.ffrq00,a.ffsj00,b.wpbh00 ) a,gy_wpbm00 b where a.wpbh00=b.wpbh00 order by a.qldh00 70 11:12:56 Log started for: 门诊挂号收费管理系统 71 11:12:56 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110701','11:12:57','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 72 11:12:56 SQL Execute: ORACLE - Commit 73 11:12:56 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 74 11:12:56 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 75 11:12:56 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 76 11:12:56 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110701','11:12:57','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 77 11:12:56 SQL Execute: ORACLE - Commit 78 11:12:56 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 79 11:12:56 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 80 11:12:56 SQL Execute: ORACLE - Select SYSDATE from Dual 81 11:12:56 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 82 11:12:56 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 83 11:12:56 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 84 11:12:56 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 85 11:12:56 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 86 11:12:56 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4' 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='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 87 11:12:56 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' 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='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 88 11:12:57 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 89 11:12:57 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 90 11:12:57 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 91 11:12:57 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 92 11:12:57 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 93 11:12:57 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')) 94 11:12:57 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2617190,476,'wlzx-2','4',nvl('5234131',' '),'192.168.15.15#254:63651@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44) 95 11:12:57 SQL Execute: ORACLE - Commit 96 11:12:57 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44 97 11:12:57 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 98 11:12:57 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 99 11:12:57 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 100 11:12:57 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 101 11:12:57 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 44 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 102 11:12:57 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 103 11:12:57 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 104 11:12:57 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 105 11:12:57 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20110701' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) 106 11:12:57 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 107 11:12:57 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 108 11:12:57 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'))) 109 11:12:57 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 110 11:12:58 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 '))) 111 11:12:58 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 112 11:12:58 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='+ '))) 113 11:12:58 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 114 11:12:58 SQL Execute: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 115 11:12:58 SQL Execute: ORACLE - Commit 116 11:12:58 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' 117 11:12:58 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 118 11:12:58 SQL Execute: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 119 11:12:58 SQL Execute: ORACLE - select sysdate nowtime from dual 120 11:12:58 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 121 11:12:58 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') 122 11:12:58 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') 123 11:12:58 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 124 11:12:58 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 125 11:12:58 SQL Execute: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 126 11:12:58 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') 127 11:12:58 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 128 11:12:58 SQL Execute: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK' 129 11:13:19 SQL Execute: ORACLE - select distinct (ZWXM00||'_'||XKH000) CZYXM0 from VW_SF_SFY000 130 11:13:46 SQL Execute: ORACLE - BEGIN "SP_SF_JKKJXX_TJ0000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_SFY000 => :AS_SFY000,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 131 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ where ID0000 =? order by DYID00 132 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='01' 133 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='02' 134 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='03' 135 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='04' 136 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='05' 137 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='06' 138 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='07' 139 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='08' 140 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='09' 141 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='10' 142 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='11' 143 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='12' 144 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='13' 145 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='14' 146 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='15' 147 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='16' 148 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='17' 149 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='18' 150 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='19' 151 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='20' 152 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='21' 153 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='22' 154 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='23' 155 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='24' 156 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='25' 157 11:13:57 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='26' 158 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='27' 159 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='28' 160 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='29' 161 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='30' 162 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='31' 163 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='32' 164 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='33' 165 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='34' 166 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='35' 167 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='36' 168 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='37' 169 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='38' 170 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='39' 171 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='40' 172 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='41' 173 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='42' 174 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='43' 175 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='44' 176 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='45' 177 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='46' 178 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='47' 179 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='48' 180 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='49' 181 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='50' 182 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='51' 183 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='52' 184 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='53' 185 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='54' 186 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='55' 187 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='56' 188 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='57' 189 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='58' 190 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='59' 191 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='60' 192 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='61' 193 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='62' 194 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='63' 195 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='64' 196 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='65' 197 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='66' 198 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='67' 199 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='68' 200 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='69' 201 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='70' 202 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='71' 203 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='72' 204 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='73' 205 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='74' 206 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='75' 207 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='76' 208 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='77' 209 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='78' 210 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='79' 211 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='80' 212 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='81' 213 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='82' 214 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='83' 215 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='84' 216 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='85' 217 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='86' 218 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='87' 219 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='88' 220 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='89' 221 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='90' 222 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='91' 223 11:13:58 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='92' 224 11:13:59 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='93' 225 11:13:59 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='94' 226 11:13:59 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='95' 227 11:13:59 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='96' 228 11:13:59 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='97' 229 11:13:59 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='98' 230 11:13:59 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='99' 231 11:17:49 Log started for: SQL Navigator for Oracle 232 11:23:16 Log started for: 后台维护系统 233 11:23:16 SQL Execute: ORACLE - Select SYSDATE from Dual 234 11:23:16 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 235 11:23:16 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='6' 236 11:23:16 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 237 11:23:16 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 238 11:23:16 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('8') order by BH0000 239 11:23:16 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'super'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '6' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='SUPER')) 240 11:23:16 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=0 241 11:23:16 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 242 11:23:16 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 243 11:23:16 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 244 11:23:16 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 245 11:23:16 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')) 246 11:23:16 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2617267,0,'wlzx-2','6',nvl('5284172',' '),'',15) 247 11:23:16 SQL Execute: ORACLE - Commit 248 11:23:16 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15 249 11:23:16 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 250 11:23:16 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 251 11:23:16 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 252 11:23:16 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 253 11:23:16 SQL Execute: ORACLE - Commit 254 11:23:16 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 255 11:23:16 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 256 11:23:16 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='6') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',15,')> 0) and YXQ000>='20110701' 257 11:23:16 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 258 11:23:16 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 259 11:23:16 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 260 11:23:16 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 261 11:23:16 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 262 11:23:16 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 263 11:23:16 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 a where XTDM00='6' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 264 11:23:16 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||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 ((0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 265 11:23: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 ((0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 266 11:23:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 267 11:23:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 268 11:23:16 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('XT_YSXGFBKS','XT_XTXXYTJRXG','YF_SFXSGJJ') 269 11:23:19 SQL Execute: ORACLE - Select * from XT_YGXZ00 ORDER BY DM0000 270 11:23:19 SQL Execute: ORACLE - select t1.YGBH00,t1.BMBH00,t1.ZWXM00,t1.XB0000,t1.XKH000, t1.PYSM00,t1.WBSM00, (select BMMC00 from BM_BMBM00 where t1.BMBH00=BMBH00(+)) BMMC00, t1.YGXZ00, t1.CFJB00,t1.GZDJ00,t1.MZDJ00,t1.DPDJ00,t1.SJDJ00, t1.CZBZ00,t1.DLMM00,t1.BRID00,t1.MRGHLB, (select LBMC00 from BM_GHLBB0 where SFYX00='Y' and t1.MRGHLB=LBBH00(+)) LBMC00, t1.YSLB00, (select YSLBMC from BM_YSLB00 where t1.YSLB00=YSLB00(+)) YSLBMC, t1.ssdj00,t1.ylfl00 from BM_YGBM00 t1 where t1.YGBH00>=1 and(1=? OR CZBZ00<>'2') order by t1.XKH000,t1.BMBH00 271 11:40:49 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2617267 272 11:40:49 SQL Execute: ORACLE - Commit 273 11:40:49 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 274 11:40:49 SQL Execute: ORACLE - Commit 275 11:40:49 Log started for: SQL Navigator for Oracle 276 15:16:09 Log started for: 门诊挂号收费管理系统 277 15:16:09 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110701','15:16:10','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 278 15:16:09 SQL Execute: ORACLE - Commit 279 15:16:09 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 280 15:16:09 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 281 15:16:09 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 282 15:16:09 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110701','15:16:10','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 283 15:16:09 SQL Execute: ORACLE - Commit 284 15:16:09 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 285 15:16:09 SQL Execute: ORACLE - Commit 286 15:16:09 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 287 15:16:09 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 288 15:16:09 SQL Execute: ORACLE - Select SYSDATE from Dual 289 15:16:09 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 290 15:16:09 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 291 15:16:09 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 292 15:16:09 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 293 15:16:09 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 294 15:16:09 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4' 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='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 295 15:16:09 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' 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='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 296 15:16:09 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 297 15:16:09 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 298 15:16:09 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 299 15:16:09 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 300 15:16:09 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 301 15:16:09 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')) 302 15:16:09 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2617557,476,'wlzx-2','4',nvl('5285204',' '),'192.168.15.15#668:32@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44) 303 15:16:09 SQL Execute: ORACLE - Commit 304 15:16:09 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44 305 15:16:09 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 306 15:16:09 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 307 15:16:09 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 308 15:16:09 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 309 15:16:09 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 44 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 310 15:16:09 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 311 15:16:09 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 312 15:16:10 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 313 15:16:10 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20110701' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) 314 15:16:10 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 315 15:16:10 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 316 15:16:10 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'))) 317 15:16:10 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 318 15:16:10 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 '))) 319 15:16:10 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 320 15:16:10 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='+ '))) 321 15:16:10 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 322 15:16:10 SQL Execute: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 323 15:16:10 SQL Execute: ORACLE - Commit 324 15:16:10 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' 325 15:16:10 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 326 15:16:10 SQL Execute: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 327 15:16:10 SQL Execute: ORACLE - select sysdate nowtime from dual 328 15:16:10 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 329 15:16:10 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') 330 15:16:10 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') 331 15:16:11 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 332 15:16:11 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 333 15:16:11 SQL Execute: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 334 15:16:11 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') 335 15:16:11 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 336 15:16:11 SQL Execute: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK' 337 15:16:20 SQL Execute: ORACLE - select distinct (ZWXM00||'_'||XKH000) CZYXM0 from VW_SF_SFY000 338 15:16:40 SQL Execute: ORACLE - BEGIN "SP_SF_JKKJXX_TJ0000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_SFY000 => :AS_SFY000,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 339 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ where ID0000 =? order by DYID00 340 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='01' 341 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='02' 342 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='03' 343 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='04' 344 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='05' 345 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='06' 346 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='07' 347 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='08' 348 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='09' 349 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='10' 350 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='11' 351 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='12' 352 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='13' 353 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='14' 354 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='15' 355 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='16' 356 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='17' 357 15:16:49 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='18' 358 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='19' 359 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='20' 360 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='21' 361 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='22' 362 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='23' 363 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='24' 364 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='25' 365 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='26' 366 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='27' 367 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='28' 368 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='29' 369 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='30' 370 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='31' 371 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='32' 372 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='33' 373 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='34' 374 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='35' 375 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='36' 376 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='37' 377 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='38' 378 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='39' 379 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='40' 380 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='41' 381 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='42' 382 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='43' 383 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='44' 384 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='45' 385 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='46' 386 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='47' 387 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='48' 388 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='49' 389 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='50' 390 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='51' 391 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='52' 392 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='53' 393 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='54' 394 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='55' 395 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='56' 396 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='57' 397 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='58' 398 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='59' 399 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='60' 400 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='61' 401 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='62' 402 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='63' 403 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='64' 404 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='65' 405 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='66' 406 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='67' 407 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='68' 408 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='69' 409 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='70' 410 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='71' 411 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='72' 412 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='73' 413 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='74' 414 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='75' 415 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='76' 416 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='77' 417 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='78' 418 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='79' 419 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='80' 420 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='81' 421 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='82' 422 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='83' 423 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='84' 424 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='85' 425 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='86' 426 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='87' 427 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='88' 428 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='89' 429 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='90' 430 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='91' 431 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='92' 432 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='93' 433 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='94' 434 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='95' 435 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='96' 436 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='97' 437 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='98' 438 15:16:50 SQL Execute: ORACLE - select * from BM_GHKSTJ_KSDY00 where ID0000 =? and BH0000='99'