1 09:13:12 Log started for: 住院收费管理系统 2 09:13:12 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','5','PrjZY_ZYSF.exe'||'+'||'住院收费管理系统','920','56028' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual 3 09:13:12 SQL Data In: ORACLE - Rows affected = 1 4 09:13:12 SQL Execute: ORACLE - Commit 5 09:13:12 SQL Data In: ORACLE - Rows affected = 0 6 09:13:12 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 7 09:13:13 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 8 09:13:13 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 9 09:13:13 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 10 09:13:13 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','5','PrjZY_ZYSF.exe'||'+'||'住院收费管理系统','1206','44984' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual 11 09:13:13 SQL Data In: ORACLE - Rows affected = 1 12 09:13:13 SQL Execute: ORACLE - Commit 13 09:13:13 SQL Data In: ORACLE - Rows affected = 0 14 09:13:13 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5' 15 09:13:13 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 16 09:13:13 SQL Execute: ORACLE - Select SYSDATE from Dual 17 09:13:13 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 18 09:13:13 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 19 09:13:13 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 20 09:13:13 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 21 09:13:13 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 22 09:13:13 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('4') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 23 09:13:14 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '5' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 24 09:13:14 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114 25 09:13:14 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 26 09:13:14 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 27 09:13:14 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 28 09:13:14 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 29 09:13:14 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')) 30 09:13:18 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4698560,1114,'wlzx-3','5',nvl('231396416',' '),'192.168.5.33#1206:44984@PrjZY_ZYSF.exe+住院收费管理系统',43) 31 09:13:18 SQL Data In: ORACLE - Rows affected = 1 32 09:13:18 SQL Execute: ORACLE - Commit 33 09:13:18 SQL Data In: ORACLE - Rows affected = 0 34 09:13:18 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 35 09:13:18 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 36 09:13:18 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 37 09:13:18 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 38 09:13:18 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 39 09:13:18 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 40 09:13:18 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 41 09:13:18 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'5'||',')>0 42 09:13:20 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1114' and name00='SYSTEMSKIN' 43 09:13:20 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 44 09:13:20 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20150713' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',43,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='5') 45 09:13:20 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 46 09:13:20 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 47 09:13:25 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 48 09:13:25 SQL Execute: ORACLE - select sysdate nowtime from dual 49 09:13:25 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 1114 50 09:13:25 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_PJHSC0','ZY_MRNZYH','ZY_DYYBFP','XT_JEQZ00','SF_ZHTYJE','SF_ZHBJJE','ZY_YBJSTKD','ZY_SFYJS0_BZ0000','ZY_WJZBNCY','ZY_PRINTSCALE','ZY_XTDBQX','ZY_XTQFQX','ZY_QXCYQX','ZY_TKPAR0_CZY000','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_YTFSFYXCY','SF_SFSYJZK','ZY_TJKSSJ','ZY_TJJSSJ','SF_YBBRXB','ZY_FPWidth','ZY_FPHeigh','ZY_ZYSFJJBSJ','ZY_SYDJKYDBQF','ZY_PJLYXYLYQR','XT_QDXXZHYE','XT_QDXXZHYE_LX','ZY_JKDSFTD','ZY_JKSFAJJBSJ','ZY_ZYJKDGS0','ZY_YJJDJGS','ZY_YBRQDFS','IC_YBYYJKLM','ZY_RYDJSFFZ','ZY_YBBRZFXMFS','SF_ZY_SFZDXS','SF_SFCFFP','ZY_FPTOP','ZY_SFFSXM','ZY_YBFPBH','ZY_SFQZGSYB','ZY_RQDGSCS','YF_ZYFJF_YPNM00','YF_CFMXJE_CZFS','XT_XYCYTCF','ZY_JMXMFS','ZY_EJBBSFCF','ZY_EJBBCFLS','ZY_EJBBCFHS','ZY_CYBRQFMXBB_SFCF','ZY_CYBRQFMXBBLS','ZY_CYBRQFMXBBHS','YF_CFMXJE_SRWS','YF_CFZJE_CZFS','ZY_RQDFPXMSFDY','SF_GFBRJKBXSRDW','YF_CFZJE_SRWS_YB','YF_CFZJE_SRWS','XT_ZYXTSFSYZLK','ZY_ZYXTSFSYZLK',+'YF_CFZJE_CZFS_YB','ZY_RQDMX0_ZFHB','ZY_ZYDJBLHPB','ZY_ZYHSFZDSC','XT_JKTQSJ','ZY_CXJSSFDYDJ','ZY_YBRYSFSYDT','ZY_DYQBFP','ZY_FPLEFT','ZY_SFDYZLD','XT_TFXYSHBZ','ZY_RYDJTCTS','ZY_YJJGS0_SFDYYE','YF_AutoMatch','ZY_SFHHXMMX','ZY_SFDYTKTZS','ZY_JSTKAYJJFS','ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','ZY_SFDYBASY','ZY_SFDYJZD','ZY_FBZHXTYZ','ZY_SFMHEYJKD','ZY_NPYBCYJSXSYBZHZF','ZYSF_TDXMTDKS_YXQF','ZY_CRYTJSFAKS','ZY_PJWLYBNSY','ZY_PRINTBASYZDY','ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS','ZY_ZYFPSFXSFYBF','ZY_QDDYGJBMXSFS','ZY_JSBBSFXSJCJE','ZY_YYBRSFYWFY','BQ_YBCYSFBXLRCYZD','ZY_YBCYJSHZDCSBASY','ZY_JZSRKSSRSFCF','ZY_JZSRKSSRSFZDZTJKD','ZY_YBJKSFJHZHDK','ZY_YBCXJZRQ','ZY_YBFSKSMCZDHZS','ZYSF_RYDJMS','ZYSF_RYDJMRBQ','ZYSF_RYDJMRKS','ZY_WSZBRSFKYXGRYXX','BQ_HLGZLTJSXZDY','BQ_KHLGZLTJZDYID','ZY_JKJZSJSZHZ') 51 09:13:25 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 52 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_SFYDDYJ' 53 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_BASYDYZDYST' 54 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 55 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY' 56 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS' 57 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY' 58 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY' 59 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD' 60 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS' 61 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS' 62 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW' 63 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM' 64 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY' 65 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY' 66 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY' 67 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD' 68 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD' 69 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH' 70 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL' 71 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE' 72 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD' 73 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE' 74 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL' 75 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX' 76 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB' 77 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 78 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 79 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 80 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP' 81 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP' 82 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD' 83 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR' 84 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM' 85 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS' 86 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 87 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 88 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY' 89 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ' 90 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE' 91 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00' 92 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ' 93 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY' 94 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ' 95 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM' 96 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM' 97 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY' 98 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL' 99 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ' 100 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ' 101 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK' 102 09:13:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 103 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB' 104 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH' 105 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR' 106 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY' 107 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR' 108 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF' 109 09:13:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE' 110 09:13:25 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL30' order by YBYLZD 111 09:13:25 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('ZY_CSBSYBFPSFFKCL','ZY_PRINTYYFYMXZZDY','ZY_WCKSFYXCYJS','ZY_SFQYBASYCSJK','ZY_SFYJKTJ_SFCF','ZY_SFYJKTJLS','ZY_SFYJKTJHS','ZY_YXLFYZFBRCYJS','ZY_QDHZSHTSDY','ZY_ZYYSJZSRXSCYRS','ZY_NHBRSFCSJBZD','ZY_JKJHSFXSJKDH','ZY_ZYBRSFKYZHBRID','ZY_BASYNHBRSFCSICKH','ZY_FPRQDYSFXSDYRQ','ZY_XNHBRSFCSICKH','ZY_YJJYHKTCSFYXJTC','ZY_RYDJZDCSDBJE','ZY_YJJSKSFXSYLMXZ','ZY_SZCYBRSFKYRY','ZY_BRLDTJ_BQ_KS','ZY_YJJYEMXBTITLE','ZY_JKRQXSSFALNYYFS','ZY_NHBRSFFSCYDJRQ','ZY_NBBRXB','ZY_QDDYSFMRQTDYJ','ZY_YBJSRBBSFXSCZYB','ZY_ZFZYBXMTSSB','ZY_JKRQSFGBCXGJKRQ','ZY_ZFBRXB','ZY_BASY_LEFTPAGE','ZY_BASY_TOPPAGE','ZY_PJJHYJJSFXSCXLL','SF_MZFPPDSFXYBR','ZY_CYJSTKAYJJ','ZY_JKDYFWSFYZTYZDZ','ZY_FZFZYBSFXZ','ZY_FPTHBJXX','ZY_NHBRSFMRXM','ZY_FYGZJSSFTSJX','SF_SFSYSFXMZMYHJM','ZY_YBFBZHLBBTSFTS','ZY_YJJSKDJXSZLCK','ZY_SZCYBRTJDYFS','ZY_YJJCKDGS','ZY_ZYBRFBXGYB','ZY_FPSFDYGWYJE','ZY_XNHCSLX','ZY_JKDSFSYFR3XS','ZY_YBFSRYKSSFSYBQ','ZY_GFMZFYWJSSFYXRY','ZY_SFBKGFBR','ZY_BRCYJSTS','ZY_XNHFZXMC','ZY_ZYRQDHZJMJE','ZY_ZYBRXXWFSBASFBHXNH','ZY_XNHBRSFXSYBZHJE','ZY_HSFPJGS','ZY_CYJSSFTSSNBBR','ZY_QDDYSFGJNRCDZDHH','ZY_KZMZFBBRCFFP','ZY_YBBRCYJSSFBCWJ','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM','ZY_SFSYPANHJK') 112 09:13:25 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='5' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='5'))) 113 09:13:26 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||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 114 09:13:26 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 ((1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='0 '))) 115 09:13:26 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 116 09:13:26 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='+ '))) 117 09:13:26 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 118 09:13:26 SQL Execute: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 119 09:13:26 SQL Data In: ORACLE - Rows affected = 0 120 09:13:26 SQL Execute: ORACLE - Commit 121 09:13:26 SQL Data In: ORACLE - Rows affected = 0 122 09:13:34 SQL Execute: ORACLE - select * from bm_bmbm00 where BMXZ00 = '9' and flag00='1' 123 09:13:34 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='医保入院类别对应' order by decode(nvl(xsxh00,0),0,BH0000,XSXH00) 124 09:13:34 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='入院途径' AND YXBZ00='1' order by XSXH00 125 09:13:39 SQL Execute: ORACLE - select CHQZ00 from BM_BMBM00 where BMMC00='六病区' 126 09:13:39 SQL Execute: ORACLE - select sq_ZY_BRXXB0_LS_id0000.nextval ID0000 from dual 127 09:13:39 SQL Execute: ORACLE - delete from zy_brxxb0_ls 128 09:13:39 SQL Data In: ORACLE - Rows affected = 0 129 09:13:39 SQL Execute: ORACLE - insert into zy_brxxb0_ls value ( ZYID00,BRID00,mrn000,zyh000,ybzyh0, xm0000,xb0000,cyrq00,cysj00,ryrq00, rysj00,ryczy0,ryzd00,rysqk0,rylb00, rybq00,rzks00,rycwh0,dqbq00,dqks00, zzys00,zzysxm,zrys00,zrysxm,sxys00, sxysxm,brrycs,brzt00,csrq00,fbbh00, LBBH00,CZYXM0,YBBRLB,YBLB00,id0000) select ZYID00,BRID00,mrn000,zyh000,ybzyh0, xm0000,xb0000,cyrq00,cysj00,ryrq00, rysj00,ryczy0,ryzd00,rysqk0,rylb00, rybq00,rzks00,rycwh0,dqbq00,dqks00, zzys00,zzysxm,zrys00,zrysxm,sxys00, sxysxm,brrycs,brzt00,csrq00,fbbh00, LBBH00,CZYXM0,YBBRLB,YBLB00,10192 from zy_brxxb0 where substr(brzt00,1,1) in('2','3') and dqbq00 = 60 130 09:13:39 SQL Data In: ORACLE - Rows affected = 110 131 09:13:39 SQL Execute: ORACLE - commit 132 09:13:39 SQL Data In: ORACLE - Rows affected = 0 133 09:13:39 SQL Execute: ORACLE - select A.ZYID00,A.BRID00,A.MRN000,A.ZYH000,A.YBZYH0,A.XM0000,A.XB0000,A.FBBH00,A.FBMC00,A.CYRQ00, A.CYSJ00,A.RYRQ00,A.RYSJ00,A.RYCZY0,A.RYCZYM,A.RYZD00,A.RYSQK0,A.RYLB00,A.RYBQ00,A.RZKS00,A.RYCWH0, A.DQBQ00,A.DQBQMC,A.DQKS00,A.DQKSMC,A.ZZYS00,A.ZZYSXM,A.ZRYS00,A.ZRYSXM,A.SXYS00,A.SXYSXM,A.BRRYCS, A.ZYZHID,A.JFLBID,A.JFLBMC,A.SFDJ00,A.KHRQ00,A.KHSJ00,A.CZYBH0,A.CZYXM0,A.YJZJE0,A.WJSJE0,A.XJYE00, A.ZZYE00,A.ZYE000,A.YKZYE0,A.WSFCFE,A.WSFYJE,A.BJJE00,A.TYJE00,A.YXQFJE,A.KL0000,A.BRZT00,A.YBYJS0,A.YBYZF0,A.SJZYE0, B.RYTJ00 from VW_ZY_BRZHCJ A ,ZY_BRXXB0 B where A.ZYID00=B.ZYID00 AND 1 = 1 and (NVL(A.ZYE000,0)+NVL(A.YBYZF0,0)-NVL(A.WSFCFE,0)-NVL(A.WSFYJE,0)) <= BJJE00 and A.dqbq00 = 60 and A.id0000=10192 order by A.dqbq00 134 09:13:48 SQL Execute: ORACLE - SELECT A.ZYID00,A.BRID00,A.MRN000,A.ZYH000,A.YBZYH0,A.XM0000,A.XB0000,A.FBBH00,A.FBMC00,A.CYRQ00, A.CYSJ00,A.RYRQ00,A.RYSJ00,A.RYCZY0,A.RYCZYM,A.RYZD00,A.RYSQK0,A.RYLB00,A.RYBQ00,A.RZKS00,A.RYCWH0, A.DQBQ00,A.DQBQMC,A.DQKS00,A.DQKSMC,A.ZZYS00,A.ZZYSXM,A.ZRYS00,A.ZRYSXM,A.SXYS00,A.SXYSXM,A.BRRYCS, A.ZYZHID,A.JFLBID,A.JFLBMC,A.SFDJ00,A.KHRQ00,A.KHSJ00,A.CZYBH0,A.CZYXM0,A.YJZJE0,A.WJSJE0,A.XJYE00, A.ZZYE00,A.ZYE000,A.YKZYE0,A.WSFCFE,A.WSFYJE,A.BJJE00,A.TYJE00,A.YXQFJE,A.KL0000,A.BRZT00,A.YBYJS0,A.YBYZF0,A.SJZYE0, B.RYTJ00 FROM VW_ZY_BRZHCJ A ,ZY_BRXXB0 B WHERE A.ZYID00=B.ZYID00 AND 1 = 1 AND (NVL(A.ZYE000,0)+NVL(A.YBYZF0,0)-NVL(A.WSFCFE,0)-NVL(A.WSFYJE,0)) <= BJJE00 AND A.DQBQ00 = 60 AND A.ID0000=10192 ORDER BY A.RYCWH0