1 08:14:56 Log started for: Sickberth 2 08:14:56 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 08:14:56 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','9','SickBerth.exe'||'+'||'病区护理系统','914','61417' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual 4 08:14:56 SQL Data In: ORACLE - Rows affected = 1 5 08:14:56 SQL Execute: ORACLE - Commit 6 08:14:56 SQL Data In: ORACLE - Rows affected = 0 7 08:14:56 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 08:14:56 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 08:14:56 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 10 08:14:56 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 08:14:56 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','9','SickBerth.exe'||'+'||'病区护理系统','1181','34796' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual 12 08:14:56 SQL Data In: ORACLE - Rows affected = 1 13 08:14:56 SQL Execute: ORACLE - Commit 14 08:14:56 SQL Data In: ORACLE - Rows affected = 0 15 08:14:56 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 16 08:14:56 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 17 08:14:56 SQL Execute: ORACLE - Select SYSDATE from Dual 18 08:14:56 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 19 08:14:56 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 20 08:14:56 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 21 08:14:56 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 22 08:14:56 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 23 08:14:56 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' 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 ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 24 08:15:00 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' 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='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 25 08:15:00 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114 26 08:15:00 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 27 08:15:00 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 28 08:15:00 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 29 08:15:00 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 30 08:15:00 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')) 31 08:15:04 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4738366,1114,'wlzx-3','9',nvl('231686594',' '),'192.168.5.33#1181:34796@SickBerth.exe+病区护理系统',61) 32 08:15:04 SQL Data In: ORACLE - Rows affected = 1 33 08:15:04 SQL Execute: ORACLE - Commit 34 08:15:04 SQL Data In: ORACLE - Rows affected = 0 35 08:15:04 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 61 36 08:15:04 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 37 08:15:04 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 38 08:15:04 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 39 08:15:04 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 40 08:15:04 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 61 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 41 08:15:04 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 42 08:15:04 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'9'||',')>0 43 08:15:05 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1114' and name00='SYSTEMSKIN' 44 08:15:05 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 45 08:15:05 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20150811' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',61,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='9') 46 08:15:05 SQL Execute: ORACLE - select distinct a.CZYKS0,b.BMMC00 from vw_bm_SystemMessage a,BM_BMBM00 b where a.CZYKS0=b.BMBH00 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',61,' )>0 ) and XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9') 47 08:15:05 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='消息系统字体颜色配置' 48 08:15:05 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 = 'XTXXSFJXPX' 49 08:15:05 SQL Execute: ORACLE - select * from vw_bm_SystemMessage where (XTDM00='-1' or XTDM00='9') and YXQ000>='20150811' and XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9') and (JSKSBH is null or instr( ','||JSKSBH||',' , ',61,' )>0 ) order by XH0000 50 08:15:08 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 51 08:15:08 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 52 08:15:08 SQL Execute: ORACLE - select sysdate from dual 53 08:15:08 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='9'))) 54 08:15:09 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||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 55 08:15:09 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 '))) 56 08:15:09 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 57 08:15:09 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='+ '))) 58 08:15:09 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 59 08:15:09 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 60 08:15:09 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 61 08:15:09 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 62 08:15:09 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 63 08:15:09 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 64 08:15:09 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_ZDYDY_SYHDD','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_HLJLDSFSYFR3DY','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_SFSYXXCSGN','BQ_CWXMSFTSBLSQNJWF','BQ_DYCKDSFQDYJZY','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_YZCXSJSFMRYT','BQ_TSYPYZDY_ZDY','BQ_SFSYPASSXT','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_SERVERDIRCP','YJ_JSXMSFXZ','BQ_YZZXDDYSFQB','BQ_CQYZZJSSFTXYPSL','YS_ZFBRZFBLYBLB','BQ_YLFYJY_ZYCWXM','ZY_YBDBZJSJK','BLJK_TZYZSFXYHD') 65 08:15:09 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 66 08:15:09 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet','YJ_BBCYHZDPrintSet') and YGBH00 = 1114 67 08:15:09 SQL Execute: ORACLE - select sysdate nowtime from dual 68 08:15:09 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 69 08:15:09 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 70 08:15:09 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='病区消息时间间隔' AND YXBZ00='1' and MC0000='刷新间隔' 71 08:15:09 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 72 08:15:09 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 73 08:15:09 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 74 08:15:09 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 75 08:15:09 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 76 08:15:09 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 77 08:15:09 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 78 08:15:09 SQL Execute: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 79 08:15:10 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 80 08:15:10 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 81 08:15:10 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=1114 82 08:15:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 83 08:15:10 SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00,DQLJID,YJJZE0,YBZFJE,DBZBM0,DBZMC0,A.COLOR0, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00,a.BRZJBH,a.BRNL00,a.BRDH00 , (select SF_BQ_GETBRXMXSYS(A.ZYID00) from dual) BRXMYS,XJYE00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000(+) order by b.cwxh00,RYCWH0 84 08:15:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1193793.000000 85 08:15:10 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 86 08:15:10 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 87 08:15:10 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 88 08:15:10 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1193793.000000 89 08:15:10 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 90 08:15:10 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 91 08:15:10 SQL Execute: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 92 08:15:10 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19771207) AS NL FROM DUAL 93 08:15:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1193793.000000 94 08:15:10 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 95 08:15:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1193793.000000 96 08:15:10 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 97 08:15:19 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 98 08:15:20 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 99 08:15:23 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0,SFKPGS from BQ_ZXDLB0 where DM0000='1' 100 08:15:25 SQL Execute: ORACLE - select distinct yzid00,xm0000 from VW_BQ_JRKFYK a where BQH000=61 and zyid00 in (1193793,1193798,1192860,1190283,1191638,1193546,1177019,1194022,1194026,1193886,1194029,1192985,1192138,1190789,1192852,1193045,1194191,1193288,1191484,1193140,1193906,1193898,1193908,1117031,1193795,1192891,1150869,1193986,1193135,1193589,1193559,1194234,1194186,1192851,1193790,1193903,1192743,1193058,1193896,1193636,1187245,1193807,1114121,1187713,1190588,1194038,1194027,1194025,1193786,1194017,1194008,1187263,1194023,1193784,1194236,1194034,1193891,1193899,1190897,1193792,1194018,1191904,1192858) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' ) 101 08:15:25 SQL Execute: ORACLE - Insert Into XT_XTCZRZ(CZID00,CZTable,CZLX00,CZRYBM,CZNR00,DATAID) Values(SQ_XT_XTCZRZ_ID0000.NEXTVAL,'BQ_YZCFMX',5,1114,'病区医嘱执行单打印首次打印记录：病人姓名：郑燕清 yzid00:20217957打印人员:林于',20217957) 102 08:15:25 SQL Data In: ORACLE - Rows affected = 1 103 08:15:25 SQL Execute: ORACLE - Commit 104 08:15:25 SQL Data In: ORACLE - Rows affected = 0 105 08:15:25 SQL Execute: ORACLE - Select * FROM VW_BQ_JRKFYK a where BQH000=61 and zyid00 in (1193793,1193798,1192860,1190283,1191638,1193546,1177019,1194022,1194026,1193886,1194029,1192985,1192138,1190789,1192852,1193045,1194191,1193288,1191484,1193140,1193906,1193898,1193908,1117031,1193795,1192891,1150869,1193986,1193135,1193589,1193559,1194234,1194186,1192851,1193790,1193903,1192743,1193058,1193896,1193636,1187245,1193807,1114121,1187713,1190588,1194038,1194027,1194025,1193786,1194017,1194008,1187263,1194023,1193784,1194236,1194034,1193891,1193899,1190897,1193792,1194018,1191904,1192858) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 106 08:15:28 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRKFYK where BQH000=61 and zyid00 in (1193793,1193798,1192860,1190283,1191638,1193546,1177019,1194022,1194026,1193886,1194029,1192985,1192138,1190789,1192852,1193045,1194191,1193288,1191484,1193140,1193906,1193898,1193908,1117031,1193795,1192891,1150869,1193986,1193135,1193589,1193559,1194234,1194186,1192851,1193790,1193903,1192743,1193058,1193896,1193636,1187245,1193807,1114121,1187713,1190588,1194038,1194027,1194025,1193786,1194017,1194008,1187263,1194023,1193784,1194236,1194034,1193891,1193899,1190897,1193792,1194018,1191904,1192858) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 107 08:15:29 SQL Data In: ORACLE - Rows affected = 1 108 08:15:29 SQL Execute: ORACLE - Commit 109 08:15:29 SQL Data In: ORACLE - Rows affected = 0 110 08:15:30 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 111 08:15:31 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 112 08:15:40 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 113 08:15:50 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 114 08:16:00 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 115 08:16:02 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0,SFKPGS from BQ_ZXDLB0 where DM0000='7' 116 08:16:04 SQL Execute: ORACLE - select * from VW_BQ_JRZSYZ a where BQH000=61 and zyid00 in (1193793,1193798,1192860,1190283,1191638,1193546,1177019,1194022,1194026,1193886,1194029,1192985,1192138,1190789,1192852,1193045,1194191,1193288,1191484,1193140,1193906,1193898,1193908,1117031,1193795,1192891,1150869,1193986,1193135,1193589,1193559,1194234,1194186,1192851,1193790,1193903,1192743,1193058,1193896,1193636,1187245,1193807,1114121,1187713,1190588,1194038,1194027,1194025,1193786,1194017,1194008,1187263,1194023,1193784,1194236,1194034,1193891,1193899,1190897,1193792,1194018,1191904,1192858) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) and (YFLBID=1 or YFID00 in (0)) 117 08:16:05 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (20213330,'1') 118 08:16:05 SQL Data In: ORACLE - Rows affected = 1 119 08:16:05 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (20213330,'2') 120 08:16:05 SQL Data In: ORACLE - Rows affected = 1 121 08:16:05 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (20213331,'1') 122 08:16:05 SQL Data In: ORACLE - Rows affected = 1 123 08:16:05 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (20213331,'2') 124 08:16:05 SQL Data In: ORACLE - Rows affected = 1 125 08:16:05 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (20205699,'1') 126 08:16:05 SQL Data In: ORACLE - Rows affected = 1 127 08:16:05 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (19964105,'1') 128 08:16:05 SQL Data In: ORACLE - Rows affected = 1 129 08:16:05 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (19964105,'2') 130 08:16:05 SQL Data In: ORACLE - Rows affected = 1 131 08:16:05 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (20210208,'1') 132 08:16:05 SQL Data In: ORACLE - Rows affected = 1 133 08:16:05 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (20210208,'2') 134 08:16:05 SQL Data In: ORACLE - Rows affected = 1 135 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 136 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 137 08:16:06 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 138 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 139 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 140 08:16:06 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 141 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 142 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 143 08:16:06 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 144 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 145 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 146 08:16:06 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 147 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 148 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 149 08:16:06 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 150 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 151 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 152 08:16:06 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 153 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 154 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 155 08:16:06 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 156 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 157 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 158 08:16:06 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 159 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 160 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 161 08:16:06 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 162 08:16:06 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 163 08:16:06 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 164 08:16:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 165 08:16:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 166 08:16:06 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 167 08:16:06 SQL Execute: ORACLE - select * from VW_BQ_JRZSYZ where 1=2 168 08:16:06 SQL Execute: ORACLE - select * from VW_BQ_JRZSYZ where 1=2 169 08:16:06 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00,nvl(ZB0000,'1') ZB0000 from YJ_ZLXMID_TMP t1,VW_BQ_JRZSYZ a where BQH000=61 and zyid00 in (1193793,1193798,1192860,1190283,1191638,1193546,1177019,1194022,1194026,1193886,1194029,1192985,1192138,1190789,1192852,1193045,1194191,1193288,1191484,1193140,1193906,1193898,1193908,1117031,1193795,1192891,1150869,1193986,1193135,1193589,1193559,1194234,1194186,1192851,1193790,1193903,1192743,1193058,1193896,1193636,1187245,1193807,1114121,1187713,1190588,1194038,1194027,1194025,1193786,1194017,1194008,1187263,1194023,1193784,1194236,1194034,1193891,1193899,1190897,1193792,1194018,1191904,1192858) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) and (YFLBID=1 or YFID00 in (0)) and a.YZMXID=t1.ZLXMID(+) order by Ch0000,nvl(ZB0000,'1') 170 08:16:06 SQL Execute: ORACLE - select a.* from VW_BQ_JRZSYZ a ,YJ_ZLXMID_TMP t1 where a.YZMXID=t1.ZLXMID(+) and zyid00=1177019 and BQH000=61 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) and nvl(t1.zb0000,'1')=1 order by yzid00,yzmxid 171 08:16:06 SQL Execute: ORACLE - select a.* from VW_BQ_JRZSYZ a ,YJ_ZLXMID_TMP t1 where a.YZMXID=t1.ZLXMID(+) and zyid00=1177019 and BQH000=61 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) and nvl(t1.zb0000,'1')=2 order by yzid00,yzmxid 172 08:16:06 SQL Execute: ORACLE - select a.* from VW_BQ_JRZSYZ a ,YJ_ZLXMID_TMP t1 where a.YZMXID=t1.ZLXMID(+) and zyid00=1193135 and BQH000=61 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) and nvl(t1.zb0000,'1')=1 order by yzid00,yzmxid 173 08:16:06 SQL Execute: ORACLE - select a.* from VW_BQ_JRZSYZ a ,YJ_ZLXMID_TMP t1 where a.YZMXID=t1.ZLXMID(+) and zyid00=1193636 and BQH000=61 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) and nvl(t1.zb0000,'1')=1 order by yzid00,yzmxid 174 08:16:06 SQL Execute: ORACLE - select a.* from VW_BQ_JRZSYZ a ,YJ_ZLXMID_TMP t1 where a.YZMXID=t1.ZLXMID(+) and zyid00=1193636 and BQH000=61 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) and nvl(t1.zb0000,'1')=2 order by yzid00,yzmxid 175 08:16:10 SQL Execute: ORACLE - select distinct yzid00,xm0000 from VW_BQ_JRZSYZ a where BQH000=61 and zyid00 in (1193793,1193798,1192860,1190283,1191638,1193546,1177019,1194022,1194026,1193886,1194029,1192985,1192138,1190789,1192852,1193045,1194191,1193288,1191484,1193140,1193906,1193898,1193908,1117031,1193795,1192891,1150869,1193986,1193135,1193589,1193559,1194234,1194186,1192851,1193790,1193903,1192743,1193058,1193896,1193636,1187245,1193807,1114121,1187713,1190588,1194038,1194027,1194025,1193786,1194017,1194008,1187263,1194023,1193784,1194236,1194034,1193891,1193899,1190897,1193792,1194018,1191904,1192858) and (YFLBID=1 or YFID00 in (0)) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' ) 176 08:16:10 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRZSYZ a where BQH000=61 and zyid00 in (1193793,1193798,1192860,1190283,1191638,1193546,1177019,1194022,1194026,1193886,1194029,1192985,1192138,1190789,1192852,1193045,1194191,1193288,1191484,1193140,1193906,1193898,1193908,1117031,1193795,1192891,1150869,1193986,1193135,1193589,1193559,1194234,1194186,1192851,1193790,1193903,1192743,1193058,1193896,1193636,1187245,1193807,1114121,1187713,1190588,1194038,1194027,1194025,1193786,1194017,1194008,1187263,1194023,1193784,1194236,1194034,1193891,1193899,1190897,1193792,1194018,1191904,1192858) and (YFLBID=1 or YFID00 in (0)) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 177 08:16:11 SQL Data In: ORACLE - Rows affected = 0 178 08:16:11 SQL Execute: ORACLE - delete from YJ_ZLXMID_TMP 179 08:16:11 SQL Data In: ORACLE - Rows affected = 9 180 08:16:11 SQL Execute: ORACLE - Commit 181 08:16:11 SQL Data In: ORACLE - Rows affected = 0 182 08:16:11 SQL Execute: ORACLE - Commit 183 08:16:11 SQL Data In: ORACLE - Rows affected = 0 184 08:16:11 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 185 08:16:20 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 186 08:16:30 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 187 08:16:36 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0,SFKPGS from BQ_ZXDLB0 where DM0000='13' 188 08:16:40 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 189 08:16:50 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 190 08:16:50 SQL Execute: ORACLE - select * from VW_BQ_JRWHYZ a where BQH000=61 and zyid00 in (1193793,1193798,1192860,1190283,1191638,1193546,1177019,1194022,1194026,1193886,1194029,1192985,1192138,1190789,1192852,1193045,1194191,1193288,1191484,1193140,1193906,1193898,1193908,1117031,1193795,1192891,1150869,1193986,1193135,1193589,1193559,1194234,1194186,1192851,1193790,1193903,1192743,1193058,1193896,1193636,1187245,1193807,1114121,1187713,1190588,1194038,1194027,1194025,1193786,1194017,1194008,1187263,1194023,1193784,1194236,1194034,1193891,1193899,1190897,1193792,1194018,1191904,1192858) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 191 08:17:00 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 192 08:17:10 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 193 08:17:11 SQL Execute: ORACLE - Commit 194 08:17:11 SQL Data In: ORACLE - Rows affected = 0 195 08:17:20 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 196 08:17:30 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 197 08:17:40 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 198 08:17:50 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 199 08:18:00 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 200 08:18:10 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 201 08:18:20 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 202 08:18:30 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 203 08:18:40 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 204 08:18:50 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 205 08:19:00 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 206 08:19:10 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00