1 10:58:02 Log started for: Sickberth 2 10:58:02 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 10:58:02 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20110315','10:58:02','scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 10:58:02 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20110315','10:58:02','scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 5 10:58:02 SQL Prepare: ORACLE - Commit 6 10:58:02 SQL Execute: ORACLE - Commit 7 10:58:02 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 10:58:02 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 10:58:02 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 10 10:58:02 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 11 10:58:02 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 12 10:58:02 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 13 10:58:03 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20110315','10:58:02','sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 14 10:58:03 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20110315','10:58:02','sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 15 10:58:03 SQL Prepare: ORACLE - Commit 16 10:58:03 SQL Execute: ORACLE - Commit 17 10:58:03 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 18 10:58:03 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 19 10:58:03 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 20 10:58:03 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 21 10:58:03 SQL Prepare: ORACLE - Select SYSDATE from Dual 22 10:58:03 SQL Execute: ORACLE - Select SYSDATE from Dual 23 10:58:03 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 24 10:58:03 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 25 10:58:03 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 26 10:58:03 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 27 10:58:03 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 28 10:58:03 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 29 10:58:03 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 30 10:58:03 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 31 10:58:03 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 32 10:58:03 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 33 10:58:03 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' 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 ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 34 10:58:03 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' 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 ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 35 10:58:08 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' 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='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 36 10:58:08 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' 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='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 37 10:58:09 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 38 10:58:09 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 39 10:58:09 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 40 10:58:09 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 41 10:58:09 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 42 10:58:09 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 43 10:58:09 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 44 10:58:09 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 45 10:58:09 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 46 10:58:09 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 47 10:58:09 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')) 48 10:58: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')) 49 10:58:09 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2454953,476,'wlzx-2','9',nvl('4390993',' '),'192.168.15.15#92:9000@SickBerth.exe+病区护理系统',56) 50 10:58:09 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2454953,476,'wlzx-2','9',nvl('4390993',' '),'192.168.15.15#92:9000@SickBerth.exe+病区护理系统',56) 51 10:58:09 SQL Prepare: ORACLE - Commit 52 10:58:09 SQL Execute: ORACLE - Commit 53 10:58:09 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 56 54 10:58:09 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 56 55 10:58:09 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 56 10:58:09 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 57 10:58:09 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 58 10:58:09 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 59 10:58:09 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 60 10:58:09 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 61 10:58:09 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 62 10:58:09 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 63 10:58:09 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 56 and FLAG00 like '%' order by decode(CKBH00,21 --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 64 10:58:09 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 56 and FLAG00 like '%' order by decode(CKBH00,21 --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 65 10:58:09 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 66 10:58:09 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 67 10:58:09 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 68 10:58:09 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 69 10:58:10 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 70 10:58:10 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 71 10:58:10 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20110315' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',56,' )>0 ) 72 10:58:10 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20110315' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',56,' )>0 ) 73 10:58:10 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 74 10:58:10 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 75 10:58:10 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 76 10:58:10 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 77 10:58:10 SQL Prepare: ORACLE - select sysdate from dual 78 10:58:10 SQL Execute: ORACLE - select sysdate from dual 79 10:58:10 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='9'))) 80 10:58:10 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='9'))) 81 10:58:10 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||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 82 10:58:10 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||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 83 10:58:10 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 84 10:58: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 '))) 85 10:58:10 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 86 10:58:10 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 87 10:58:10 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 88 10:58: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='+ '))) 89 10:58:10 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 90 10:58:10 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 91 10:58:10 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 92 10:58:10 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 93 10:58:10 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 94 10:58:10 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 95 10:58:10 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 96 10:58:10 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 97 10:58:10 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 98 10:58:10 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 99 10:58:10 SQL Prepare: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 100 10:58:10 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 101 10:58:10 SQL Prepare: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_HLJLDSFSYFR3DY','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_SFSYXXCSGN','BQ_CWXMSFTSBLSQNJWF','BQ_DYCKDSFQDYJZY','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_YZCXSJSFMRYT','BQ_TSYPYZDY_ZDY','BQ_SFSYPASSXT','ZS_YZWHSFKZCJKS') 102 10:58:10 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_HLJLDSFSYFR3DY','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_SFSYXXCSGN','BQ_CWXMSFTSBLSQNJWF','BQ_DYCKDSFQDYJZY','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_YZCXSJSFMRYT','BQ_TSYPYZDY_ZDY','BQ_SFSYPASSXT','ZS_YZWHSFKZCJKS') 103 10:58:11 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet') and YGBH00 = 476 104 10:58:11 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet') and YGBH00 = 476 105 10:58:11 SQL Prepare: ORACLE - select sysdate nowtime from dual 106 10:58:11 SQL Execute: ORACLE - select sysdate nowtime from dual 107 10:58:11 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 108 10:58:11 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 109 10:58:11 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 110 10:58:11 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 111 10:58:11 SQL Prepare: ORACLE - select * from VW_BQ_YZLB00 112 10:58:11 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 113 10:58:11 SQL Prepare: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 114 10:58:11 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 115 10:58:11 SQL Prepare: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=476 116 10:58:11 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=476 117 10:58:11 SQL Prepare: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = :1 and a.rycwh0=b.ch0000 order by b.cwxh00,RYCWH0 118 10:58:11 SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000 order by b.cwxh00,RYCWH0 119 10:59:16 SQL Prepare: ORACLE - select zyh000,rycwh0,xm0000,jflbmc,zye000,ykzye0, KYJE00,jflbid,brid00,YBMC00,YBQFBZ,YBZFBL, tyje00,bjje00, decode(sfdj00,'0','正常','1','冻结','停用')"sfdj00", YBYJS0,YBYZF0,YBZHYE,YJJE00,WJSJE0, DECODE(QRFYZE,null,0,QRFYZE) QRFYZE,FYLJ00 from VW_BQ_YBZHXX where substr(brzt00,1,1)='2' and dqbq00=:1 and sfdj00='0' --and ykzye0+yxqfje+YBZFJE-tyje00<=bjje00 and Kyje00 '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 151 10:59:44 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 152 10:59:44 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' 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 ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 153 10:59:44 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' 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 ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 154 10:59:46 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' 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='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 155 10:59:46 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' 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='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 156 10:59:47 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 157 10:59:47 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 158 10:59:47 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 159 10:59:47 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 160 10:59:47 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 161 10:59:47 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 162 10:59:47 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 163 10:59:47 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 164 10:59:47 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 165 10:59:47 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 166 10:59:47 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')) 167 10:59:47 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')) 168 10:59:47 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2486861,476,'wlzx-2','9',nvl('3555162',' '),'192.168.15.15#417:4853@SickBerth.exe+病区护理系统',60) 169 10:59:47 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2486861,476,'wlzx-2','9',nvl('3555162',' '),'192.168.15.15#417:4853@SickBerth.exe+病区护理系统',60) 170 10:59:47 SQL Prepare: ORACLE - Commit 171 10:59:47 SQL Execute: ORACLE - Commit 172 10:59:47 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 60 173 10:59:47 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 60 174 10:59:47 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 175 10:59:47 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 176 10:59:47 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 177 10:59:47 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 178 10:59:47 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 179 10:59:47 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 180 10:59:47 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 181 10:59:47 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 182 10:59:47 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 60 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 183 10:59:47 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 60 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 184 10:59:47 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 185 10:59:47 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 186 10:59:47 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 187 10:59:47 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 188 10:59:47 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 189 10:59:47 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 190 10:59:47 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20110315' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',60,' )>0 ) 191 10:59:47 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20110315' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',60,' )>0 ) 192 10:59:47 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 193 10:59:47 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 194 10:59:47 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 195 10:59:47 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 196 10:59:47 SQL Prepare: ORACLE - select sysdate from dual 197 10:59:47 SQL Execute: ORACLE - select sysdate from dual 198 10:59:47 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='9'))) 199 10:59:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='9'))) 200 10:59:47 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||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 201 10:59:47 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||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 202 10:59:47 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 203 10:59:47 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 '))) 204 10:59:47 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 205 10:59:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 206 10:59:47 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 207 10:59:47 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='+ '))) 208 10:59:48 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 209 10:59:48 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 210 10:59:48 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 211 10:59:48 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 212 10:59:48 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 213 10:59:48 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 214 10:59:48 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 215 10:59:48 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 216 10:59:48 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 217 10:59:48 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 218 10:59:48 SQL Prepare: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 219 10:59:48 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 220 10:59:48 SQL Prepare: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_HLJLDSFSYFR3DY','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_SFSYXXCSGN','BQ_CWXMSFTSBLSQNJWF','BQ_DYCKDSFQDYJZY','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_YZCXSJSFMRYT','BQ_TSYPYZDY_ZDY','BQ_SFSYPASSXT','ZS_YZWHSFKZCJKS') 221 10:59:48 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_HLJLDSFSYFR3DY','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_SFSYXXCSGN','BQ_CWXMSFTSBLSQNJWF','BQ_DYCKDSFQDYJZY','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_YZCXSJSFMRYT','BQ_TSYPYZDY_ZDY','BQ_SFSYPASSXT','ZS_YZWHSFKZCJKS') 222 10:59:48 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet') and YGBH00 = 476 223 10:59:48 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet') and YGBH00 = 476 224 10:59:48 SQL Prepare: ORACLE - select sysdate nowtime from dual 225 10:59:48 SQL Execute: ORACLE - select sysdate nowtime from dual 226 10:59:48 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 227 10:59:48 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 228 10:59:48 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 229 10:59:48 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 230 10:59:48 SQL Prepare: ORACLE - select * from VW_BQ_YZLB00 231 10:59:48 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 232 10:59:48 SQL Prepare: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 233 10:59:48 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 234 10:59:48 SQL Prepare: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=476 235 10:59:48 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=476 236 10:59:48 SQL Prepare: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = :1 and a.rycwh0=b.ch0000 order by b.cwxh00,RYCWH0 237 10:59:48 SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000 order by b.cwxh00,RYCWH0 238 10:59:50 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 239 10:59:50 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 240 10:59:50 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19300301) AS NL FROM DUAL 241 10:59:50 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19300301) AS NL FROM DUAL 242 10:59:50 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 243 10:59:50 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 244 11:00:03 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 245 11:00:03 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 246 11:00:03 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19250301) AS NL FROM DUAL 247 11:00:03 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19250301) AS NL FROM DUAL 248 11:00:03 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 249 11:00:03 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 250 11:00:03 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 251 11:00:03 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 252 11:00:03 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19300301) AS NL FROM DUAL 253 11:00:03 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19300301) AS NL FROM DUAL 254 11:00:03 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 255 11:00:03 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 256 11:00:11 SQL Prepare: ORACLE - select * from vw_gy_kswply where QLRQ00 BETWEEN :1 AND :2 and (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) AND (QLKSBH=:3 or (QLKSBH in (select KSH000 from BM_BQKS00 where BQH000=:4)) ) order by QLKSMC,QLDH00 257 11:00:11 SQL Execute: ORACLE - select * from vw_gy_kswply where QLRQ00 BETWEEN ? AND ? and (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) AND (QLKSBH=? or (QLKSBH in (select KSH000 from BM_BQKS00 where BQH000=?)) ) order by QLKSMC,QLDH00 258 11:00:11 SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1 order by wpxz00 259 11:00:11 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 260 11:00:13 SQL Prepare: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks 261 11:00:13 SQL Execute: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks 262 11:00:14 SQL Prepare: ORACLE - select BMXZ00,BMBH00,BMMC00 from BM_BMBM00 where BMBH00=60 union select b.BMXZ00,b.BMBH00,b.BMMC00 from BM_BQKS00 a,BM_BMBM00 b where a.bqh000=60 and a.ksh000=b.bmbh00 order by BMXZ00,BMMC00 263 11:00:14 SQL Execute: ORACLE - select BMXZ00,BMBH00,BMMC00 from BM_BMBM00 where BMBH00=60 union select b.BMXZ00,b.BMBH00,b.BMMC00 from BM_BQKS00 a,BM_BMBM00 b where a.bqh000=60 and a.ksh000=b.bmbh00 order by BMXZ00,BMMC00 264 11:00:14 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='GY_WPLYLB' 265 11:00:14 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='GY_WPLYLB' 266 11:00:14 SQL Prepare: ORACLE - select ID0000,WPBH00,WPMC00,WPGG00,WPDW00,WPDJ00,WPXZ00, TO_CHAR(qlsl00) qlsl00,qldh00,qlsl00*wpdj00 zje000 from vw_gy_wplymx where qldh00=:1 order by wpxz00 267 11:00:14 SQL Execute: ORACLE - select ID0000,WPBH00,WPMC00,WPGG00,WPDW00,WPDJ00,WPXZ00, TO_CHAR(qlsl00) qlsl00,qldh00,qlsl00*wpdj00 zje000 from vw_gy_wplymx where qldh00=? order by wpxz00 268 11:00:15 SQL Prepare: ORACLE - SELECT * FROM vw_gy_kslywh where bmbh00='60' ORDER BY WPBH00 269 11:00:15 SQL Execute: ORACLE - SELECT * FROM vw_gy_kslywh where bmbh00='60' ORDER BY WPBH00 270 11:00:16 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 271 11:00:16 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 272 11:00:16 SQL Prepare: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00 from vw_gy_wpbm00 where (PYSM00 Like :1 or WPBH00 Like :2) and( 1=1 ) Order By WPBH00,PYSM00) where Rownum<=32 273 11:00:16 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00 from vw_gy_wpbm00 where (PYSM00 Like ? or WPBH00 Like ?) and( 1=1 ) Order By WPBH00,PYSM00) where Rownum<=32