1 17:15:43 Log started for: 库存物资管理子系统 2 17:15:43 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 17:15:43 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.9','K','prjSB_KCWZ.exe'||'+'||'库存物资管理子系统','824','9769' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@lt:2DA6B754B58D5EA372C7D2DCBD4FE10C' from dual 4 17:15:43 SQL Data In: ORACLE - Rows affected = 1 5 17:15:43 SQL Execute: ORACLE - Commit 6 17:15:43 SQL Data In: ORACLE - Rows affected = 0 7 17:15:43 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 17:15:43 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221218' 9 17:15:43 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LT' and CZBZ00 in ('1') 10 17:15:43 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 17:15:43 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.9','K','prjSB_KCWZ.exe'||'+'||'库存物资管理子系统','837','7880' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@lt:55824DB740128A593C9B7364D2133402' from dual 12 17:15:43 SQL Data In: ORACLE - Rows affected = 1 13 17:15:43 SQL Execute: ORACLE - Commit 14 17:15:43 SQL Data In: ORACLE - Rows affected = 0 15 17:15:43 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K' 16 17:15:43 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LT' and CZBZ00 in ('1') 17 17:15:43 SQL Execute: ORACLE - Select SYSDATE from Dual 18 17:15:43 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 19 17:15:43 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 20 17:15:43 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 21 17:15:43 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 22 17:15:43 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 23 17:15:43 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'YB-MMRK' 24 17:15:43 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'YB-SBK' 25 17:15:43 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LT')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('a','b','c') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LT')) order by b.PLXH00,a.BH0000 26 17:15:45 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'lt'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'K' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LT')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LT') 27 17:15:45 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=277 28 17:15:45 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 29 17:15:45 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 17:15:45 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 31 17:15:45 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 32 17:15:45 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')) 33 17:15:45 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1511054,277,'ll','K',nvl('333584',' '),'192.168.3.9-192.168.1.9#837:7880@prjSB_KCWZ.exe+库存物资管理子系统',115) 34 17:15:45 SQL Data In: ORACLE - Rows affected = 1 35 17:15:45 SQL Execute: ORACLE - Commit 36 17:15:45 SQL Data In: ORACLE - Rows affected = 0 37 17:15:45 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 115 38 17:15:45 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221218' 39 17:15:45 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 40 17:15:45 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.9' 41 17:15:45 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 42 17:15:45 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 115 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 43 17:15:45 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221218') 44 17:15:45 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 45 17:15:50 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='277' and name00='SYSTEMSKIN' 46 17:15:50 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 47 17:15:50 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20120828' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',115,' )>0 ) 48 17:15:50 SQL Execute: ORACLE - select distinct a.CZYKS0,b.BMMC00 from vw_bm_SystemMessage a,BM_BMBM00 b where a.CZYKS0=b.BMBH00 and (XTDM00='-1' or XTDM00='K') and (JSKSBH is null or instr( ','||JSKSBH||',' , ',115,' )>0 ) 49 17:15:50 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='消息系统字体颜色配置' 50 17:15:50 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 = 'XTXXSFJXPX' 51 17:15:50 SQL Execute: ORACLE - select * from vw_bm_SystemMessage where (XTDM00='-1' or XTDM00='K') and YXQ000>='20120828' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',115,' )>0 ) order by XH0000 52 17:16:15 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 53 17:16:15 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 54 17:16:15 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=115 55 17:16:15 SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 56 17:16:15 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 57 17:16:15 SQL Execute: ORACLE - delete SD_SB.WZ_TEMP00 58 17:16:15 SQL Data In: ORACLE - Rows affected = 0 59 17:16:15 SQL Execute: ORACLE - Commit 60 17:16:15 SQL Data In: ORACLE - Rows affected = 0 61 17:16:15 SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 62 17:16:16 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=277 63 17:16:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='K' and (( 277= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=277 and XTDM00='K'))) 64 17:16:16 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'K$%' and A.XTDM00='K' and trim(A.MKDM00)='K$'||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 65 17:16: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 ((277= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=277 and XTDM00='0 '))) 66 17:16:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 67 17:16:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 277= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=277 and XTDM00='+ '))) 68 17:16:21 SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 69 17:16:21 SQL Execute: ORACLE - SELECT YJFLID,YJFLMC FROM BM_WZYJFL WHERE YJFLBH LIKE '1%' ORDER BY YJFLID 70 17:16:21 SQL Execute: ORACLE - select * from VW_WZ_WZPMZD where 1=1 and SFYX00='Y' and WZDMBM like '1%' order by WZDMID 71 17:16:22 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=277 and BMBH00=115 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZZDWH' 72 17:16:22 SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=277 and BMBH00=115 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZZDWH' and DBGRIN='DBGridEh1' order by LS0000 73 17:16:22 SQL Execute: ORACLE - SELECT FLBH00,TRIM(FLMC00) FLMC00,YJBH00,EJBH00,SJBH00 FROM VW_WZ_WZFL01 ORDER BY FLBH00 74 17:16:22 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='库存单位维护' order by MC0000 75 17:16:22 SQL Execute: ORACLE - select * from VW_WZ_WZPMZD where 1=1 and SFYX00='Y' order by WZDMID 76 17:16:52 SQL Execute: ORACLE - select count(1) t from dual where instr(',N,',',277,')>0