1 08:49:01 Log started for: 住院收费管理系统 2 08:49:01 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 3 08:49:01 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 4 08:49:01 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 5 08:49:01 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 6 08:49:01 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 7 08:49:01 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 8 08:49:01 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','5','PrjZY_ZYSF.exe'||'+'||'住院收费管理系统','113','40872' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:0A1AF7CE587A5DD7280165C0BA14BFED' from dual 9 08:49:01 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','5','PrjZY_ZYSF.exe'||'+'||'住院收费管理系统','113','40872' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:0A1AF7CE587A5DD7280165C0BA14BFED' from dual 10 08:49:01 SQL Data In: ORACLE - Rows affected = 1 11 08:49:01 SQL Prepare: ORACLE - Commit 12 08:49:01 SQL Execute: ORACLE - Commit 13 08:49:01 SQL Data In: ORACLE - Rows affected = 0 14 08:49:01 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5' 15 08:49:01 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5' 16 08:49:01 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 17 08:49:01 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 18 08:49:01 SQL Prepare: ORACLE - Select SYSDATE from Dual 19 08:49:01 SQL Execute: ORACLE - Select SYSDATE from Dual 20 08:49:01 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 21 08:49:01 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 22 08:49:01 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 23 08:49:01 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 24 08:49:01 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 25 08:49:01 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 26 08:49:01 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 27 08:49:01 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 28 08:49:01 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 29 08:49:01 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 30 08:49:01 SQL Prepare: 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)='343')) 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)='343')) order by b.PLXH00,a.BH0000 31 08:49:01 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)='343')) 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)='343')) order by b.PLXH00,a.BH0000 32 08:49:02 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '343'='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)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 33 08:49:02 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '343'='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)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 34 08:49:02 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 35 08:49:02 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 36 08:49:02 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 08:49:02 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 08:49:02 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 39 08:49:02 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 40 08:49:02 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 41 08:49:02 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 42 08:49:02 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 43 08:49:02 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 44 08:49:02 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')) 45 08:49:02 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')) 46 08:49:03 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4201489,1143,'wlzx-1','5',nvl('228183828',' '),'192.168.5.22#113:40872@PrjZY_ZYSF.exe+住院收费管理系统',43) 47 08:49:03 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4201489,1143,'wlzx-1','5',nvl('228183828',' '),'192.168.5.22#113:40872@PrjZY_ZYSF.exe+住院收费管理系统',43) 48 08:49:03 SQL Data In: ORACLE - Rows affected = 1 49 08:49:03 SQL Prepare: ORACLE - Commit 50 08:49:03 SQL Execute: ORACLE - Commit 51 08:49:03 SQL Data In: ORACLE - Rows affected = 0 52 08:49:03 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 53 08:49:03 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 54 08:49:03 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 55 08:49:03 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 56 08:49:03 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 57 08:49:03 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 58 08:49:03 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 59 08:49:03 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 60 08:49:03 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 61 08:49:03 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 62 08:49:03 SQL Prepare: 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 63 08:49:03 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 64 08:49:03 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 65 08:49:03 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 66 08:49:03 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'5'||',')>0 67 08:49:03 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'5'||',')>0 68 08:49:05 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 69 08:49:05 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 70 08:49:05 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 71 08:49:05 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 72 08:49:05 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140717' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',43,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='5') 73 08:49:05 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140717' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',43,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='5') 74 08:49:05 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 75 08:49:05 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 76 08:49:05 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 77 08:49:05 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 78 08:49:05 SQL Prepare: 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' 79 08:49:05 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' 80 08:49:05 SQL Prepare: ORACLE - select sysdate nowtime from dual 81 08:49:05 SQL Execute: ORACLE - select sysdate nowtime from dual 82 08:49:05 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 1143 83 08:49:05 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 1143 84 08:49:05 SQL Prepare: 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') 85 08:49:05 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') 86 08:49:05 SQL Prepare: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 87 08:49:05 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 88 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_SFYDDYJ' 89 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_SFYDDYJ' 90 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_BASYDYZDYST' 91 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_BASYDYZDYST' 92 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 93 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 94 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY' 95 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY' 96 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS' 97 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS' 98 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY' 99 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY' 100 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY' 101 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY' 102 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD' 103 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD' 104 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS' 105 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS' 106 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS' 107 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS' 108 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW' 109 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW' 110 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM' 111 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM' 112 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY' 113 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY' 114 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY' 115 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY' 116 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY' 117 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY' 118 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD' 119 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD' 120 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD' 121 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD' 122 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH' 123 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH' 124 08:49:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL' 125 08:49:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL' 126 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE' 127 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE' 128 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD' 129 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD' 130 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE' 131 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE' 132 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL' 133 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL' 134 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX' 135 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX' 136 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB' 137 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB' 138 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 139 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 140 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 141 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 142 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 143 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 144 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP' 145 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP' 146 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP' 147 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP' 148 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD' 149 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD' 150 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR' 151 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR' 152 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM' 153 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM' 154 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS' 155 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS' 156 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 157 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 158 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 159 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 160 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY' 161 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY' 162 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ' 163 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ' 164 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE' 165 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE' 166 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00' 167 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00' 168 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ' 169 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ' 170 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY' 171 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY' 172 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ' 173 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ' 174 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM' 175 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM' 176 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM' 177 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM' 178 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY' 179 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY' 180 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL' 181 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL' 182 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ' 183 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ' 184 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ' 185 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ' 186 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK' 187 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK' 188 08:49:06 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 189 08:49:06 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 190 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB' 191 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB' 192 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH' 193 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH' 194 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR' 195 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR' 196 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY' 197 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY' 198 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR' 199 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR' 200 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF' 201 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF' 202 08:49:06 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE' 203 08:49:06 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE' 204 08:49:06 SQL Prepare: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL30' order by YBYLZD 205 08:49:06 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL30' order by YBYLZD 206 08:49:06 SQL Prepare: 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') 207 08:49:06 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') 208 08:49:06 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='5' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='5'))) 209 08:49:06 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='5' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='5'))) 210 08:49:07 SQL Prepare: 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 211 08:49: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 212 08:49:07 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 213 08:49:07 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 214 08:49:07 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 215 08:49:07 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 216 08:49:07 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 217 08:49:07 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 218 08:49:08 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 219 08:49:08 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 220 08:49:08 SQL Prepare: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 221 08:49: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' 222 08:49:08 SQL Data In: ORACLE - Rows affected = 0 223 08:49:08 SQL Prepare: ORACLE - Commit 224 08:49:08 SQL Execute: ORACLE - Commit 225 08:49:08 SQL Data In: ORACLE - Rows affected = 0 226 08:49:27 SQL Prepare: ORACLE - select * from ic_ybbrlb where yblb00 <> '0' 227 08:49:27 SQL Execute: ORACLE - select * from ic_ybbrlb where yblb00 <> '0' 228 08:49:27 SQL Prepare: ORACLE - select * from bm_ybbrlb 229 08:49:27 SQL Execute: ORACLE - select * from bm_ybbrlb 230 08:49:27 SQL Prepare: ORACLE - select * from bm_ybbrlb 231 08:49:27 SQL Execute: ORACLE - select * from bm_ybbrlb 232 08:49:28 SQL Prepare: ORACLE - select * from XT_YYXX00 where 1=1 233 08:49:28 SQL Execute: ORACLE - select * from XT_YYXX00 where 1=1 234 08:49:46 SQL Prepare: ORACLE - BEGIN "SP_ZY_YBBRJS_BB0000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJLB00 => :AS_TJLB00,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,as_BRYBZX => :as_BRYBZX,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFDZX0 => :as_SFDZX0,as_WSQK00 => :as_WSQK00,as_SFKCGF => :as_SFKCGF); END; 235 08:49:46 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140711 236 08:49:46 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140711 237 08:49:46 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:00:00 238 08:49:46 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:02:59 239 08:49:46 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 240 08:49:46 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 241 08:49:46 SQL Data In: ORACLE - Param = 7, Name = AS_TJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 242 08:49:46 SQL Data In: ORACLE - Param = 8, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 243 08:49:46 SQL Data In: ORACLE - Param = 9, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 244 08:49:46 SQL Data In: ORACLE - Param = 10, Name = AS_ZTJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 245 08:49:46 SQL Data In: ORACLE - Param = 11, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 246 08:49:46 SQL Data In: ORACLE - Param = 12, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 247 08:49:46 SQL Data In: ORACLE - Param = 13, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 248 08:49:46 SQL Data In: ORACLE - Param = 14, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 249 08:49:46 SQL Data In: ORACLE - Param = 15, Name = as_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 250 08:49:46 SQL Data In: ORACLE - Param = 16, Name = as_WSQK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 251 08:49:46 SQL Data In: ORACLE - Param = 17, Name = as_SFKCGF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 252 08:49:46 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_BB0000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJLB00 => :AS_TJLB00,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,as_BRYBZX => :as_BRYBZX,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFDZX0 => :as_SFDZX0,as_WSQK00 => :as_WSQK00,as_SFKCGF => :as_SFKCGF); END; 253 08:49:46 SQL Prepare: ORACLE - select a.GHRQ00 as YBMC00,a.GHKS02 as YGBH00,a.BEIZHU as CZYXM0,GHKS30 as RS0000, a.GHKS88 as HJJE00, a.XMHJ00 as YBXJ00,a.GHKS03 as ZFJE00,a.GHKS04 as GRZHZF,a.GHKS05 as TCJJZF,a.GHKS06 as SBGRZH, a.GHKS07 as SBTCJJ,a.GHKS08 as JZJE00,a.GHKS09 as JMJE00, a.GHKS11 as ZYTS00,a.GHKS13 as JJZFE0,a.GHKS14 as SYBXZF,a.GHKS15 as SBZFE0,a.GHKS16 as BJZFE0,a.GHKS19 as GWYBZ0, a.GHKS21 as YPWQZF,a.GHKS22 as XMWQZF,a.GHKS23 as YPBFZF,a.GHKS24 as XMBFZF,a.GHKS25 as YPFY00,a.GHKS26 as mzjzje,a.GHKS27 as yyzfje,GHKS28 as QZFJE0,GHKS29 as BFQZF0 from BM_GHKSTJ a where a.id0000=:1 and a.DYID00=1 order by a.GHKS02,a.GHRQ00 254 08:49:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1762679.000000 255 08:49:46 SQL Execute: ORACLE - select a.GHRQ00 as YBMC00,a.GHKS02 as YGBH00,a.BEIZHU as CZYXM0,GHKS30 as RS0000, a.GHKS88 as HJJE00, a.XMHJ00 as YBXJ00,a.GHKS03 as ZFJE00,a.GHKS04 as GRZHZF,a.GHKS05 as TCJJZF,a.GHKS06 as SBGRZH, a.GHKS07 as SBTCJJ,a.GHKS08 as JZJE00,a.GHKS09 as JMJE00, a.GHKS11 as ZYTS00,a.GHKS13 as JJZFE0,a.GHKS14 as SYBXZF,a.GHKS15 as SBZFE0,a.GHKS16 as BJZFE0,a.GHKS19 as GWYBZ0, a.GHKS21 as YPWQZF,a.GHKS22 as XMWQZF,a.GHKS23 as YPBFZF,a.GHKS24 as XMBFZF,a.GHKS25 as YPFY00,a.GHKS26 as mzjzje,a.GHKS27 as yyzfje,GHKS28 as QZFJE0,GHKS29 as BFQZF0 from BM_GHKSTJ a where a.id0000=? and a.DYID00=1 order by a.GHKS02,a.GHRQ00 256 08:49:47 SQL Prepare: ORACLE - BEGIN "SP_ZY_YBBRJS_JSTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_BQMC00 => :AS_BQMC00,AS_YBMC00 => :AS_YBMC00,AS_JZR000 => :AS_JZR000,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,as_BRYBZX => :as_BRYBZX,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFDZX0 => :as_SFDZX0,as_WSQK00 => :as_WSQK00); END; 257 08:49:47 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140711 258 08:49:47 SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:00:00 259 08:49:47 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140711 260 08:49:47 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:02:59 261 08:49:47 SQL Data In: ORACLE - Param = 5, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 262 08:49:47 SQL Data In: ORACLE - Param = 6, Name = AS_YBMC00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 所有医保病人 263 08:49:47 SQL Data In: ORACLE - Param = 7, Name = AS_JZR000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 所有记帐人 264 08:49:47 SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 265 08:49:47 SQL Data In: ORACLE - Param = 9, Name = AS_ZTJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 266 08:49:47 SQL Data In: ORACLE - Param = 10, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 267 08:49:47 SQL Data In: ORACLE - Param = 11, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 268 08:49:47 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 269 08:49:47 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 270 08:49:47 SQL Data In: ORACLE - Param = 14, Name = as_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 271 08:49:47 SQL Data In: ORACLE - Param = 15, Name = as_WSQK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 272 08:49:47 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_JSTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_BQMC00 => :AS_BQMC00,AS_YBMC00 => :AS_YBMC00,AS_JZR000 => :AS_JZR000,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,as_BRYBZX => :as_BRYBZX,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFDZX0 => :as_SFDZX0,as_WSQK00 => :as_WSQK00); END; 273 08:49:47 SQL Prepare: ORACLE - BEGIN "SP_ZY_YBBRJS_DBZTJB" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_BRYBZX => :AS_BRYBZX,AS_YBZXMC => :AS_YBZXMC,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_TJFS00 => :AS_TJFS00,AS_SFDZX0 => :AS_SFDZX0,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_WSQK00 => :as_WSQK00); END; 274 08:49:47 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140711 275 08:49:47 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140711 276 08:49:47 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:00:00 277 08:49:47 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:02:59 278 08:49:47 SQL Data In: ORACLE - Param = 5, Name = AS_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 279 08:49:47 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 所有医保病人 280 08:49:47 SQL Data In: ORACLE - Param = 7, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 281 08:49:47 SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 282 08:49:47 SQL Data In: ORACLE - Param = 9, Name = AS_TJFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 283 08:49:47 SQL Data In: ORACLE - Param = 10, Name = AS_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 284 08:49:47 SQL Data In: ORACLE - Param = 11, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 285 08:49:47 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 286 08:49:47 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 287 08:49:47 SQL Data In: ORACLE - Param = 14, Name = as_WSQK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 288 08:49:47 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_DBZTJB" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_BRYBZX => :AS_BRYBZX,AS_YBZXMC => :AS_YBZXMC,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_TJFS00 => :AS_TJFS00,AS_SFDZX0 => :AS_SFDZX0,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_WSQK00 => :as_WSQK00); END; 289 08:49:55 SQL Prepare: ORACLE - select a.GHRQ00 as YBMC00,GHKS30 as RS0000, a.GHKS88 as HJJE00, a.XMHJ00 as YBXJ00,a.GHKS03 as ZFJE00,a.GHKS04 as GRZHZF,a.GHKS05 as TCJJZF,a.GHKS06 as SBGRZH, a.GHKS07 as SBTCJJ,a.GHKS08 as JZJE00,a.GHKS09 as JMJE00, a.GHKS11 as ZYTS00,a.GHKS13 as JJZFE0,a.GHKS14 as SYBXZF,a.GHKS15 as SBZFE0,a.GHKS16 as BJZFE0,a.GHKS19 as GWYBZ0, a.GHKS21 as YPWQZF,a.GHKS22 as XMWQZF,a.GHKS23 as YPBFZF,a.GHKS24 as XMBFZF,a.GHKS25 as YPFY00,a.GHKS26 as mzjzje,a.GHKS27 as yyzfje,GHKS28 as QZFJE0,GHKS29 as BFQZF0 from BM_GHKSTJ a where a.id0000=:1 and a.DYID00=5 order by a.GHKS02,a.GHRQ00 290 08:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1762679.000000 291 08:49:55 SQL Execute: ORACLE - select a.GHRQ00 as YBMC00,GHKS30 as RS0000, a.GHKS88 as HJJE00, a.XMHJ00 as YBXJ00,a.GHKS03 as ZFJE00,a.GHKS04 as GRZHZF,a.GHKS05 as TCJJZF,a.GHKS06 as SBGRZH, a.GHKS07 as SBTCJJ,a.GHKS08 as JZJE00,a.GHKS09 as JMJE00, a.GHKS11 as ZYTS00,a.GHKS13 as JJZFE0,a.GHKS14 as SYBXZF,a.GHKS15 as SBZFE0,a.GHKS16 as BJZFE0,a.GHKS19 as GWYBZ0, a.GHKS21 as YPWQZF,a.GHKS22 as XMWQZF,a.GHKS23 as YPBFZF,a.GHKS24 as XMBFZF,a.GHKS25 as YPFY00,a.GHKS26 as mzjzje,a.GHKS27 as yyzfje,GHKS28 as QZFJE0,GHKS29 as BFQZF0 from BM_GHKSTJ a where a.id0000=? and a.DYID00=5 order by a.GHKS02,a.GHRQ00