1 11:22:38 Log started for: Yjsystem 2 11:22:38 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 11:22:38 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 11:22:38 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','7','YJsystem.exe'||'+'||'医技管理系统','180','8509' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual 5 11:22:38 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','7','YJsystem.exe'||'+'||'医技管理系统','180','8509' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual 6 11:22:38 SQL Data In: ORACLE - Rows affected = 1 7 11:22:38 SQL Prepare: ORACLE - Commit 8 11:22:38 SQL Execute: ORACLE - Commit 9 11:22:38 SQL Data In: ORACLE - Rows affected = 0 10 11:22:38 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 11:22:38 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 12 11:22:38 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 11:22:38 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 14 11:22:38 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 15 11:22:38 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 16 11:22:38 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 11:22:38 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 18 11:22:38 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','7','YJsystem.exe'||'+'||'医技管理系统','82','12040' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual 19 11:22:38 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','7','YJsystem.exe'||'+'||'医技管理系统','82','12040' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual 20 11:22:38 SQL Data In: ORACLE - Rows affected = 1 21 11:22:38 SQL Prepare: ORACLE - Commit 22 11:22:38 SQL Execute: ORACLE - Commit 23 11:22:38 SQL Data In: ORACLE - Rows affected = 0 24 11:22:38 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 25 11:22:38 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 26 11:22:38 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 27 11:22:38 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 28 11:22:38 SQL Prepare: ORACLE - Select SYSDATE from Dual 29 11:22:38 SQL Execute: ORACLE - Select SYSDATE from Dual 30 11:22:38 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 11:22:38 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 32 11:22:38 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 11:22:38 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 34 11:22:38 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7' 35 11:22:38 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7' 36 11:22:38 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 11:22:38 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 11:22:38 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 39 11:22:38 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 40 11:22:38 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0',',','1','5',',','1',',','a') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) order by b.PLXH00,a.BH0000 41 11:22:38 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0',',','1','5',',','1',',','a') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) order by b.PLXH00,a.BH0000 42 11:22:43 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '343'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '7' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 43 11:22:43 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '343'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '7' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 44 11:22:43 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 45 11:22:43 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 46 11:22:43 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 11:22:43 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 11:22:43 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 11:22:43 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 11:22:43 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 11:22:43 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 52 11:22:43 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 11:22:43 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 54 11:22:43 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')) 55 11:22:43 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')) 56 11:22:43 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3917830,1143,'wlzx','7',nvl('226818824',' '),'192.168.9.99#82:12040@YJsystem.exe+医技管理系统',20) 57 11:22:43 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3917830,1143,'wlzx','7',nvl('226818824',' '),'192.168.9.99#82:12040@YJsystem.exe+医技管理系统',20) 58 11:22:43 SQL Data In: ORACLE - Rows affected = 1 59 11:22:43 SQL Prepare: ORACLE - Commit 60 11:22:43 SQL Execute: ORACLE - Commit 61 11:22:43 SQL Data In: ORACLE - Rows affected = 0 62 11:22:43 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 63 11:22:43 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 64 11:22:43 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 65 11:22:43 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 66 11:22:43 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 67 11:22:43 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 68 11:22:43 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.99' 69 11:22:43 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.99' 70 11:22:43 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 71 11:22:43 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 72 11:22:43 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 73 11:22:43 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 74 11:22:43 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 75 11:22:43 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 76 11:22:43 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'7'||',')>0 77 11:22:43 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'7'||',')>0 78 11:22:44 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 79 11:22:44 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 80 11:22:44 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 81 11:22:44 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 82 11:22:44 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20131226' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='7') 83 11:22:44 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20131226' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='7') 84 11:22:44 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 85 11:22:44 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 86 11:22:44 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 87 11:22:44 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 88 11:22:44 SQL Prepare: ORACLE - select sysdate from dual 89 11:22:44 SQL Execute: ORACLE - select sysdate from dual 90 11:22:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='7' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='7'))) 91 11:22:44 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='7' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='7'))) 92 11:22:44 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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 93 11:22:44 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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 94 11:22:44 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 95 11:22:44 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 96 11:22:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 97 11:22:44 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 98 11:22:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 99 11:22:44 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 100 11:22:44 SQL Prepare: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 101 11:22:44 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 102 11:22:44 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY','YJ_BBCYHZDPrintSet','BQ_ZXDPrinterM') and YGBH00 = 1143 103 11:22:44 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY','YJ_BBCYHZDPrintSet','BQ_ZXDPrinterM') and YGBH00 = 1143 104 11:22:44 SQL Prepare: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YF_YYGXH','YJ_YXCXTS','YJ_YXCXTS2','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_SYKSFZDDY','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YF_MZCFTDHS','YJ_XMZJYSWSSKS','YJ_XSKDYGS','YJ_XSKDYGS_NEW','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','YJ_SYHDSFDY','YJ_ZJLZDYDY','YJ_XMWHCKSFKYZXXM','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY','YJ_XMAPSFAKSCX','YJ_XMAPDYZDYID','YJ_XMSQKSYSSFMRWK','YJ_SYGCDZDYDY','YJ_CFFWFXWHXZ','YJ_TXMDYSFFY','YJ_YJCXD_ZDY','XT_ZYXTGBDW','YF_MZCFSFDYXXYF','YF_CFSFDYTYM','YF_CFTDGSSFZJZD','YF_MZCFJYDJGHS','YF_MZCFSFDYYS','YF_MZCFTDDDHS','YF_CFTDSFDYFB','YF_ZYJYF_SFDM','YF_SFDYCFT','YJ_SFQYMZYDSY','YJ_ZXDSFZDYYSFXM') 105 11:22:44 SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YF_YYGXH','YJ_YXCXTS','YJ_YXCXTS2','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_SYKSFZDDY','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YF_MZCFTDHS','YJ_XMZJYSWSSKS','YJ_XSKDYGS','YJ_XSKDYGS_NEW','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','YJ_SYHDSFDY','YJ_ZJLZDYDY','YJ_XMWHCKSFKYZXXM','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY','YJ_XMAPSFAKSCX','YJ_XMAPDYZDYID','YJ_XMSQKSYSSFMRWK','YJ_SYGCDZDYDY','YJ_CFFWFXWHXZ','YJ_TXMDYSFFY','YJ_YJCXD_ZDY','XT_ZYXTGBDW','YF_MZCFSFDYXXYF','YF_CFSFDYTYM','YF_CFTDGSSFZJZD','YF_MZCFJYDJGHS','YF_MZCFSFDYYS','YF_MZCFTDDDHS','YF_CFTDSFDYFB','YF_ZYJYF_SFDM','YF_SFDYCFT','YJ_SFQYMZYDSY','YJ_ZXDSFZDYYSFXM') 106 11:22:44 SQL Prepare: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 107 11:22:44 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 108 11:22:44 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00=1143 and name00='YJ_QSBRLB' 109 11:22:44 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=1143 and name00='YJ_QSBRLB' 110 11:22:44 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 111 11:22:44 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 112 11:22:48 SQL Prepare: ORACLE - select * from bm_jyzyzb order by zyzbid 113 11:22:48 SQL Execute: ORACLE - select * from bm_jyzyzb order by zyzbid 114 11:22:48 SQL Prepare: ORACLE - Select distinct zlxmbh,zlxmjc from BM_ZLZD00 where lbbz00='0' and zlxmbh Like 'Z%' order by zlxmbh 115 11:22:48 SQL Execute: ORACLE - Select distinct zlxmbh,zlxmjc from BM_ZLZD00 where lbbz00='0' and zlxmbh Like 'Z%' order by zlxmbh 116 11:22:48 SQL Prepare: ORACLE - SELECT * FROM bm_bbzd00 117 11:22:48 SQL Execute: ORACLE - SELECT * FROM bm_bbzd00 118 11:22:48 SQL Prepare: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,DLBQZX,DLKSZX,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,zhxmbz,jkbh01,a.jytzbh,jclbid,a.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID ,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like '%' and Zlxmid>=100 order by zlxmbh 119 11:22:48 SQL Execute: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,DLBQZX,DLKSZX,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,zhxmbz,jkbh01,a.jytzbh,jclbid,a.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID ,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like '%' and Zlxmid>=100 order by zlxmbh 120 11:22:48 SQL Data In: ORACLE - Rows affected = 0 121 11:22:51 SQL Prepare: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,DLBQZX,DLKSZX,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,zhxmbz,jkbh01,a.jytzbh,jclbid,a.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID ,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z003005%' and Zlxmid>=100 order by zlxmbh 122 11:22:51 SQL Execute: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,DLBQZX,DLKSZX,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,zhxmbz,jkbh01,a.jytzbh,jclbid,a.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID ,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z003005%' and Zlxmid>=100 order by zlxmbh 123 11:22:51 SQL Data In: ORACLE - Rows affected = 0 124 11:22:54 SQL Prepare: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,a.zhxmbz,a.jkbh01,a.jytzbh, lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,dlkszx,dlbqzx,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,jclbid, A.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z003005%' and Zlxmid>=100 order by zlxmbh 125 11:22:54 SQL Execute: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,a.zhxmbz,a.jkbh01,a.jytzbh, lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,dlkszx,dlbqzx,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,jclbid, A.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z003005%' and Zlxmid>=100 order by zlxmbh 126 11:22:54 SQL Data In: ORACLE - Rows affected = 0 127 11:22:55 SQL Prepare: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,a.zhxmbz,a.jkbh01,a.jytzbh, lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,dlkszx,dlbqzx,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,jclbid, A.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z003005%' and Zlxmid>=100 order by zlxmbh 128 11:22:55 SQL Execute: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,a.zhxmbz,a.jkbh01,a.jytzbh, lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,dlkszx,dlbqzx,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,jclbid, A.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z003005%' and Zlxmid>=100 order by zlxmbh 129 11:22:55 SQL Data In: ORACLE - Rows affected = 0 130 11:22:55 SQL Prepare: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,a.zhxmbz,a.jkbh01,a.jytzbh, lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,dlkszx,dlbqzx,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,jclbid, A.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z003005%' and Zlxmid>=100 order by zlxmbh 131 11:22:55 SQL Execute: ORACLE - Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,a.zhxmbz,a.jkbh01,a.jytzbh, lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,dlkszx,dlbqzx,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,jclbid, A.SQDID0,a.SFCSSX,a.SSDJBH, a.DAXXID,(select trim(d.SBMC00) from SB_DA0000 d where d.DAXXID=a.DAXXID) SBMC00,a.ZYSQID,a.ZYMZBZ,JCZID0,(select YYXMMC from YJ_YYZLZD where XMWHID=a.JCZID0 and XMWHID>0) JCZMC0 from BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 and zlxmbh like 'Z003005%' and Zlxmid>=100 order by zlxmbh 132 11:22:55 SQL Data In: ORACLE - Rows affected = 0