1 10:43:32 Log started for: 健康体检系统 2 10:43:32 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 10:43:32 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.26','T','MedicalExa.exe'||'+'||'健康体检系统','850','19265' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 4 10:43:32 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.26','T','MedicalExa.exe'||'+'||'健康体检系统','850','19265' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 5 10:43:32 SQL Data In: ORACLE - Rows affected = 1 6 10:43:32 SQL Prepare: ORACLE - Commit 7 10:43:32 SQL Execute: ORACLE - Commit 8 10:43:32 SQL Data In: ORACLE - Rows affected = 0 9 10:43:32 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 10:43:32 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 10:43:32 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 10:43:32 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 10:43:32 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 14 10:43:32 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 15 10:43:32 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 16 10:43:32 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 10:43:32 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.26','T','MedicalExa.exe'||'+'||'健康体检系统','1231','38739' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 18 10:43:32 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.26','T','MedicalExa.exe'||'+'||'健康体检系统','1231','38739' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 19 10:43:32 SQL Data In: ORACLE - Rows affected = 1 20 10:43:32 SQL Prepare: ORACLE - Commit 21 10:43:32 SQL Execute: ORACLE - Commit 22 10:43:32 SQL Data In: ORACLE - Rows affected = 0 23 10:43:32 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 24 10:43:32 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 25 10:43:32 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 26 10:43:32 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 27 10:43:32 SQL Prepare: ORACLE - Select SYSDATE from Dual 28 10:43:32 SQL Execute: ORACLE - Select SYSDATE from Dual 29 10:43:33 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 30 10:43:33 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 10:43:33 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 32 10:43:33 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 10:43:33 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 34 10:43:33 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 35 10:43:33 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 36 10:43:33 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 10:43:33 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 38 10:43:33 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 39 10:43:33 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)='9998')) 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)='9998')) order by b.PLXH00,a.BH0000 40 10:43:33 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)='9998')) 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)='9998')) order by b.PLXH00,a.BH0000 41 10:43:40 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='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)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 42 10:43:40 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='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)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 43 10:43:41 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 44 10:43:41 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 45 10:43:41 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 46 10:43:41 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 10:43:41 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 48 10:43:41 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 10:43:41 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 50 10:43:41 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 10:43:41 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 52 10:43:41 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 10:43:41 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')) 54 10:43:41 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')) 55 10:43:41 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3665399,476,'BZ1UQZZXW8GF5WB','T',nvl('211939357',' '),'192.168.8.26#1231:38739@MedicalExa.exe+健康体检系统',125) 56 10:43:41 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3665399,476,'BZ1UQZZXW8GF5WB','T',nvl('211939357',' '),'192.168.8.26#1231:38739@MedicalExa.exe+健康体检系统',125) 57 10:43:41 SQL Data In: ORACLE - Rows affected = 1 58 10:43:41 SQL Prepare: ORACLE - Commit 59 10:43:41 SQL Execute: ORACLE - Commit 60 10:43:41 SQL Data In: ORACLE - Rows affected = 0 61 10:43:41 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 62 10:43:41 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 63 10:43:41 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 64 10:43:41 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 65 10:43:41 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 66 10:43:41 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 67 10:43:41 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.26' 68 10:43:41 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.26' 69 10:43:41 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 70 10:43:41 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 71 10:43:41 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 72 10:43:41 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 73 10:43:41 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 74 10:43:41 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 75 10:43:41 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 76 10:43:41 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 77 10:43:42 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 78 10:43:42 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 79 10:43:42 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 80 10:43:42 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 81 10:43:42 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='T') and YXQ000>='20130627' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) 82 10:43:42 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='T') and YXQ000>='20130627' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) 83 10:43:42 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 84 10:43:42 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 85 10:43:42 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 86 10:43:42 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 87 10:43:42 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='T'))) 88 10:43:42 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='T'))) 89 10:43:42 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 90 10:43:42 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 91 10:43:42 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 '))) 92 10:43:42 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 '))) 93 10:43:42 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 94 10:43:42 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 95 10:43:42 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='+ '))) 96 10:43:42 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='+ '))) 97 10:43:42 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 98 10:43:42 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 99 10:43:42 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 100 10:43:42 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 101 10:43:42 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '476' 102 10:43:42 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '476' 103 10:43:42 SQL Prepare: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 104 10:43:42 SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 105 10:43:42 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') 106 10:43:42 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') 107 10:43:42 SQL Prepare: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 108 10:43:42 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 109 10:44:37 SQL Prepare: ORACLE - SELECT ghh000,GHID00, brblh0, brxm00, brxb00, brnl00, yje000,ssje00, ROUND ((ssje00 / decode(yje000,0,1,null,1,yje000) * 100)) zkl000 FROM(SELECT A.*,(SELECT SUM(HJJE00) FROM sf_fymx00 WHERE DJH000 IN (SELECT DJH000 FROM sf_brfy00 b WHERE B.MZID00 = A.GHID00) AND xmbh00 <> '2917') YJE000,(SELECT SUM(HJJE00) FROM SF_BRFY00 WHERE MZID00 = A.GHID00) SSJE00 FROM VW_TJ_BRXXB0 A WHERE SFYX00='Y' and nvl(DWID00,0)=0AND YYID00 = '222137' AND EXISTS(SELECT 1 FROM SF_BRFY00 WHERE MZID00=A.GHID00 AND JZDH00 <> 0 ) AND TJRQ00 >= '20130101' AND TJRQ00 <= '20130430' ) 110 10:44:37 SQL Execute: ORACLE - SELECT ghh000,GHID00, brblh0, brxm00, brxb00, brnl00, yje000,ssje00, ROUND ((ssje00 / decode(yje000,0,1,null,1,yje000) * 100)) zkl000 FROM(SELECT A.*,(SELECT SUM(HJJE00) FROM sf_fymx00 WHERE DJH000 IN (SELECT DJH000 FROM sf_brfy00 b WHERE B.MZID00 = A.GHID00) AND xmbh00 <> '2917') YJE000,(SELECT SUM(HJJE00) FROM SF_BRFY00 WHERE MZID00 = A.GHID00) SSJE00 FROM VW_TJ_BRXXB0 A WHERE SFYX00='Y' and nvl(DWID00,0)=0AND YYID00 = '222137' AND EXISTS(SELECT 1 FROM SF_BRFY00 WHERE MZID00=A.GHID00 AND JZDH00 <> 0 ) AND TJRQ00 >= '20130101' AND TJRQ00 <= '20130430' ) 111 10:45:13 SQL Prepare: ORACLE - SELECT COUNT(*) FROM BM_YYSFXM WHERE SFXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZEJMXMID') 112 10:45:13 SQL Execute: ORACLE - SELECT COUNT(*) FROM BM_YYSFXM WHERE SFXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZEJMXMID') 113 10:45:13 SQL Prepare: ORACLE - SELECT COUNT(*) FROM BM_ZLZD00 WHERE ZLXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID') 114 10:45:13 SQL Execute: ORACLE - SELECT COUNT(*) FROM BM_ZLZD00 WHERE ZLXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID') 115 10:45:13 SQL Prepare: ORACLE - SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID' 116 10:45:13 SQL Execute: ORACLE - SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID' 117 10:45:13 SQL Prepare: ORACLE - Select ZLXMJC,YJKSMC,ZJE000,ZHJE00,FJF000,ZKL000,ZKE000,XMZTMC,KDRQ00,KDYSXM,ZXRQ00,ZXYSXM from VW_TJ_YJ_YW0000 b where ZYGHID='9970480' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) UNION Select '总额减免收费项目' ZLXMJC, KDKSMC YJKSMC, 0 ZJE000,NVL(ZJE000,0) ZHJE00,0 FJF000,100 ZKL000,0 ZKE000,ZT0000 XMZTMC,KDRQ00,KDYSXM,'' ZXRQ00,'' ZXYSXM from VW_YJ_YW0000 b where ZYGHID='9970480' AND ZLXMID = '4510' 118 10:45:13 SQL Execute: ORACLE - Select ZLXMJC,YJKSMC,ZJE000,ZHJE00,FJF000,ZKL000,ZKE000,XMZTMC,KDRQ00,KDYSXM,ZXRQ00,ZXYSXM from VW_TJ_YJ_YW0000 b where ZYGHID='9970480' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) UNION Select '总额减免收费项目' ZLXMJC, KDKSMC YJKSMC, 0 ZJE000,NVL(ZJE000,0) ZHJE00,0 FJF000,100 ZKL000,0 ZKE000,ZT0000 XMZTMC,KDRQ00,KDYSXM,'' ZXRQ00,'' ZXYSXM from VW_YJ_YW0000 b where ZYGHID='9970480' AND ZLXMID = '4510' 119 10:45:32 SQL Prepare: ORACLE - SELECT COUNT(*) FROM BM_YYSFXM WHERE SFXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZEJMXMID') 120 10:45:32 SQL Execute: ORACLE - SELECT COUNT(*) FROM BM_YYSFXM WHERE SFXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZEJMXMID') 121 10:45:32 SQL Prepare: ORACLE - SELECT COUNT(*) FROM BM_ZLZD00 WHERE ZLXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID') 122 10:45:32 SQL Execute: ORACLE - SELECT COUNT(*) FROM BM_ZLZD00 WHERE ZLXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID') 123 10:45:32 SQL Prepare: ORACLE - SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID' 124 10:45:32 SQL Execute: ORACLE - SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID' 125 10:45:32 SQL Prepare: ORACLE - Select ZLXMJC,YJKSMC,ZJE000,ZHJE00,FJF000,ZKL000,ZKE000,XMZTMC,KDRQ00,KDYSXM,ZXRQ00,ZXYSXM from VW_TJ_YJ_YW0000 b where ZYGHID='9972053' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) UNION Select '总额减免收费项目' ZLXMJC, KDKSMC YJKSMC, 0 ZJE000,NVL(ZJE000,0) ZHJE00,0 FJF000,100 ZKL000,0 ZKE000,ZT0000 XMZTMC,KDRQ00,KDYSXM,'' ZXRQ00,'' ZXYSXM from VW_YJ_YW0000 b where ZYGHID='9972053' AND ZLXMID = '4510' 126 10:45:32 SQL Execute: ORACLE - Select ZLXMJC,YJKSMC,ZJE000,ZHJE00,FJF000,ZKL000,ZKE000,XMZTMC,KDRQ00,KDYSXM,ZXRQ00,ZXYSXM from VW_TJ_YJ_YW0000 b where ZYGHID='9972053' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) UNION Select '总额减免收费项目' ZLXMJC, KDKSMC YJKSMC, 0 ZJE000,NVL(ZJE000,0) ZHJE00,0 FJF000,100 ZKL000,0 ZKE000,ZT0000 XMZTMC,KDRQ00,KDYSXM,'' ZXRQ00,'' ZXYSXM from VW_YJ_YW0000 b where ZYGHID='9972053' AND ZLXMID = '4510'