1 10:46:59 Log started for: 住院收费管理系统 2 10:46:59 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 10:46:59 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.2.135','5','PrjZY_ZYSF.exe'||'+'||'住院收费管理系统','2115','17155' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@403:DA0EAE149D09996EA79567577DAFEB94' from dual 4 10:46:59 SQL Data In: ORACLE - Rows affected = 1 5 10:46:59 SQL Execute: ORACLE - Commit 6 10:46:59 SQL Data In: ORACLE - Rows affected = 0 7 10:46:59 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 10:46:59 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221094' 9 10:46:59 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='403' and CZBZ00 in ('1') 10 10:47:06 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 10:47:06 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.2.135','5','PrjZY_ZYSF.exe'||'+'||'住院收费管理系统','1854','2479' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@4030:71A885C3B8C509A0742B427A03ED4FB3' from dual 12 10:47:06 SQL Data In: ORACLE - Rows affected = 1 13 10:47:06 SQL Execute: ORACLE - Commit 14 10:47:06 SQL Data In: ORACLE - Rows affected = 0 15 10:47:06 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 16 10:47:06 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221094' 17 10:47:06 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='4030' and CZBZ00 in ('1') 18 10:47:06 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 19 10:47:06 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.2.135','5','PrjZY_ZYSF.exe'||'+'||'住院收费管理系统','1990','31064' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@4030:FF68EB33EAD6C3D787519661E9EBCA11' from dual 20 10:47:06 SQL Data In: ORACLE - Rows affected = 1 21 10:47:06 SQL Execute: ORACLE - Commit 22 10:47:06 SQL Data In: ORACLE - Rows affected = 0 23 10:47:06 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5' 24 10:47:06 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='4030' and CZBZ00 in ('1') 25 10:47:06 SQL Execute: ORACLE - Select SYSDATE from Dual 26 10:47:06 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 27 10:47:06 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 28 10:47:06 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 29 10:47:06 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 30 10:47:06 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 = 'SLE4442' 31 10:47:06 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 = 'YB-MMRK' 32 10:47:06 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 = 'YB-SBK' 33 10:47:06 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)='4030')) 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)='4030')) order by b.PLXH00,a.BH0000 34 10:47:06 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '4030'='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)='4030')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4030') 35 10:47:06 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=161 36 10:47:06 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 10:47:06 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 38 10:47:06 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 39 10:47:06 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 40 10:47:06 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')) 41 10:47:06 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3261427,161,'病案02','5',nvl('2907759',' '),'192.168.2.135#1990:31064@PrjZY_ZYSF.exe+住院收费管理系统',45) 42 10:47:06 SQL Data In: ORACLE - Rows affected = 1 43 10:47:06 SQL Execute: ORACLE - Commit 44 10:47:06 SQL Data In: ORACLE - Rows affected = 0 45 10:47:06 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 46 10:47:06 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221094' 47 10:47:06 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 48 10:47:06 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.2.135' 49 10:47:06 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 50 10:47:06 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 51 10:47:06 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221094') 52 10:47:06 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'5'||',')>0 53 10:47:07 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='161' and name00='SYSTEMSKIN' 54 10:47:07 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 55 10:47:07 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20130625' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',45,' )>0 ) 56 10:47:07 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 57 10:47:07 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 58 10:47:07 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' 59 10:47:07 SQL Execute: ORACLE - select sysdate nowtime from dual 60 10:47:07 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 161 61 10:47:07 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') 62 10:47:07 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 63 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_SFYDDYJ' 64 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_BASYDYZDYST' 65 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 66 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY' 67 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS' 68 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY' 69 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY' 70 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD' 71 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS' 72 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS' 73 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW' 74 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM' 75 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY' 76 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY' 77 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY' 78 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD' 79 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD' 80 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH' 81 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL' 82 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE' 83 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD' 84 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE' 85 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL' 86 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX' 87 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB' 88 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 89 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 90 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 91 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP' 92 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP' 93 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD' 94 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR' 95 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM' 96 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS' 97 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 98 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 99 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY' 100 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ' 101 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE' 102 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00' 103 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ' 104 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY' 105 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ' 106 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM' 107 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM' 108 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY' 109 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL' 110 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ' 111 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ' 112 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK' 113 10:47:07 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 114 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB' 115 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH' 116 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR' 117 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY' 118 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR' 119 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF' 120 10:47:07 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE' 121 10:47:07 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' order by YBYLZD 122 10:47:07 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','SF_YBSFFSYYTS') 123 10:47:07 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='5' and (( 161= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=161 and XTDM00='5'))) 124 10:47:07 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 125 10:47:08 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 ((161= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=161 and XTDM00='0 '))) 126 10:47:08 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 127 10:47:08 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 161= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=161 and XTDM00='+ '))) 128 10:47:08 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 129 10:47:08 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' 130 10:47:08 SQL Data In: ORACLE - Rows affected = 0 131 10:47:08 SQL Execute: ORACLE - Commit 132 10:47:08 SQL Data In: ORACLE - Rows affected = 0 133 10:47:20 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 134 10:47:20 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 135 10:47:20 SQL Execute: ORACLE - select * from vw_bm_brfbb0 136 10:47:20 SQL Execute: ORACLE - select BMMC00,BMBH00 from BM_BMBM00 where BMXZ00='9' and Flag00='1' order by BMBH00 137 10:48:01 SQL Execute: ORACLE - select C.BMMC00 DQBQMC,Trim(replace(B.CYXJ00,chr(10),'$')) CYXJ00,B.XM0000 BRXM00,A.*,B.*,D.YBMC00,E.FBMC00 RYFBMC,F.YZCS00,F.YZYBJE,D.SFXNH0, (select decode(count(*),0,0,1) bafsbz from zy_basyxx f where f.zyid00=B.zyid00 and f.fscgbz='1' ) BAFSBZ, (select decode(count(*),0,0,1) zdlrbz from bq_brzdxx g where g.zyid00=B.zyid00 and g.zdlb00='3' ) ZDLRBZ, (select YSZJHM from bm_ygbm00 where ygbh00=decode(B.ZZYS00,0,B.SXYS00,B.ZZYS00)) YSZJHM,(select bmmc00 from bm_bmbm00 where bmbh00=b.rybq00) RYBQMC from VW_SF_BRXX00 A, ZY_BRXXB0 B,bm_bmbm00 C,IC_YBBRLB D,BM_BRFBB0 E,ZY_BRZHXX F where A.BRID00 = B.BRID00 and B.DQBQ00 = C.BMBH00 and B.YBLB00 = D.YBLB00 and B.FBBH00 = D.FBBH00 and B.FBBH00 = E.FBBH00 AND A.BRID00 = F.BRID00 and A.MRN000 = '1303207' ORDER BY B.ZYID00 desc 138 10:48:03 SQL Execute: ORACLE - select ssbh00,ssmc00,ssrq00,mzbabh mzbh00,a.mzmc00,rownum from bq_ssmzxx a,bm_mzzd00 b where Trim(substr(a.MZBH00,INSTR(';'||a.MZBH00,';',-1),4)) =b.mzbh00(+) and a.ZYID00=1274547 and rownum<=8 order by id0000