1 16:51:59 Log started for: 固定资产核算管理系统 2 16:51:59 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','G',trim(PROGRAM)||'+'||'固定资产核算管理系统',SID,serial# ,'20090814','16:51:59','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 16:51:59 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','G',trim(PROGRAM)||'+'||'固定资产核算管理系统',SID,serial# ,'20090814','16:51:59','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 16:51:59 SQL Data In: ORACLE - Rows affected = 1 5 16:51:59 SQL Prepare: ORACLE - Commit 6 16:51:59 SQL Execute: ORACLE - Commit 7 16:51:59 SQL Data In: ORACLE - Rows affected = 0 8 16:51:59 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 16:51:59 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 16:51:59 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 11 16:51:59 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 12 16:51:59 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','G',trim(PROGRAM)||'+'||'固定资产核算管理系统',SID,serial# ,'20090814','16:51:59','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 13 16:51:59 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','G',trim(PROGRAM)||'+'||'固定资产核算管理系统',SID,serial# ,'20090814','16:51:59','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 14 16:51:59 SQL Data In: ORACLE - Rows affected = 1 15 16:51:59 SQL Prepare: ORACLE - Commit 16 16:51:59 SQL Execute: ORACLE - Commit 17 16:51:59 SQL Data In: ORACLE - Rows affected = 0 18 16:51:59 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and SID000 in (select SID000 from XT_XTLJ00 where LJRQ00=to_char(sysdate,'YYYYMMDD')) and rownum<=5000 19 16:51:59 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and SID000 in (select SID000 from XT_XTLJ00 where LJRQ00=to_char(sysdate,'YYYYMMDD')) and rownum<=5000 20 16:51:59 SQL Data In: ORACLE - Rows affected = 0 21 16:51:59 SQL Prepare: ORACLE - Commit 22 16:51:59 SQL Execute: ORACLE - Commit 23 16:51:59 SQL Data In: ORACLE - Rows affected = 0 24 16:51:59 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 25 16:51:59 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 26 16:51:59 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 27 16:51:59 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 28 16:51:59 SQL Prepare: ORACLE - Select SYSDATE from Dual 29 16:51:59 SQL Execute: ORACLE - Select SYSDATE from Dual 30 16:51:59 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 16:51:59 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 32 16:51:59 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 33 16:51:59 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 34 16:51:59 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 35 16:51:59 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 36 16:51:59 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 37 16:51:59 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 38 16:51:59 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 39 16:51:59 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 = '' 40 16:51:59 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','b') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 41 16:51:59 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','b') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 42 16:52:02 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 43 16:52:02 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 44 16:52:02 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 45 16:52:02 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 46 16:52:02 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 16:52:02 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 16:52:02 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 16:52:02 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 16:52:02 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 16:52:02 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 52 16:52:02 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 16:52:02 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 54 16:52:02 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 16:52:02 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 16:52:03 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1849638,476,'wlzx-2','G',nvl('3238360',' '),'192.168.13.206#47:415@Prj_GDZC.exe+固定资产核算管理系统',175) 57 16:52:03 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1849638,476,'wlzx-2','G',nvl('3238360',' '),'192.168.13.206#47:415@Prj_GDZC.exe+固定资产核算管理系统',175) 58 16:52:03 SQL Data In: ORACLE - Rows affected = 1 59 16:52:03 SQL Prepare: ORACLE - Commit 60 16:52:03 SQL Execute: ORACLE - Commit 61 16:52:03 SQL Data In: ORACLE - Rows affected = 0 62 16:52:03 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 175 63 16:52:03 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 175 64 16:52:03 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 65 16:52:03 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 66 16:52:03 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 67 16:52:03 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 68 16:52:03 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 175 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 69 16:52:03 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 175 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 70 16:52:03 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20090814' 71 16:52:03 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20090814' 72 16:52:03 SQL Prepare: ORACLE - select sysdate nowtime from dual 73 16:52:03 SQL Execute: ORACLE - select sysdate nowtime from dual 74 16:52:03 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 75 16:52:03 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 76 16:52:03 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 77 16:52:03 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 78 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 79 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 80 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 81 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 82 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 83 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 84 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 85 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 86 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 87 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 88 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 89 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 90 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 91 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 92 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 93 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 94 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 95 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 96 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 97 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 98 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 99 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 100 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 101 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 102 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 103 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 104 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 105 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 106 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 107 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 108 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 109 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 110 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 111 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 112 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 113 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 114 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 115 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 116 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 117 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 118 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 119 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 120 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 121 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 122 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 123 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 124 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 125 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 126 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 127 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 128 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 129 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 130 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 131 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 132 16:52:03 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 133 16:52:03 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 134 16:52:03 SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_INIT00"; END; 135 16:52:03 SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_INIT00"; END; 136 16:52:04 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 137 16:52:04 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 138 16:52:04 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||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 ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 139 16:52:04 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||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 ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 140 16:52:04 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 MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 141 16:52:04 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 MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 142 16:52:04 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 143 16:52:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 144 16:52:04 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 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=476)))) 145 16:52:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 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=476)))) 146 16:52:08 SQL Prepare: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1' or RCKBZ0='3' 147 16:52:08 SQL Execute: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1' or RCKBZ0='3' 148 16:52:08 SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.* from vw_SB_RCK000 a where (DJLX00='1' or DJLX00='3') and SHBZ00='2' and RZRQ00>='20090814' and RZRQ00<='20090814' and CKBH00=175 AND DYFKTZ='N' order by CJID00,RCKID0 149 16:52:08 SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.* from vw_SB_RCK000 a where (DJLX00='1' or DJLX00='3') and SHBZ00='2' and RZRQ00>='20090814' and RZRQ00<='20090814' and CKBH00=175 AND DYFKTZ='N' order by CJID00,RCKID0 150 16:52:13 SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.* from vw_SB_RCK000 a where (DJLX00='1' or DJLX00='3') and SHBZ00='2' and RZRQ00>='20090114' and RZRQ00<='20090814' and CKBH00=175 AND DYFKTZ='N' order by CJID00,RCKID0 151 16:52:13 SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.* from vw_SB_RCK000 a where (DJLX00='1' or DJLX00='3') and SHBZ00='2' and RZRQ00>='20090114' and RZRQ00<='20090814' and CKBH00=175 AND DYFKTZ='N' order by CJID00,RCKID0 152 16:52:14 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17506') order by RCMXID,ZFBZ00 153 16:52:14 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17506') order by RCMXID,ZFBZ00 154 16:52:14 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17513') order by RCMXID,ZFBZ00 155 16:52:14 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17513') order by RCMXID,ZFBZ00 156 16:52:14 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18104') order by RCMXID,ZFBZ00 157 16:52:14 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18104') order by RCMXID,ZFBZ00 158 16:52:14 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18503') order by RCMXID,ZFBZ00 159 16:52:14 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18503') order by RCMXID,ZFBZ00 160 16:52:16 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18103') order by RCMXID,ZFBZ00 161 16:52:16 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18103') order by RCMXID,ZFBZ00 162 16:52:17 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18101') order by RCMXID,ZFBZ00 163 16:52:17 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18101') order by RCMXID,ZFBZ00 164 16:52:17 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17903') order by RCMXID,ZFBZ00 165 16:52:17 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17903') order by RCMXID,ZFBZ00 166 16:52:18 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17902') order by RCMXID,ZFBZ00 167 16:52:18 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17902') order by RCMXID,ZFBZ00 168 16:52:19 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17514') order by RCMXID,ZFBZ00 169 16:52:19 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17514') order by RCMXID,ZFBZ00 170 16:52:19 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17513') order by RCMXID,ZFBZ00 171 16:52:19 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17513') order by RCMXID,ZFBZ00 172 16:52:19 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17512') order by RCMXID,ZFBZ00 173 16:52:19 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17512') order by RCMXID,ZFBZ00 174 16:52:19 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17511') order by RCMXID,ZFBZ00 175 16:52:19 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17511') order by RCMXID,ZFBZ00 176 16:52:19 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17510') order by RCMXID,ZFBZ00 177 16:52:19 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17510') order by RCMXID,ZFBZ00 178 16:52:20 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17509') order by RCMXID,ZFBZ00 179 16:52:20 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17509') order by RCMXID,ZFBZ00 180 16:52:20 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17508') order by RCMXID,ZFBZ00 181 16:52:20 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17508') order by RCMXID,ZFBZ00 182 16:52:20 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17507') order by RCMXID,ZFBZ00 183 16:52:20 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17507') order by RCMXID,ZFBZ00 184 16:52:20 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17506') order by RCMXID,ZFBZ00 185 16:52:20 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17506') order by RCMXID,ZFBZ00 186 16:52:20 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17505') order by RCMXID,ZFBZ00 187 16:52:20 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17505') order by RCMXID,ZFBZ00 188 16:52:27 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='13303') order by RCMXID,ZFBZ00 189 16:52:27 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='13303') order by RCMXID,ZFBZ00 190 16:52:30 SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.* from vw_SB_RCK000 a where (DJLX00='1' or DJLX00='3') and SHBZ00='2' and RZRQ00>='20090114' and RZRQ00<='20090814' and CKBH00=175 AND DYFKTZ='Y' order by CJID00,RCKID0 191 16:52:30 SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.* from vw_SB_RCK000 a where (DJLX00='1' or DJLX00='3') and SHBZ00='2' and RZRQ00>='20090114' and RZRQ00<='20090814' and CKBH00=175 AND DYFKTZ='Y' order by CJID00,RCKID0 192 16:52:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17702') order by RCMXID,ZFBZ00 193 16:52:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17702') order by RCMXID,ZFBZ00 194 16:52:32 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='20507') order by RCMXID,ZFBZ00 195 16:52:32 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='20507') order by RCMXID,ZFBZ00 196 16:52:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17403') order by RCMXID,ZFBZ00 197 16:52:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17403') order by RCMXID,ZFBZ00