1 08:15:12 Log started for: 健康体检系统 2 08:15:12 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 08:15:12 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.252','T','MedicalExa.exe'||'+'||'健康体检系统','416','18431' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 4 08:15:12 SQL Execute: ORACLE - Commit 5 08:15:12 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 6 08:15:12 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 7 08:15:12 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 8 08:15:12 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 9 08:15:12 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.252','T','MedicalExa.exe'||'+'||'健康体检系统','890','44454' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 10 08:15:12 SQL Execute: ORACLE - Commit 11 08:15:12 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 12 08:15:12 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 13 08:15:12 SQL Execute: ORACLE - Select SYSDATE from Dual 14 08:15:12 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 15 08:15:12 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 16 08:15:12 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 17 08:15:12 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 18 08:15:12 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 19 08:15:12 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 20 08:15:20 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 21 08:15:20 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 22 08:15:20 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 23 08:15:20 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 24 08:15:20 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 25 08:15:20 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 26 08:15:20 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 27 08:15:20 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3029902,476,'clyytest','T',nvl('38310672',' '),'192.168.9.252#890:44454@MedicalExa.exe+健康体检系统',125) 28 08:15:20 SQL Execute: ORACLE - Commit 29 08:15:20 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 30 08:15:20 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 31 08:15:20 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 32 08:15:20 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 33 08:15:20 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 34 08:15:20 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 125 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 35 08:15:20 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 36 08:15:20 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 37 08:15:21 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 38 08:15:21 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 39 08:15:21 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='T') and YXQ000>='20120507' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) 40 08:15:21 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 41 08:15:21 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 42 08:15:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='T'))) 43 08:15:21 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 44 08:15:21 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 ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 45 08:15:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 46 08:15:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 47 08:15:21 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 48 08:15:21 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 49 08:15:21 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '476' 50 08:15:21 SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 51 08:15:21 SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID') 52 08:15:21 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 53 08:15:46 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 54 08:15:46 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 55 08:15:48 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '222137' ) Order By DWBH00,PY0000) where Rownum<=1000 56 08:15:53 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=35 57 08:15:53 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='35' 58 08:15:53 SQL Execute: ORACLE - select distinct BMMC00 from BM_BRXXB0 where TYDWID='35' 59 08:15:53 SQL Execute: ORACLE - select BRID00 from BM_TYDWB0 where DWID00='35' 60 08:15:53 SQL Execute: ORACLE - select MAX(MZID00) from SF_BRFY00 where BRID00=687396 61 08:15:53 SQL Execute: ORACLE - select * from (select JZDH00||'|'||JZRQ00 JZDHRQ,JZDH00,JZRQ00 from SF_JZB000 a,SF_PJSYQK b where a.BRID00=687396 and MZID00=2154380 and a.PJH000=b.PJH000 and b.SFDY00='Y' AND NOT EXISTS(SELECT 1 FROM SF_JZB000 WHERE CXJZDH = A.JZDH00 and pjh000=a.pjh000 ) ) order by JZRQ00 62 08:15:53 SQL Execute: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000, decode(z.je0000, 0, 0, ROUND(100 * z.zhje00 / z.je0000, 0)) ZKL000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,sum(zje000)/sum(sl0000) dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from (select a.sl0000,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,nvl(a.FJF000,0) FJF000,a.zlxmid from TJ_YJDJH0 a where a.YJDJH0 in (select distinct e.YJDJH0 from SF_BRFY00 d,SF_FYMX00 e,TJ_YJDJH0 c where d.JZDH00='900213' and d.DJH000=e.DJH000 and e.yjdjh0=c.yjdjh0 and d.djh000=c.sfdjh0 ) and a.dwid00='35' and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) ) y group by zlxmid ) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid 63 08:15:54 SQL Execute: ORACLE - BEGIN "SP_TJ_DWSFTJ" (PDWID00 => :PDWID00,PDWTJCS => :PDWTJCS,PTJLB00 => :PTJLB00,PJSFS00 => :PJSFS00,PJZDH00 => :PJZDH00,PDWZBID => :PDWZBID,PBMMC00 => :PBMMC00,PQSRQ00 => :PQSRQ00,PJSRQ00 => :PJSRQ00,PSFJS00 => :PSFJS00); END; 64 08:15:54 SQL Execute: ORACLE - SELECT 0 FPXMID,'总计' XMMC00, 0 SFXMID, ROUND(SUM(HJJE00),2) HJJE00, ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000, '' DJ0000, ROUND(SUM(ZHJE00)/SUM(HJJE00),2)*100 ZKL000 FROM TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00 = '35' UNION SELECT FPXMID, FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND DWID00='35' UNION SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000),TO_CHAR(ROUND(HJJE00/SL0000,3)) DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00='35' ORDER BY FPXMID, SFXMID 65 08:15:54 SQL Execute: ORACLE - select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='687396' and b.xmbh00= '2917' and JZDH00 ='900213' 66 08:15:54 SQL Execute: ORACLE - Select NVL(sum(HJJE00),0) ZKE000 FROM sf_fymx00 WHERE DJH000 = '23281301' 67 08:15:54 SQL Execute: ORACLE - select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='687396' and b.xmbh00= '2917' and JZDH00 ='900213' 68 08:15:54 SQL Execute: ORACLE - Select NVL(sum(HJJE00),0) ZKE000 FROM sf_fymx00 WHERE DJH000 = '23281301' 69 08:15:58 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=35 70 08:15:58 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='35' 71 08:15:58 SQL Execute: ORACLE - select distinct BMMC00 from BM_BRXXB0 where TYDWID='35' 72 08:15:58 SQL Execute: ORACLE - select BRID00 from BM_TYDWB0 where DWID00='35' 73 08:15:58 SQL Execute: ORACLE - select MAX(MZID00) from SF_BRFY00 where BRID00=687396 74 08:15:58 SQL Execute: ORACLE - select * from (select JZDH00||'|'||JZRQ00 JZDHRQ,JZDH00,JZRQ00 from SF_JZB000 a,SF_PJSYQK b where a.BRID00=687396 and MZID00=2154380 and a.PJH000=b.PJH000 and b.SFDY00='Y' AND NOT EXISTS(SELECT 1 FROM SF_JZB000 WHERE CXJZDH = A.JZDH00 and pjh000=a.pjh000 ) ) order by JZRQ00 75 08:15:58 SQL Execute: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000, decode(z.je0000, 0, 0, ROUND(100 * z.zhje00 / z.je0000, 0)) ZKL000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,sum(zje000)/sum(sl0000) dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from (select a.sl0000,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,nvl(a.FJF000,0) FJF000,a.zlxmid from TJ_YJDJH0 a where a.YJDJH0 in (select distinct e.YJDJH0 from SF_BRFY00 d,SF_FYMX00 e,TJ_YJDJH0 c where d.JZDH00='900213' and d.DJH000=e.DJH000 and e.yjdjh0=c.yjdjh0 and d.djh000=c.sfdjh0 ) and a.dwid00='35' and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) ) y group by zlxmid ) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid 76 08:15:59 SQL Execute: ORACLE - BEGIN "SP_TJ_DWSFTJ" (PDWID00 => :PDWID00,PDWTJCS => :PDWTJCS,PTJLB00 => :PTJLB00,PJSFS00 => :PJSFS00,PJZDH00 => :PJZDH00,PDWZBID => :PDWZBID,PBMMC00 => :PBMMC00,PQSRQ00 => :PQSRQ00,PJSRQ00 => :PJSRQ00,PSFJS00 => :PSFJS00); END; 77 08:15:59 SQL Execute: ORACLE - SELECT 0 FPXMID,'总计' XMMC00, 0 SFXMID, ROUND(SUM(HJJE00),2) HJJE00, ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000, '' DJ0000, ROUND(SUM(ZHJE00)/SUM(HJJE00),2)*100 ZKL000 FROM TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00 = '35' UNION SELECT FPXMID, FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND DWID00='35' UNION SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000),TO_CHAR(ROUND(HJJE00/SL0000,3)) DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00='35' ORDER BY FPXMID, SFXMID 78 08:15:59 SQL Execute: ORACLE - select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='687396' and b.xmbh00= '2917' and JZDH00 ='900213' 79 08:15:59 SQL Execute: ORACLE - Select NVL(sum(HJJE00),0) ZKE000 FROM sf_fymx00 WHERE DJH000 = '23281301' 80 08:15:59 SQL Execute: ORACLE - select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='687396' and b.xmbh00= '2917' and JZDH00 ='900213' 81 08:15:59 SQL Execute: ORACLE - Select NVL(sum(HJJE00),0) ZKE000 FROM sf_fymx00 WHERE DJH000 = '23281301' 82 08:15:59 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 83 08:15:59 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 84 08:15:59 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 85 08:15:59 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 86 08:16:00 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 87 08:16:00 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 88 08:16:00 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '222137' ) Order By DWBH00,PY0000) where Rownum<=1000 89 08:16:01 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 90 08:16:01 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 91 08:16:01 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 92 08:16:01 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=1000 93 08:16:02 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=247 94 08:16:02 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='247' 95 08:16:02 SQL Execute: ORACLE - select distinct BMMC00 from BM_BRXXB0 where TYDWID='247' 96 08:16:02 SQL Execute: ORACLE - select BRID00 from BM_TYDWB0 where DWID00='247' 97 08:16:02 SQL Execute: ORACLE - select MAX(MZID00) from SF_BRFY00 where BRID00=832372 98 08:16:03 SQL Execute: ORACLE - select * from (select JZDH00||'|'||JZRQ00 JZDHRQ,JZDH00,JZRQ00 from SF_JZB000 a,SF_PJSYQK b where a.BRID00=832372 and MZID00=2596797 and a.PJH000=b.PJH000 and b.SFDY00='Y' AND NOT EXISTS(SELECT 1 FROM SF_JZB000 WHERE CXJZDH = A.JZDH00 and pjh000=a.pjh000 ) ) order by JZRQ00 99 08:16:03 SQL Execute: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000, decode(z.je0000, 0, 0, ROUND(100 * z.zhje00 / z.je0000, 0)) ZKL000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,sum(zje000)/sum(sl0000) dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from (select a.sl0000,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,nvl(a.FJF000,0) FJF000,a.zlxmid from TJ_YJDJH0 a where a.YJDJH0 in (select distinct e.YJDJH0 from SF_BRFY00 d,SF_FYMX00 e,TJ_YJDJH0 c where d.JZDH00='470822' and d.DJH000=e.DJH000 and e.yjdjh0=c.yjdjh0 and d.djh000=c.sfdjh0 ) and a.dwid00='247' and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) ) y group by zlxmid ) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid 100 08:16:09 SQL Execute: ORACLE - BEGIN "SP_TJ_DWSFTJ" (PDWID00 => :PDWID00,PDWTJCS => :PDWTJCS,PTJLB00 => :PTJLB00,PJSFS00 => :PJSFS00,PJZDH00 => :PJZDH00,PDWZBID => :PDWZBID,PBMMC00 => :PBMMC00,PQSRQ00 => :PQSRQ00,PJSRQ00 => :PJSRQ00,PSFJS00 => :PSFJS00); END; 101 08:16:10 SQL Execute: ORACLE - SELECT 0 FPXMID,'总计' XMMC00, 0 SFXMID, ROUND(SUM(HJJE00),2) HJJE00, ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000, '' DJ0000, ROUND(SUM(ZHJE00)/SUM(HJJE00),2)*100 ZKL000 FROM TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00 = '247' UNION SELECT FPXMID, FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND DWID00='247' UNION SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000),TO_CHAR(ROUND(HJJE00/SL0000,3)) DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID <> -1 AND DWID00='247' ORDER BY FPXMID, SFXMID 102 08:16:10 SQL Execute: ORACLE - select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='832372' and b.xmbh00= '2917' and JZDH00 ='470822' 103 08:16:10 SQL Execute: ORACLE - Select NVL(sum(HJJE00),0) ZKE000 FROM sf_fymx00 WHERE DJH000 = '13086935' 104 08:16:10 SQL Execute: ORACLE - select max(a.djh000) from sf_brfy00 a,sf_fymx00 b where a.djh000=b.djh000 and a.brid00='832372' and b.xmbh00= '2917' and JZDH00 ='470822' 105 08:16:10 SQL Execute: ORACLE - Select NVL(sum(HJJE00),0) ZKE000 FROM sf_fymx00 WHERE DJH000 = '13086935' 106 08:16:13 SQL Execute: ORACLE - select BRID00 from BM_TYDWB0 where DWID00='247' 107 08:16:13 SQL Execute: ORACLE - select MAX(MZID00) from SF_BRFY00 where BRID00=832372 108 08:16:13 SQL Execute: ORACLE - select * from (select JZDH00||'|'||JZRQ00 JZDHRQ,JZDH00,JZRQ00 from SF_TJJZB0 a,SF_TJPJQK b where a.BRID00=832372 and MZID00=2596797 and a.PJH000=b.PJH000 and b.SFDY00='N' ) order by JZRQ00 109 08:16:18 SQL Execute: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000,round(100*z.zhje00/z.je0000,0) zkl000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,sum(zje000)/sum(sl0000) dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from (select a.sl0000,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,nvl(a.FJF000,0) FJF000,a.zlxmid from TJ_YJDJH0 a,tj_brxxb0 c where c.dwid00='247' and c.dwtjcs='3' and c.dwid00=a.dwid00 and a.ghid00=c.ghid00 and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and not exists(select 1 from sf_brfy00 where djh000=a.sfdjh0 and brid00=a.brid00) and a.xmzt00 in ('2','3','D') and NVL(a.SFJZ00,'N')<>'Y' ) y group by zlxmid ) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid and z.je0000<>0 110 08:16:18 SQL Execute: ORACLE - BEGIN "SP_TJ_DWSFTJ" (PDWID00 => :PDWID00,PDWTJCS => :PDWTJCS,PTJLB00 => :PTJLB00,PJSFS00 => :PJSFS00,PJZDH00 => :PJZDH00,PDWZBID => :PDWZBID,PBMMC00 => :PBMMC00,PQSRQ00 => :PQSRQ00,PJSRQ00 => :PJSRQ00,PSFJS00 => :PSFJS00); END; 111 08:16:18 SQL Execute: ORACLE - commit 112 08:16:18 SQL Execute: ORACLE - SELECT 0 FPXMID,'总计' XMMC00,0 SFXMID,ROUND(SUM(HJJE00),2) HJJE00,ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000,'' DJ0000,ROUND(SUM(ZHJE00)/SUM(HJJE00),2)*100 ZKL000 FROM TJ_DWSFTJ WHERE SFXMID<>-1 AND DWID00='247' UNION SELECT FPXMID,FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND HJJE00<>0 AND DWID00='247' UNION SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(ROUND(HJJE00/SL0000,3)) DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID<>-1 AND HJJE00<>0 AND DWID00='247' ORDER BY FPXMID,SFXMID 113 08:16:50 Log started for: SQL Navigator for Oracle 114 08:16:52 SQL Execute: select version from SYS.PRODUCT_COMPONENT_VERSION where upper(product) like '%ORACLE%' 115 08:16:52 SQL Execute: SELECT table_name, table_owner FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'QUEST_COM_TEAM_CODING' 116 08:16:54 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 117 08:16:54 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 118 08:16:54 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 119 08:16:54 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 120 08:16:54 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 121 08:16:54 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 122 08:16:54 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 123 08:16:54 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 124 08:16:54 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.dba_objects a,sys.dba_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 125 08:16:54 SQL Execute: ALTER SESSION SET PLSQL_DEBUG=TRUE 126 08:16:54 SQL Execute: ALTER SESSION SET NLS_DATE_FORMAT='DD-Mon-RRRR' 127 08:16:54 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 128 08:16:54 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 129 08:16:54 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 130 08:16:54 SQL Execute: select version from SYS.PRODUCT_COMPONENT_VERSION where upper(product) like '%ORACLE%' 131 08:16:54 SQL Execute: SELECT table_name, table_owner FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'QUEST_COM_TEAM_CODING' 132 08:16:54 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 133 08:16:54 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 134 08:16:54 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 135 08:16:54 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 136 08:16:54 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 137 08:16:54 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 138 08:16:55 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 139 08:16:55 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 140 08:16:55 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.dba_objects a,sys.dba_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 141 08:16:55 SQL Execute: ALTER SESSION SET NLS_DATE_FORMAT='DD-Mon-RRRR' 142 08:16:55 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 143 08:16:55 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 144 08:16:55 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 145 08:16:55 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 146 08:16:55 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 147 08:16:55 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(instr(b.trigger_type,'BEFORE'),0,decode(instr(b.trigger_type,'AFTER'),0,decode(b.trigger_type,'INSTEAD OF',2,3),1),0) ty1,decode(instr(b.trigger_type,'STATEMENT'),0,decode(instr(b.trigger_type,'EACH ROW'),0,decode(instr(b.trigger_type,'EVENT'),0,3,2),1),0) ty2,decode(instr(b.triggering_event,'INSERT'),0,'N','Y') ev_ins,decode(instr(b.triggering_event,'UPDATE'),0,'N','Y') ev_upd,decode(instr(b.triggering_event,'DELETE'),0,'N','Y') ev_del,decode(instr(b.triggering_event,'STARTUP'),0,'N','Y') ev_startup,decode(instr(b.triggering_event,'SHUTDOWN'),0,'N','Y') ev_shutdown,decode(instr(b.triggering_event,'ERROR'),0,'N','Y') ev_error,decode(instr(b.triggering_event,'LOGON'),0,'N','Y') ev_logon,decode(instr(b.triggering_event,'LOGOFF'),0,'N','Y') ev_logoff,decode(instr(b.triggering_event,'CREATE'),0,'N','Y') ev_create,decode(instr(b.triggering_event,'ALTER'),0,'N','Y') ev_alter,decode(instr(b.triggering_event,'DROP'),0,'N','Y') ev_drop,decode(instr(b.triggering_event,'ANALYZE'),0,'N','Y') ev_analyze,decode(instr(b.triggering_event,'COMMENT'),0,'N','Y') ev_comment,decode(instr(b.triggering_event,'GRANT'),0,'N','Y') ev_grant,decode(instr(b.triggering_event,'REVOKE'),0,'N','Y') ev_revoke,decode(instr(b.triggering_event,'TRUNCATE'),0,'N','Y') ev_truncate,decode(instr(b.triggering_event,'RENAME'),0,'N','Y') ev_rename,decode(instr(b.triggering_event,' ASSOCIATE'),0,decode(substr(b.triggering_event,1,9),'ASSOCIATE','Y','N'),'Y') ev_associate,decode(instr(b.triggering_event,' AUDIT'),0,decode(substr(b.triggering_event,1,5),'AUDIT','Y','N'),'Y') ev_audit,decode(instr(b.triggering_event,' DISASSOCIATE'),0,decode(substr(b.triggering_event,1,12),'DISASSOCIATE','Y','N'),'Y') ev_disassociate,decode(instr(b.triggering_event,' NOAUDIT'),0,decode(substr(b.triggering_event,1,7),'NOAUDIT','Y','N'),'Y') ev_noaudit,decode(instr(b.triggering_event,'DDL'),0,'N','Y') ev_ddl,decode(rtrim(b.base_object_type),'TABLE',0,'VIEW',1,'SCHEMA',2,'DATABASE',3,4) base_type,b.table_owner,b.table_name,decode(b.status,'ENABLED','Y','N') enabled from user_objects a,user_triggers b where b.trigger_name like :object_name and a.object_name=b.trigger_name and a.object_type='TRIGGER' and b.trigger_name not in (select object_name from user_recyclebin where object_name=b.trigger_name) 148 08:16:55 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 149 08:16:55 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 150 08:16:55 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 151 08:16:55 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 152 08:16:55 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 153 08:16:55 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 154 08:16:55 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 155 08:16:55 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 156 08:16:55 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.dba_objects a,sys.dba_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 157 08:16:55 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 158 08:16:55 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 159 08:16:55 SQL Execute: select owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from sys.dba_objects a where a.owner like :schema and object_name like :object_name and object_type=:object_type 160 08:16:55 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 161 08:16:55 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 162 08:16:55 SQL Execute: select referencing_names,when_clause,description,trigger_body,column_name,action_type from user_triggers where trigger_name=:object_name 163 08:16:55 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 164 08:16:55 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 165 08:16:55 SQL Execute: select a.column_name,decode(a.data_type,'VARCHAR2',0,'NUMBER',1,'FLOAT',2,'LONG',3,'VARCHAR',4,'DATE',5,'RAW',6,'LONG RAW',7,'ROWID',8,'CHAR',9,'MLSLABEL',11,'NVARCHAR2',12,'NCHAR VARYING',13,'NCHAR',14,'NCLOB',16,'CLOB',17,'BLOB',18,'BFILE',19,'CFILE',20,'UROWID',30,'BINARY_FLOAT',32,'BINARY_DOUBLE',33,decode(a.data_type_mod,'REF',15,decode(instr(a.data_type,'INTERVAL DAY'),1,29,decode(instr(a.data_type,'INTERVAL YEAR'),1,28,decode(instr(a.data_type,'TIMESTAMP'),1,decode(instr(a.data_type,'TIME ZONE'),0,26,decode(instr(a.data_type,'LOCAL TIME ZONE'),0,27,31)),decode(instr(a.data_type,'TIME'),1,decode(instr(a.data_type,'TIME ZONE'),0,24,25),decode(a.data_type_owner,null,31,21))))))) data_type,decode(a.data_type_owner,null,decode(instr(a.data_type,'INTERVAL'),1,a.data_type,decode(instr(a.data_type,'TIME'),1,a.data_type,'')),a.data_type) type_name,a.data_type_owner type_owner,a.data_length,a.data_precision,a.data_scale,a.nullable,a.column_id,a.data_default,a.num_distinct,cast(a.low_value as varchar2(500)) low_value, cast(a.high_value as varchar2(500)) high_value,a.char_length,a.owner object_owner,a.table_name object_name,b.OWNER, b.TABLE_NAME, b.COLUMN_NAME, b.ENCRYPTION_ALG, b.SALT from sys.dba_tab_columns a, sys.dba_encrypted_columns b where a.owner=:schema and a.table_name=:object_name and b.table_name(+)=a.table_name and b.column_name(+)=a.column_name and b.owner(+)=a.owner order by a.column_id 166 08:16:56 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 167 08:16:56 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 168 08:16:56 SQL Execute: select a.column_name,decode(a.column_usage,null,0,'NEW IN',1,'OLD IN',2,'NEW IN OLD IN',3,'NEW OUT',4,'NEW IN OUT',5,'NEW OUT OLD IN',6,'NEW IN OUT OLD IN',7,'PARENT IN',8,'NONE',9) column_usage,decode(a.column_list,'YES','Y','N') column_list,USER object_owner,a.trigger_name object_name from user_trigger_cols a where a.trigger_name=:object_name and a.table_owner=:parent_owner and a.table_name=:parent_name 169 08:16:56 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 170 08:16:56 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 171 08:16:56 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 172 08:16:56 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 173 08:16:56 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 174 08:16:56 SQL Execute: select owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from sys.dba_objects a where a.owner like :schema and object_name like :object_name and object_type=:object_type 175 08:16:56 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 176 08:16:56 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 177 08:16:56 SQL Execute: select text,line from sys.dba_source where owner='SD_HOSPITAL' and name='SP_TJ_DWSFTJ' and type='PROCEDURE' order by line 178 08:17:01 SQL Execute: SELECT 0 FPXMID,'总计' XMMC00,0 SFXMID,ROUND(SUM(HJJE00),2) HJJE00,ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000,'' DJ0000,ROUND(SUM(ZHJE00)/SUM(HJJE00),2)*100 ZKL000 FROM TJ_DWSFTJ WHERE SFXMID<>-1 AND DWID00='247' UNION SELECT FPXMID,FPXMMC XMMC00,SFXMID,HJJE00,ZHJE00,'' SL0000,'' DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID=-1 AND HJJE00<>0 AND DWID00='247' UNION SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(ROUND(HJJE00/SL0000,3)) DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE SFXMID<>-1 AND HJJE00<>0 AND DWID00='247' ORDER BY FPXMID,SFXMID 179 08:17:19 SQL Execute: select owner,object_id,created,nvl(last_ddl_time,created) last_ddl_time,decode(status,'VALID',0,'INVALID',1,2) status,object_name,object_name,decode(object_type,'TABLE',1,'VIEW',2,'INDEX',3,'SNAPSHOT LOG',4,'PROCEDURE',5,'FUNCTION',6,'PACKAGE',7,'PACKAGE BODY',8,'TRIGGER',9,'SEQUENCE',10,'SYNONYM',11,'CLUSTER',12,'DATABASE LINK',13,'SNAPSHOT',14,'MATERIALIZED VIEW',14,'TYPE',15,'TYPE BODY',16,'LIBRARY',19,'DIRECTORY',20,'QUEUE',21,'JAVA SOURCE',22,'JAVA CLASS',23,'JAVA RESOURCE',24,'INDEXTYPE',25,'OPERATOR',26,'DIMENSION',31,'CONTEXT',32,'RESOURCE PLAN',33,'CONSUMER GROUP',34,0) object_type from (select owner,object_id,created,last_ddl_time,status,object_name,object_type from sys.all_objects where upper(owner) like 'SD_HOSPITAL' and upper(object_name) like 'SP_TJ_DWSFTJ' and object_type in ('TABLE','VIEW','INDEX','PROCEDURE','FUNCTION','PACKAGE','TRIGGER','SEQUENCE','SYNONYM','CLUSTER','DATABASE LINK','TYPE','LIBRARY','DIRECTORY','QUEUE','JAVA SOURCE','JAVA CLASS','JAVA RESOURCE','INDEXTYPE','OPERATOR','DIMENSION','CONTEXT','RESOURCE PLAN','CONSUMER GROUP') and object_name not in (select OBJECT_NAME from USER_RECYCLEBIN) UNION ALL select owner,-1 object_id,created,to_date(NULL) last_ddl_time,NULL status,db_link object_name,'DATABASE LINK' object_type from sys.all_db_links where upper(owner) like 'SD_HOSPITAL' and upper(db_link) like 'SP_TJ_DWSFTJ') 180 08:17:19 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 181 08:17:19 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 182 08:17:19 SQL Execute: select owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from sys.dba_objects a where a.owner like :schema and object_name like :object_name and object_type=:object_type 183 08:17:19 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 184 08:17:19 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 185 08:17:19 SQL Execute: select text,line from sys.dba_source where owner='SD_HOSPITAL' and name='SP_TJ_DWSFTJ' and type='PROCEDURE' order by line 186 08:20:04 SQL Execute: select C.FPXMID,B.SFXMID,sum(A.HJJE00),sum(A.ZHJE00),sum(A.XMSL00) from SF_FYMX00 A,bm_yysfxm B,bm_fpxm00 C,SF_BRFY00 D,TJ_YJDJH0 E,TJ_BRXXB0 F where D.JZDH00 + 0 = 0 AND A.DJH000 = D.DJH000 AND A.YJDJH0 = E.YJDJH0 AND D.DJH000 = E.SFDJH0 AND E.GHID00 = F.GHID00 AND A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and D.CZRQ00>= '20120101' and D.CZRQ00<= '20120509' having sum(A.HJJE00)<>0 group by C.FPXMID,B.SFXMId 187 08:20:29 SQL Execute: select TJ_BRXXB0.* , ROWID from TJ_BRXXB0 188 08:21:03 SQL Execute: select bm_brxxb0.* , ROWID from bm_brxxb0 where brxm00 like '%长乐附%' 189 08:21:24 SQL Execute: SAVEPOINT LOCK_SQLEditorDataset1 190 08:21:24 SQL Execute [Lock]: SELECT * FROM bm_brxxb0 WHERE ROWID = :OLD_ROWID FOR UPDATE NOWAIT 191 08:22:02 SQL Execute: select C.FPXMID,B.SFXMID,sum(A.HJJE00),sum(A.ZHJE00),sum(A.XMSL00) from SF_FYMX00 A,bm_yysfxm B,bm_fpxm00 C,SF_BRFY00 D,TJ_YJDJH0 E,TJ_BRXXB0 F where D.JZDH00 + 0 = 0 AND A.DJH000 = D.DJH000 AND A.YJDJH0 = E.YJDJH0 AND D.DJH000 = E.SFDJH0 AND E.GHID00 = F.GHID00 AND A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and D.CZRQ00>= '20120101' and D.CZRQ00<= '20120509' and f.brid00='832372' having sum(A.HJJE00)<>0 group by C.FPXMID,B.SFXMId 192 08:22:24 SQL Execute: select TJ_BRXXB0.* , ROWID from TJ_BRXXB0 where brid00='832372' 193 10:02:08 Log started for: Sickberth 194 10:02:08 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 195 10:02:08 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='2314' and CZBZ00 in ('1') 196 10:02:08 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 197 10:02:08 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.252','9','SickBerth.exe'||'+'||'病区护理系统','438','25218' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@2314:12D53CC0193DE0FCDBE6288B0D1A218D' from dual 198 10:02:08 SQL Execute: ORACLE - Commit 199 10:02:08 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 200 10:02:08 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2314' and CZBZ00 in ('1') 201 10:02:08 SQL Execute: ORACLE - Select SYSDATE from Dual 202 10:02:08 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 203 10:02:08 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 204 10:02:08 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 205 10:02:08 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 206 10:02:08 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 207 10:02:08 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)='2314')) 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)='2314')) order by b.PLXH00,a.BH0000 208 10:02:09 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '2314'='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)='2314')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='2314') 209 10:02:09 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=693 210 10:02:09 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 211 10:02:09 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 212 10:02:09 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 213 10:02:09 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 214 10:02:09 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')) 215 10:02:09 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3030279,693,'clyytest','9',nvl('38311552',' '),'192.168.9.252#438:25218@SickBerth.exe+病区护理系统',57) 216 10:02:09 SQL Execute: ORACLE - Commit 217 10:02:09 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 57 218 10:02:09 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 219 10:02:09 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 220 10:02:09 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 221 10:02:09 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 222 10:02:09 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 57 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 223 10:02:09 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 224 10:02:09 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 225 10:02:11 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='693' and name00='SYSTEMSKIN' 226 10:02:11 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 227 10:02:11 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20120507' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',57,' )>0 ) 228 10:02:11 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 229 10:02:11 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 230 10:02:11 SQL Execute: ORACLE - select sysdate from dual 231 10:02:12 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 693= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=693 and XTDM00='9'))) 232 10:02:12 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 233 10:02:12 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 ((693= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=693 and XTDM00='0 '))) 234 10:02:12 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 235 10:02:12 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 693= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=693 and XTDM00='+ '))) 236 10:02:12 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 237 10:02:12 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 238 10:02:12 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 239 10:02:12 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 240 10:02:12 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 241 10:02:12 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 242 10:02:12 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') 243 10:02:13 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 = 693 244 10:02:13 SQL Execute: ORACLE - select sysdate nowtime from dual 245 10:02:13 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 246 10:02:13 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 247 10:02:13 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; 248 10:02:14 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 249 10:02:14 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 250 10:02:14 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=693 251 10:02:14 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, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000(+) order by b.cwxh00,RYCWH0 252 10:02:16 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 253 10:02:16 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; 254 10:02:16 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19690720) AS NL FROM DUAL 255 10:02:16 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 256 10:02:18 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 257 10:02:18 SQL Execute: ORACLE - Select To_date('2012.05.0715:00:00','YYYY.MM.DDHH24:MI:SS') from dual 258 10:02:18 SQL Execute: ORACLE - select yflbid,yflbmc from BQ_YFLB00 259 10:02:18 SQL Execute: ORACLE - SELECT DISTINCT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YZZXJL_XYZX W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.QSRQ00<=TO_CHAR((?),'YYYYMMDD') UNION SELECT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YJYZ00_WTZ W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.YZLB00<>1 AND (W.CJKS00 is null or W.CJKS00=?) AND ( (YZZT00='1' AND (?)>=QSRQSJ) OR(YZZT00='2' AND (?)>TQRQSJ ) ) ORDER BY RYCWH0 260 10:02:18 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 261 10:02:18 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 262 10:02:18 SQL Execute: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,a.PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID,nvl((select sum(jjje00)*a.mcsl00*decode(a.ts0000,null,1,0,1,a.ts0000)*c.zqcs00 from bq_yjyzjj where yzmxid=a.yzmxid),0) JE0000 FROM VW_BQ_YJYZ00_WTZ a,bm_pc0000 c WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) and (CJKS00 is null or CJKS00=?) and decode(a.pcid00,0,1,a.pcid00)=c.pcid00 order by tqrqsj,clbz00,lbmc00,yzmxid 263 10:02:18 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 264 10:02:18 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 265 10:02:18 SQL Execute: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,a.PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID,nvl((select sum(jjje00)*a.mcsl00*decode(a.ts0000,null,1,0,1,a.ts0000)*c.zqcs00 from bq_yjyzjj where yzmxid=a.yzmxid),0) JE0000 FROM VW_BQ_YJYZ00_WTZ a,bm_pc0000 c WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) and (CJKS00 is null or CJKS00=?) and decode(a.pcid00,0,1,a.pcid00)=c.pcid00 order by tqrqsj,clbz00,lbmc00,yzmxid 266 10:02:23 SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZZX" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PYFLBID => :PYFLBID,PYPLBBH => :PYPLBBH,PZXRQ00 => :PZXRQ00); END; 267 10:02:23 SQL Execute: ORACLE - BEGIN "SP_BQ_YJYZZX_NOHL" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PLBBH00 => :PLBBH00,PZXRQ00 => :PZXRQ00,PBCTQID => :PBCTQID,PCJKS00 => :PCJKS00); END; 268 10:06:10 SQL Execute: ORACLE - SELECT DISTINCT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YZZXJL_XYZX W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.QSRQ00<=TO_CHAR((?),'YYYYMMDD') UNION SELECT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YJYZ00_WTZ W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.YZLB00<>1 AND (W.CJKS00 is null or W.CJKS00=?) AND ( (YZZT00='1' AND (?)>=QSRQSJ) OR(YZZT00='2' AND (?)>TQRQSJ ) ) ORDER BY RYCWH0 269 10:06:10 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 270 10:06:10 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 271 10:06:10 SQL Execute: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,a.PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID,nvl((select sum(jjje00)*a.mcsl00*decode(a.ts0000,null,1,0,1,a.ts0000)*c.zqcs00 from bq_yjyzjj where yzmxid=a.yzmxid),0) JE0000 FROM VW_BQ_YJYZ00_WTZ a,bm_pc0000 c WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) and (CJKS00 is null or CJKS00=?) and decode(a.pcid00,0,1,a.pcid00)=c.pcid00 order by tqrqsj,clbz00,lbmc00,yzmxid 272 10:06:10 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 273 10:06:10 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 274 10:06:10 SQL Execute: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,a.PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID,nvl((select sum(jjje00)*a.mcsl00*decode(a.ts0000,null,1,0,1,a.ts0000)*c.zqcs00 from bq_yjyzjj where yzmxid=a.yzmxid),0) JE0000 FROM VW_BQ_YJYZ00_WTZ a,bm_pc0000 c WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) and (CJKS00 is null or CJKS00=?) and decode(a.pcid00,0,1,a.pcid00)=c.pcid00 order by tqrqsj,clbz00,lbmc00,yzmxid 275 10:09:38 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, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000(+) order by b.cwxh00,RYCWH0 276 10:09:38 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 277 10:09:38 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; 278 10:09:38 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19690720) AS NL FROM DUAL 279 10:09:38 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 280 10:09:38 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 281 10:10:56 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 282 10:10:57 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 283 10:10:57 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and YZZT00 = ? order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 284 10:10:57 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and YZZT00 = ? order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 285 10:10:57 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and YZZT00 = ? order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 286 10:10:58 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and YZZT00 = ? order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 287 10:10:58 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and YZZT00 = ? order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 288 10:10:58 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 289 10:11:01 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 290 10:11:03 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and LB0000 = ? order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 291 10:21:55 Log started for: SQL Navigator for Oracle