1 09:46:50 Log started for: 健康体检系统 2 09:46:50 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 09:46:50 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.78','T','MedicalExa.exe'||'+'||'健康体检系统','1185','14281' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@7777:E29C9BBFA19340E701132D385F061817' from dual 4 09:46:50 SQL Execute: ORACLE - Commit 5 09:46:50 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 6 09:46:50 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 7 09:46:50 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='7777' and CZBZ00 in ('1') 8 09:46:50 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 9 09:46:50 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.78','T','MedicalExa.exe'||'+'||'健康体检系统','1142','11813' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@7777:1DCF43AAD957D4605EF05EAE810FB5BD' from dual 10 09:46:50 SQL Execute: ORACLE - Commit 11 09:46:50 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 12 09:46:50 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='7777' and CZBZ00 in ('1') 13 09:46:50 SQL Execute: ORACLE - Select SYSDATE from Dual 14 09:46:50 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 15 09:46:50 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 16 09:46:50 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 17 09:46:50 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 18 09:46: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 19 09:46: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)='7777')) 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)='7777')) order by b.PLXH00,a.BH0000 20 09:46:50 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '7777'='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)='7777')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7777') 21 09:46:50 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=370 22 09:46:50 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 23 09:46:50 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 24 09:46:50 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 25 09:46:50 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 26 09:46: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')) 27 09:46:51 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3906829,370,'网络中心','T',nvl('226748166',' '),'192.168.12.78#1142:11813@MedicalExa.exe+健康体检系统',125) 28 09:46:51 SQL Execute: ORACLE - Commit 29 09:46:51 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 30 09:46:51 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 31 09:46:51 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 32 09:46:51 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.78' 33 09:46:51 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 34 09:46: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 35 09:46:51 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 36 09:46:51 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 37 09:46:53 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='370' and name00='SYSTEMSKIN' 38 09:46:53 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 39 09:46:53 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20131219' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='T') 40 09:46:53 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 41 09:46:53 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 42 09:46:53 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 370= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=370 and XTDM00='T'))) 43 09:46: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 44 09:46: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 ((370= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=370 and XTDM00='0 '))) 45 09:46:53 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 46 09:46:53 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 370= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=370 and XTDM00='+ '))) 47 09:46:53 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 48 09:46:53 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 49 09:46:53 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '370' 50 09:46:53 SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 51 09:46:53 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') 52 09:46:53 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 53 09:47:00 SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZJTQYS' 54 09:47:08 SQL Execute: ORACLE - SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = (SELECT GHID00 FROM SF_BRXXB0 WHERE GHH000 = '6334083' AND ROWNUM = 1) 55 09:47:08 SQL Execute: ORACLE - SELECT TRIM(YYID00) FROM BM_TYDWB0 WHERE DWID00 = '674' 56 09:47:08 SQL Execute: ORACLE - select a.ghid00 from tj_brxxb0 a,sf_brxxb0 b where a.grghid=b.ghid00 and b.ghh000='6334083' 57 09:47:08 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE GHID00>0 AND GHID00=(select ghid00 from sf_brxxb0 where ghh000='6334083') 58 09:47:08 SQL Execute: ORACLE - select GRGHID from TJ_BRXXB0 where GHID00=12542064 59 09:47:08 SQL Execute: ORACLE - SELECT TRIM(NVL(LQQK00,'')) FROM TJ_BRXXB0 WHERE GHID00 = '12542064' 60 09:47:08 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3600337' 61 09:47:08 SQL Execute: ORACLE - BEGIN "SP_TJ_INSTJ_TJBG00" (PGHID00 => :PGHID00,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PYYID00 => :PYYID00); END; 62 09:47:08 SQL Execute: ORACLE - select lpad(ksbh00,5,' ')||zlxmid ksxmid,zlxmid,nvl(yjdjh0,0) yjdjh0, ksbh00,zlxmjc,xh0000,lbbh00,bgys00,CKSBH0,YYID00 ,KSLX00, JGHQFS from ( select mc0000 zlxmjc,a.ksbh00,xh0000,0 zlxmid,0 yjdjh0, DECODE(LX0000,'2','4','0') lbbh00,a.bgys00,A.CKSBH0, B.YYID00, KSLX00, NULL JGHQFS from tj_kslb00 a, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = D.ZLXMID AND ROWNUM = 1 AND BH0000 = D.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = D.KSBH00) KSLX00 from tj_tjbg00 D where ghid00=12542064) b where a.ksbh00=b.ksbh00 union select zlxmjc zlxmjc,b.ksbh00,c.xh0000,a.zlxmid,b.yjdjh0, TO_CHAR(a.lbbh00) LBBH00,c.bgys00,C.CKSBH0, B.YYID00, KSLX00, JGHQFS from bm_zlzd00 a,tj_kslb00 c, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND ROWNUM = 1 AND BH0000 = E.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = E.KSBH00) KSLX00, (SELECT JGHQFS FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND BH0000 = E.KSBH00) JGHQFS from tj_tjbg00 E where ghid00=12542064) b where a.zlxmid=b.zlxmid and b.ksbh00=c.ksbh00 AND A.ZLXMID IN (SELECT ZLXMID FROM TJ_ZHXM00 WHERE SFYX00 = 'Y') ) where 1=1 AND YYID00 = '222137' order by xh0000,ksbh00,zlxmid, yjdjh0 63 09:47:08 SQL Execute: ORACLE - select GHID00,TJJL00,TJJY00,ZJYS00,ZJYSXM,BGRQ00,FCRQ00,CZY000,CZYXM0,TJSGJL from VW_TJ_BRXXB0 where GHID00='12542064' 64 09:47:08 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'VW_TJ_TJJYB0' order by 1 ASC, 2 ASC 65 09:47:08 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'VW_TJ_TJJYB0' order by owner ASC, index_name ASC 66 09:47:08 SQL Execute: ORACLE - SELECT "ID0000", "DWID00", "BRID00", "GHID00", "GHH000", "ICD900", "JBMC00", "JY0000", "SFDDDY" FROM "VW_TJ_TJJYB0" WHERE ((("DWID00") = ('674')) AND (("BRID00") = ('3600337'))) AND (("GHID00") = ('12542064')) 67 09:47:08 SQL Execute: ORACLE - select JYJZKS,(select BMMC00 from BM_BMBM00 where BMBH00=JYJZKS) JYKSMC, JYJZYS,(select ZWXM00 from BM_YGBM00 where YGBH00=JYJZYS) JYYSXM, JYKS01,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS01) JYMC01, JYYS01,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS01) JYXM01, JYKS02,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS02) JYMC02, JYYS02,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS02) JYXM02, JYKS03,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS03) JYMC03, JYYS03,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS03) JYXM03, JYKS04,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS04) JYMC04, JYYS04,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS04) JYXM04 from TJ_BRXXB0 a where GHID00='12542064' 68 09:47:08 SQL Execute: ORACLE - select * from TJ_JKZJG0 where ghid00=12542064 69 09:47:08 SQL Execute: ORACLE - SELECT C.* FROM ( select yjdjh0,yjfzh0,a.zlxmid,b.zlxmjc,b.lbbh00,xmzt00,SL0000,YJKSBH, DECODE(XMZT00,'0','已申请','1','已计价','2','已收费','3','已执行', '6','已作废','7','已退费','D','已取消') XMZTMC, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = A.ZLXMID AND ROWNUM = 1 AND BH0000 = A.YJKSBH) YYID00 from TJ_YJDJH0 a,bm_zlzd00 b where a.zlxmid=b.zlxmid and xmzt00 in('0','1','2','6','D') and (not exists (select 'y' from yj_yw0000 c where c.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and (ghid00='12542064' or ghid00='') ) C WHERE YYID00 = '222137' 70 09:47:08 SQL Execute: ORACLE - select * from ( select SJLX00,BGID00,XSSX00,A.ZLXMID,A.YJDJH0,A.JCXMID,XXZ000,SXZ000,XXTS00,SXTS00,CKZ000,JCRQ00,SFCSTS,XMMC00,CDZ000,DW0000,JGSM00,JCYS00,JCYSXM,B.XH0000 ZLXMXH,SFJRXJ,CDMS00,ICD900,JBMC00,A.SFDY00 from VW_TJ_TJBG00_DIS A,TJ_ZHXM00 B where A.ZLXMID=B.ZLXMID AND GHID00='12542064' and A.KSBH00='34' AND A.KSBH00=B.BH0000 UNION select 'C' SJLX00,0 BGID00,0 XSSX00,A.ZLXMID,C.YJDJH0,0 JCXMID,0 XXZ000,0 SXZ000,'' XXTS00,'' SXTS00,'' CKZ000,C.JCRQ00,'' SFCSTS,B.ZLXMJC XMMC00,'' CDZ000,'' DW0000,'' JGSM00,C.JCYS00,C.JCYSXM,A.XH0000 ZLXMXH,'N' SFJRXJ,'' CDMS00,'' ICD900,'' JBMC00,'N' SFDY00 from TJ_ZHXM00 A,BM_ZLZD00 B,VW_TJ_TJBG00_DIS C WHERE C.GHID00='12542064' and C.KSBH00='34' and A.ZLXMID=B.ZLXMID AND A.ZLXMID=C.ZLXMID and A.BH0000=C.KSBH00 and ((exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is not null) or (not exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is null)) )order by ZLXMXH,ZLXMID,YJDJH0,XSSX00 71 09:47:09 SQL Execute: ORACLE - select * from TJ_TJXJB0 where GHID00='12542064' and KSBH00='34' and SFDDDY='N' 72 09:47:09 SQL Execute: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='12542064' and ksbh00='34' order by ID0000 73 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=34 and ZLXMID=3963 and YJDJH0=15924942 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 74 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=33 and ZLXMID=3963 and YJDJH0=15924942 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 75 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=38 and ZLXMID=3963 and YJDJH0=15924942 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 76 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=48 and ZLXMID=4273 and YJDJH0=15924952 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 77 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12542064 and KSBH00=48 and ZLXMID=4273 and YJDJH0=15924952 and JCRQ00 IS NOT NULL and rownum=1 78 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=50 and ZLXMID=19373 and YJDJH0=15924945 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 79 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=47 and ZLXMID=3966 and YJDJH0=15924955 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 80 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12542064 and KSBH00=47 and ZLXMID=3966 and YJDJH0=15924955 and JCRQ00 IS NOT NULL and rownum=1 81 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=3014 and YJDJH0=15924947 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 82 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=3016 and YJDJH0=15924949 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 83 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=4531 and YJDJH0=15924946 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 84 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=5207 and YJDJH0=15924944 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 85 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=17105 and YJDJH0=15924950 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 86 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=17170 and YJDJH0=15924946 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 87 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=17173 and YJDJH0=15924946 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 88 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=17207 and YJDJH0=15924950 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 89 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=22589 and YJDJH0=15924948 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 90 09:47:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=22767 and YJDJH0=15924943 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 91 09:47:11 SQL Execute: ORACLE - select * from ( select SJLX00,BGID00,XSSX00,A.ZLXMID,A.YJDJH0,A.JCXMID,XXZ000,SXZ000,XXTS00,SXTS00,CKZ000,JCRQ00,SFCSTS,XMMC00,CDZ000,DW0000,JGSM00,JCYS00,JCYSXM,B.XH0000 ZLXMXH,SFJRXJ,CDMS00,ICD900,JBMC00,A.SFDY00 from VW_TJ_TJBG00_DIS A,TJ_ZHXM00 B where A.ZLXMID=B.ZLXMID AND GHID00='12542064' and A.KSBH00='46' and A.YJDJH0='15924947' and A.ZLXMID='3014' AND A.KSBH00=B.BH0000 UNION select 'C' SJLX00,0 BGID00,0 XSSX00,A.ZLXMID,C.YJDJH0,0 JCXMID,0 XXZ000,0 SXZ000,'' XXTS00,'' SXTS00,'' CKZ000,C.JCRQ00,'' SFCSTS,B.ZLXMJC XMMC00,'' CDZ000,'' DW0000,'' JGSM00,C.JCYS00,C.JCYSXM,A.XH0000 ZLXMXH,'N' SFJRXJ,'' CDMS00,'' ICD900,'' JBMC00,'N' SFDY00 from TJ_ZHXM00 A,BM_ZLZD00 B,VW_TJ_TJBG00_DIS C WHERE C.GHID00='12542064' and C.KSBH00='46' and C.YJDJH0='15924947' and C.ZLXMID='3014' and A.ZLXMID=B.ZLXMID AND A.ZLXMID=C.ZLXMID and A.BH0000=C.KSBH00 and ((exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is not null) or (not exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is null)) )order by ZLXMXH,ZLXMID,XSSX00 92 09:47:11 SQL Execute: ORACLE - select * from TJ_TJXJB0 where GHID00='12542064' and KSBH00='46' and SFDDDY='N' 93 09:47:11 SQL Execute: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='12542064' and ksbh00='46' order by ID0000 94 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=3014 and YJDJH0=15924947 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 95 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=34 and ZLXMID=3963 and YJDJH0=15924942 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 96 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=33 and ZLXMID=3963 and YJDJH0=15924942 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 97 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=38 and ZLXMID=3963 and YJDJH0=15924942 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 98 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=48 and ZLXMID=4273 and YJDJH0=15924952 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 99 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12542064 and KSBH00=48 and ZLXMID=4273 and YJDJH0=15924952 and JCRQ00 IS NOT NULL and rownum=1 100 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=50 and ZLXMID=19373 and YJDJH0=15924945 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 101 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=47 and ZLXMID=3966 and YJDJH0=15924955 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 102 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12542064 and KSBH00=47 and ZLXMID=3966 and YJDJH0=15924955 and JCRQ00 IS NOT NULL and rownum=1 103 09:47:11 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=3014 and YJDJH0=15924947 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 104 09:47:22 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12542064 and KSBH00=46 and ZLXMID=3014 and YJDJH0=15924947 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999