1 10:41:50 Log started for: 健康体检系统 2 10:41:50 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 10:41:50 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 10:41:50 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.9','T','MedicalExa.exe'||'+'||'健康体检系统','213','24794' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@6013:0F5A22088D81756AF66B28AD29EB3F47' from dual 5 10:41:50 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.9','T','MedicalExa.exe'||'+'||'健康体检系统','213','24794' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@6013:0F5A22088D81756AF66B28AD29EB3F47' from dual 6 10:41:50 SQL Data In: ORACLE - Rows affected = 1 7 10:41:50 SQL Prepare: ORACLE - Commit 8 10:41:50 SQL Execute: ORACLE - Commit 9 10:41:50 SQL Data In: ORACLE - Rows affected = 0 10 10:41:50 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 10:41:50 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 12 10:41:50 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 10:41:50 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 14 10:41:50 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='6013' and CZBZ00 in ('1') 15 10:41:50 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='6013' and CZBZ00 in ('1') 16 10:41:50 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 10:41:50 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 18 10:41:50 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.9','T','MedicalExa.exe'||'+'||'健康体检系统','75','22690' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@6013:4E007088615D641EC4BF084801768321' from dual 19 10:41:50 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.9','T','MedicalExa.exe'||'+'||'健康体检系统','75','22690' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@6013:4E007088615D641EC4BF084801768321' from dual 20 10:41:50 SQL Data In: ORACLE - Rows affected = 1 21 10:41:50 SQL Prepare: ORACLE - Commit 22 10:41:50 SQL Execute: ORACLE - Commit 23 10:41:50 SQL Data In: ORACLE - Rows affected = 0 24 10:41:50 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 25 10:41:50 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 26 10:41:50 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='6013' and CZBZ00 in ('1') 27 10:41:50 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='6013' and CZBZ00 in ('1') 28 10:41:50 SQL Prepare: ORACLE - Select SYSDATE from Dual 29 10:41:50 SQL Execute: ORACLE - Select SYSDATE from Dual 30 10:41:50 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 10:41:50 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 32 10:41:50 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 10:41:50 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 34 10:41:50 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 35 10:41:50 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 36 10:41:50 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 10:41:50 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 10:41:50 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 10:41:50 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 10:41:50 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6013')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6013')) order by b.PLXH00,a.BH0000 41 10:41:50 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6013')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6013')) order by b.PLXH00,a.BH0000 42 10:41:50 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '6013'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6013')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6013') 43 10:41:50 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '6013'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6013')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6013') 44 10:41:50 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=979 45 10:41:50 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=979 46 10:41:50 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 10:41:50 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 10:41:50 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 10:41:50 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 10:41:50 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 10:41:50 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 52 10:41:50 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 10:41:50 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 54 10:41:50 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 10:41:50 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 10:41:51 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4188995,979,'体检中心-1','T',nvl('228115123',' '),'192.168.9.9#75:22690@MedicalExa.exe+健康体检系统',125) 57 10:41:51 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4188995,979,'体检中心-1','T',nvl('228115123',' '),'192.168.9.9#75:22690@MedicalExa.exe+健康体检系统',125) 58 10:41:51 SQL Data In: ORACLE - Rows affected = 1 59 10:41:51 SQL Prepare: ORACLE - Commit 60 10:41:51 SQL Execute: ORACLE - Commit 61 10:41:51 SQL Data In: ORACLE - Rows affected = 0 62 10:41:51 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 63 10:41:51 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 64 10:41:51 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 65 10:41:51 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 66 10:41:51 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 67 10:41:51 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 68 10:41:51 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.9' 69 10:41:51 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.9' 70 10:41:51 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 71 10:41:51 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 72 10:41:51 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 125 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 73 10:41:51 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 125 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 74 10:41:51 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 75 10:41:51 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 76 10:41:51 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 77 10:41:51 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 78 10:41:53 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='979' and name00='SYSTEMSKIN' 79 10:41:53 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='979' and name00='SYSTEMSKIN' 80 10:41:53 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 81 10:41:53 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 82 10:41:53 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140708' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='T') 83 10:41:53 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140708' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='T') 84 10:41:53 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 85 10:41:53 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 86 10:41:53 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 87 10:41:53 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 88 10:41:53 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 979= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=979 and XTDM00='T'))) 89 10:41:53 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 979= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=979 and XTDM00='T'))) 90 10:41:53 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||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 91 10:41:53 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||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 92 10:41:53 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 ((979= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=979 and XTDM00='0 '))) 93 10:41:53 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 ((979= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=979 and XTDM00='0 '))) 94 10:41:53 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 95 10:41:53 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 96 10:41:53 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 979= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=979 and XTDM00='+ '))) 97 10:41:53 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 979= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=979 and XTDM00='+ '))) 98 10:41:53 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 99 10:41:53 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 100 10:41:53 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 101 10:41:53 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 102 10:41:53 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '979' 103 10:41:53 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '979' 104 10:41:53 SQL Prepare: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 105 10:41:53 SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 106 10:41:54 SQL Prepare: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID','YS_PACSTWBGWZ','XT_PACSCJDM','YS_PACSTXLLWZ') 107 10:41:54 SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID','YS_PACSTWBGWZ','XT_PACSCJDM','YS_PACSTXLLWZ') 108 10:41:54 SQL Prepare: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 109 10:41:54 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 110 10:41:56 SQL Prepare: ORACLE - select ZGZKL0 AS ZKL000 from BM_ZKLQXB where YGBH00 = 979 111 10:41:56 SQL Execute: ORACLE - select ZGZKL0 AS ZKL000 from BM_ZKLQXB where YGBH00 = 979 112 10:42:02 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 113 10:42:02 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 114 10:42:02 SQL Prepare: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like :1) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 115 10:42:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = c% 116 10:42:02 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 117 10:42:03 SQL Prepare: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like :1) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 118 10:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = cl% 119 10:42:03 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 120 10:42:03 SQL Prepare: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like :1) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 121 10:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = cls% 122 10:42:03 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 123 10:42:04 SQL Prepare: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like :1) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 124 10:42:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = clsx% 125 10:42:04 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 126 10:42:05 SQL Prepare: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=783 127 10:42:05 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=783 128 10:42:05 SQL Prepare: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='783' 129 10:42:05 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='783' 130 10:42:05 SQL Prepare: ORACLE - select distinct BMMC00 from BM_BRXXB0 where TYDWID='783' 131 10:42:05 SQL Execute: ORACLE - select distinct BMMC00 from BM_BRXXB0 where TYDWID='783' 132 10:42:06 SQL Prepare: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000,round(100*z.zhje00/decode(z.je0000,0,1,z.je0000),0) zkl000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from (select sl0000,jzje00-FJF000 zje000,round((jzje00-FJF000)*(zhje00/decode(zje000,0,1,zje000)),2) zhje00,fjf000,zlxmid,zje000/sl0000 dj0000 from ( select a.sl0000,sum(d.jzje00) jzje00,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,a.fjf000 fjf001,(select nvl(sum(jzje00),0) from yj_ywjj00 where yjdjh0=a.yjdjh0 and FJFYBZ='Y') FJF000,a.zlxmid from TJ_YJDJH0 a,yj_ywjj00 d,tj_brxxb0 c,bm_tydwb0 e where a.yjdjh0=d.yjdjh0 and c.dwid00=e.dwid00 and not exists (select 1 from sf_brfy00 f,sf_fymx00 h where f.djh000=h.djh000 and f.brid00=e.brid00 and h.yjdjh0=a.yjdjh0) and c.dwid00='783' and c.dwtjcs='1' and c.dwid00=a.dwid00 and a.ghid00=c.ghid00 and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and a.xmzt00 in ('0','1','2') and NVL(a.SFJZ00,'N')<>'Y' group by a.sl0000,a.zje000,a.zhje00,a.FJF000,a.zlxmid,a.yjdjh0,a.yjksbh)) y group by zlxmid,zhje00,fjf000,dj0000) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid and (z.je0000<>0 or FJF000<>0) 133 10:42:06 SQL Execute: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000,round(100*z.zhje00/decode(z.je0000,0,1,z.je0000),0) zkl000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from (select sl0000,jzje00-FJF000 zje000,round((jzje00-FJF000)*(zhje00/decode(zje000,0,1,zje000)),2) zhje00,fjf000,zlxmid,zje000/sl0000 dj0000 from ( select a.sl0000,sum(d.jzje00) jzje00,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,a.fjf000 fjf001,(select nvl(sum(jzje00),0) from yj_ywjj00 where yjdjh0=a.yjdjh0 and FJFYBZ='Y') FJF000,a.zlxmid from TJ_YJDJH0 a,yj_ywjj00 d,tj_brxxb0 c,bm_tydwb0 e where a.yjdjh0=d.yjdjh0 and c.dwid00=e.dwid00 and not exists (select 1 from sf_brfy00 f,sf_fymx00 h where f.djh000=h.djh000 and f.brid00=e.brid00 and h.yjdjh0=a.yjdjh0) and c.dwid00='783' and c.dwtjcs='1' and c.dwid00=a.dwid00 and a.ghid00=c.ghid00 and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and a.xmzt00 in ('0','1','2') and NVL(a.SFJZ00,'N')<>'Y' group by a.sl0000,a.zje000,a.zhje00,a.FJF000,a.zlxmid,a.yjdjh0,a.yjksbh)) y group by zlxmid,zhje00,fjf000,dj0000) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid and (z.je0000<>0 or FJF000<>0) 134 10:42:06 SQL Prepare: ORACLE - BEGIN "SP_TJ_DWSFTJ" (PDWID00 => :PDWID00,PDWTJCS => :PDWTJCS,PTJLB00 => :PTJLB00,PJSFS00 => :PJSFS00,PJZDH00 => :PJZDH00,PDWZBID => :PDWZBID,PBMMC00 => :PBMMC00,PQSRQ00 => :PQSRQ00,PJSRQ00 => :PJSRQ00,PSFJS00 => :PSFJS00); END; 135 10:42:06 SQL Data In: ORACLE - Param = 1, Name = PDWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 783.000000 136 10:42:06 SQL Data In: ORACLE - Param = 2, Name = PDWTJCS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 137 10:42:06 SQL Data In: ORACLE - Param = 3, Name = PTJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 138 10:42:06 SQL Data In: ORACLE - Param = 4, Name = PJSFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 139 10:42:06 SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 140 10:42:06 SQL Data In: ORACLE - Param = 6, Name = PDWZBID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 141 10:42:06 SQL Data In: ORACLE - Param = 7, Name = PBMMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 142 10:42:06 SQL Data In: ORACLE - Param = 8, Name = PQSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140708 143 10:42:06 SQL Data In: ORACLE - Param = 9, Name = PJSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140708 144 10:42:06 SQL Data In: ORACLE - Param = 10, Name = PSFJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 145 10:42:06 SQL Execute: ORACLE - BEGIN "SP_TJ_DWSFTJ" (PDWID00 => :PDWID00,PDWTJCS => :PDWTJCS,PTJLB00 => :PTJLB00,PJSFS00 => :PJSFS00,PJZDH00 => :PJZDH00,PDWZBID => :PDWZBID,PBMMC00 => :PBMMC00,PQSRQ00 => :PQSRQ00,PJSRQ00 => :PJSRQ00,PSFJS00 => :PSFJS00); END; 146 10:42:06 SQL Prepare: ORACLE - commit 147 10:42:06 SQL Execute: ORACLE - commit 148 10:42:06 SQL Data In: ORACLE - Rows affected = 0 149 10:42:06 SQL Prepare: ORACLE - SELECT 0 FPXMID,'总计' XMMC00,0 SFXMID,ROUND(SUM(HJJE00),2) HJJE00,ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000,'' DJ0000,ROUND(100*SUM(ZHJE00)/SUM(HJJE00),0) ZKL000 FROM TJ_DWSFTJ WHERE SFXMID<>-1 AND DWID00='783' UNION ALL SELECT FPXMID,FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND HJJE00<>0 AND DWID00='783' UNION ALL SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(nvl(TJDJ00,ROUND(HJJE00/SL0000,3))) DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID<>-1 AND HJJE00<>0 AND DWID00='783' ORDER BY FPXMID,SFXMID 150 10:42:06 SQL Execute: ORACLE - SELECT 0 FPXMID,'总计' XMMC00,0 SFXMID,ROUND(SUM(HJJE00),2) HJJE00,ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000,'' DJ0000,ROUND(100*SUM(ZHJE00)/SUM(HJJE00),0) ZKL000 FROM TJ_DWSFTJ WHERE SFXMID<>-1 AND DWID00='783' UNION ALL SELECT FPXMID,FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND HJJE00<>0 AND DWID00='783' UNION ALL SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(nvl(TJDJ00,ROUND(HJJE00/SL0000,3))) DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID<>-1 AND HJJE00<>0 AND DWID00='783' ORDER BY FPXMID,SFXMID 151 10:42:08 SQL Prepare: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000,round(100*z.zhje00/decode(z.je0000,0,1,z.je0000),0) zkl000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from (select sl0000,jzje00-FJF000 zje000,round((jzje00-FJF000)*(zhje00/decode(zje000,0,1,zje000)),2) zhje00,fjf000,zlxmid,zje000/sl0000 dj0000 from ( select a.sl0000,sum(d.jzje00) jzje00,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,a.fjf000 fjf001,(select nvl(sum(jzje00),0) from yj_ywjj00 where yjdjh0=a.yjdjh0 and FJFYBZ='Y') FJF000,a.zlxmid from TJ_YJDJH0 a,yj_ywjj00 d,tj_brxxb0 c,bm_tydwb0 e where a.yjdjh0=d.yjdjh0 and c.dwid00=e.dwid00 and exists (select 1 from sf_brfy00 f,sf_fymx00 h where f.jzdh00+0=0 and f.djh000=h.djh000 and f.brid00=e.brid00 and h.yjdjh0=a.yjdjh0) and c.dwid00='783' and c.dwtjcs='1' and c.dwid00=a.dwid00 and a.ghid00=c.ghid00 and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and a.xmzt00 in ('2','3','D') and NVL(a.SFJZ00,'N')<>'Y' group by a.sl0000,a.zje000,a.zhje00,a.FJF000,a.zlxmid,a.yjdjh0,a.yjksbh)) y group by zlxmid,zhje00,fjf000,dj0000) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid and (z.je0000<>0 or FJF000<>0) 152 10:42:08 SQL Execute: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000,round(100*z.zhje00/decode(z.je0000,0,1,z.je0000),0) zkl000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from (select sl0000,jzje00-FJF000 zje000,round((jzje00-FJF000)*(zhje00/decode(zje000,0,1,zje000)),2) zhje00,fjf000,zlxmid,zje000/sl0000 dj0000 from ( select a.sl0000,sum(d.jzje00) jzje00,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,a.fjf000 fjf001,(select nvl(sum(jzje00),0) from yj_ywjj00 where yjdjh0=a.yjdjh0 and FJFYBZ='Y') FJF000,a.zlxmid from TJ_YJDJH0 a,yj_ywjj00 d,tj_brxxb0 c,bm_tydwb0 e where a.yjdjh0=d.yjdjh0 and c.dwid00=e.dwid00 and exists (select 1 from sf_brfy00 f,sf_fymx00 h where f.jzdh00+0=0 and f.djh000=h.djh000 and f.brid00=e.brid00 and h.yjdjh0=a.yjdjh0) and c.dwid00='783' and c.dwtjcs='1' and c.dwid00=a.dwid00 and a.ghid00=c.ghid00 and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and a.xmzt00 in ('2','3','D') and NVL(a.SFJZ00,'N')<>'Y' group by a.sl0000,a.zje000,a.zhje00,a.FJF000,a.zlxmid,a.yjdjh0,a.yjksbh)) y group by zlxmid,zhje00,fjf000,dj0000) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid and (z.je0000<>0 or FJF000<>0) 153 10:42:08 SQL Prepare: ORACLE - BEGIN "SP_TJ_DWSFTJ" (PDWID00 => :PDWID00,PDWTJCS => :PDWTJCS,PTJLB00 => :PTJLB00,PJSFS00 => :PJSFS00,PJZDH00 => :PJZDH00,PDWZBID => :PDWZBID,PBMMC00 => :PBMMC00,PQSRQ00 => :PQSRQ00,PJSRQ00 => :PJSRQ00,PSFJS00 => :PSFJS00); END; 154 10:42:08 SQL Data In: ORACLE - Param = 1, Name = PDWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 783.000000 155 10:42:08 SQL Data In: ORACLE - Param = 2, Name = PDWTJCS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 156 10:42:08 SQL Data In: ORACLE - Param = 3, Name = PTJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 157 10:42:08 SQL Data In: ORACLE - Param = 4, Name = PJSFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 158 10:42:08 SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 159 10:42:08 SQL Data In: ORACLE - Param = 6, Name = PDWZBID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 160 10:42:08 SQL Data In: ORACLE - Param = 7, Name = PBMMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 161 10:42:08 SQL Data In: ORACLE - Param = 8, Name = PQSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140708 162 10:42:08 SQL Data In: ORACLE - Param = 9, Name = PJSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140708 163 10:42:08 SQL Data In: ORACLE - Param = 10, Name = PSFJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 164 10:42:08 SQL Execute: ORACLE - BEGIN "SP_TJ_DWSFTJ" (PDWID00 => :PDWID00,PDWTJCS => :PDWTJCS,PTJLB00 => :PTJLB00,PJSFS00 => :PJSFS00,PJZDH00 => :PJZDH00,PDWZBID => :PDWZBID,PBMMC00 => :PBMMC00,PQSRQ00 => :PQSRQ00,PJSRQ00 => :PJSRQ00,PSFJS00 => :PSFJS00); END; 165 10:42:08 SQL Prepare: ORACLE - commit 166 10:42:08 SQL Execute: ORACLE - commit 167 10:42:08 SQL Data In: ORACLE - Rows affected = 0 168 10:42:08 SQL Prepare: ORACLE - SELECT 0 FPXMID,'总计' XMMC00,0 SFXMID,ROUND(SUM(HJJE00),2) HJJE00,ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000,'' DJ0000,ROUND(100*SUM(ZHJE00)/SUM(HJJE00),0) ZKL000 FROM TJ_DWSFTJ WHERE SFXMID<>-1 AND DWID00='783' UNION ALL SELECT FPXMID,FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND HJJE00<>0 AND DWID00='783' UNION ALL SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(nvl(TJDJ00,ROUND(HJJE00/SL0000,3))) DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID<>-1 AND HJJE00<>0 AND DWID00='783' ORDER BY FPXMID,SFXMID 169 10:42:08 SQL Execute: ORACLE - SELECT 0 FPXMID,'总计' XMMC00,0 SFXMID,ROUND(SUM(HJJE00),2) HJJE00,ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000,'' DJ0000,ROUND(100*SUM(ZHJE00)/SUM(HJJE00),0) ZKL000 FROM TJ_DWSFTJ WHERE SFXMID<>-1 AND DWID00='783' UNION ALL SELECT FPXMID,FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND HJJE00<>0 AND DWID00='783' UNION ALL SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(nvl(TJDJ00,ROUND(HJJE00/SL0000,3))) DJ0000,ROUND(100*ZHJE00/HJJE00,0) ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID<>-1 AND HJJE00<>0 AND DWID00='783' ORDER BY FPXMID,SFXMID 170 10:42:08 SQL Prepare: ORACLE - select NVL(sum(ZFJE00),0) ZFJE from sf_fymx00 where DJH000 in (select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='3770778' and b.xmbh00= '2917' and jzdh00 = '0') 171 10:42:08 SQL Execute: ORACLE - select NVL(sum(ZFJE00),0) ZFJE from sf_fymx00 where DJH000 in (select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='3770778' and b.xmbh00= '2917' and jzdh00 = '0')