2617 14:39:26 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')) 2618 14:39:26 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899004,0,'wlzx-3','6',nvl('37704217',' '),'',15) 2619 14:39:26 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899004,0,'wlzx-3','6',nvl('37704217',' '),'',15) 2620 14:39:26 SQL Prepare: ORACLE - Commit 2621 14:39:26 SQL Execute: ORACLE - Commit 2622 14:39:26 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15 2623 14:39:26 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15 2624 14:39:26 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 2625 14:39:26 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 2626 14:39:26 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 2627 14:39:26 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 2628 14:39:26 SQL Prepare: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 2629 14:39:26 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 2630 14:39:26 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 2631 14:39:26 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 2632 14:39:26 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 2633 14:39:26 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 2634 14:39:26 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 2635 14:39:26 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 2636 14:39:26 SQL Prepare: ORACLE - Commit 2637 14:39:26 SQL Execute: ORACLE - Commit 2638 14:39:26 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 2639 14:39:26 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 2640 14:39:26 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 2641 14:39:26 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 2642 14:39:26 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 2643 14:39:26 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 2644 14:39:27 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 2645 14:39:27 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 2646 14:39:27 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='6') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',15,')> 0) and YXQ000>='20120131' 2647 14:39:27 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='6') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',15,')> 0) and YXQ000>='20120131' 2648 14:39:27 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 2649 14:39:27 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 2650 14:39:27 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 2651 14:39:27 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 2652 14:39:27 SQL Prepare: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 2653 14:39:27 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 2654 14:39:27 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 2655 14:39:27 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 2656 14:39:27 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 2657 14:39:27 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 2658 14:39:27 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 2659 14:39:27 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 2660 14:39:27 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='6' and (( 0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='6'))) 2661 14:39:27 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='6' and (( 0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='6'))) 2662 14:39:27 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||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 2663 14:39:27 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||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 2664 14:39:27 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='0 '))) 2665 14:39:27 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 ((0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='0 '))) 2666 14:39:27 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='+ '))) 2667 14:39:27 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='+ '))) 2668 14:39:27 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 2669 14:39:27 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 2670 14:39:27 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('XT_YSXGFBKS','XT_XTXXYTJRXG','YF_SFXSGJJ','XT_SFXSGLYKFPQX') 2671 14:39:27 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('XT_YSXGFBKS','XT_XTXXYTJRXG','YF_SFXSGJJ','XT_SFXSGLYKFPQX') 2672 14:39:27 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 0 2673 14:39:27 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 0 2674 14:39:32 SQL Prepare: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'XT_SFGBBYTS' 2675 14:39:32 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'XT_SFGBBYTS' 2676 14:39:32 SQL Prepare: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'XT_SFXSDCGN' 2677 14:39:32 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'XT_SFXSDCGN' 2678 14:39:32 SQL Prepare: ORACLE - SELECT OBJECT_TYPE, OBJECT_NAME, CREATED, LAST_DDL_TIME FROM DBA_OBJECTS WHERE OWNER = 'SD_HOSPITAL' AND STATUS = 'INVALID' AND OBJECT_TYPE IN ('VIEW','PACKAGE', 'PROCEDURE', 'FUNCTION', 'PACKAGE BODY', 'TRIGGER') 2679 14:39:32 SQL Execute: ORACLE - SELECT OBJECT_TYPE, OBJECT_NAME, CREATED, LAST_DDL_TIME FROM DBA_OBJECTS WHERE OWNER = 'SD_HOSPITAL' AND STATUS = 'INVALID' AND OBJECT_TYPE IN ('VIEW','PACKAGE', 'PROCEDURE', 'FUNCTION', 'PACKAGE BODY', 'TRIGGER') 2680 14:39:32 SQL Prepare: ORACLE - SELECT NAME,TYPE,LINE,SUBSTR(TEXT,1,100) TEXT,POSITION FROM USER_ERRORS WHERE NAME = '' AND TYPE = '' ORDER BY LINE 2681 14:39:32 SQL Execute: ORACLE - SELECT NAME,TYPE,LINE,SUBSTR(TEXT,1,100) TEXT,POSITION FROM USER_ERRORS WHERE NAME = '' AND TYPE = '' ORDER BY LINE 2682 14:39:32 SQL Prepare: ORACLE - select Owner, Object_Name from all_objects where owner like 'SD%' and Object_Type = 'TABLE' order by Object_Name 2683 14:39:32 SQL Execute: ORACLE - select Owner, Object_Name from all_objects where owner like 'SD%' and Object_Type = 'TABLE' order by Object_Name 2684 14:39:32 SQL Prepare: ORACLE - select * from all_objects where owner like 'SD%' 2685 14:39:32 SQL Execute: ORACLE - select * from all_objects where owner like 'SD%' 2686 14:39:36 SQL Prepare: ORACLE - SELECT OBJECT_TYPE, OBJECT_NAME, CREATED, LAST_DDL_TIME FROM DBA_OBJECTS WHERE OWNER = 'SD_HOSPITAL' AND STATUS = 'INVALID' AND OBJECT_TYPE IN ('VIEW','PACKAGE', 'PROCEDURE', 'FUNCTION', 'PACKAGE BODY', 'TRIGGER') 2687 14:39:36 SQL Execute: ORACLE - SELECT OBJECT_TYPE, OBJECT_NAME, CREATED, LAST_DDL_TIME FROM DBA_OBJECTS WHERE OWNER = 'SD_HOSPITAL' AND STATUS = 'INVALID' AND OBJECT_TYPE IN ('VIEW','PACKAGE', 'PROCEDURE', 'FUNCTION', 'PACKAGE BODY', 'TRIGGER') 2688 14:39:36 SQL Prepare: ORACLE - SELECT NAME,TYPE,LINE,SUBSTR(TEXT,1,100) TEXT,POSITION FROM USER_ERRORS WHERE NAME = '' AND TYPE = '' ORDER BY LINE 2689 14:39:36 SQL Execute: ORACLE - SELECT NAME,TYPE,LINE,SUBSTR(TEXT,1,100) TEXT,POSITION FROM USER_ERRORS WHERE NAME = '' AND TYPE = '' ORDER BY LINE 2690 14:39:36 SQL Prepare: ORACLE - SELECT OBJECT_TYPE, OBJECT_NAME, CREATED, LAST_DDL_TIME FROM DBA_OBJECTS WHERE OWNER = 'SD_HOSPITAL' AND STATUS = 'INVALID' AND OBJECT_TYPE IN ('VIEW','PACKAGE', 'PROCEDURE', 'FUNCTION', 'PACKAGE BODY', 'TRIGGER') 2691 14:39:36 SQL Execute: ORACLE - SELECT OBJECT_TYPE, OBJECT_NAME, CREATED, LAST_DDL_TIME FROM DBA_OBJECTS WHERE OWNER = 'SD_HOSPITAL' AND STATUS = 'INVALID' AND OBJECT_TYPE IN ('VIEW','PACKAGE', 'PROCEDURE', 'FUNCTION', 'PACKAGE BODY', 'TRIGGER') 2692 14:39:36 SQL Prepare: ORACLE - SELECT NAME,TYPE,LINE,SUBSTR(TEXT,1,100) TEXT,POSITION FROM USER_ERRORS WHERE NAME = '' AND TYPE = '' ORDER BY LINE 2693 14:39:36 SQL Execute: ORACLE - SELECT NAME,TYPE,LINE,SUBSTR(TEXT,1,100) TEXT,POSITION FROM USER_ERRORS WHERE NAME = '' AND TYPE = '' ORDER BY LINE 2694 15:58:46 Log started for: 固定资产核算管理系统 2695 15:58:46 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','709','39258' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 2696 15:58:46 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','709','39258' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 2697 15:58:46 SQL Prepare: ORACLE - Commit 2698 15:58:46 SQL Execute: ORACLE - Commit 2699 15:58:46 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 2700 15:58:46 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 2701 15:58:46 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 2702 15:58:46 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 2703 15:58:46 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2704 15:58:46 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2705 15:58:46 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 2706 15:58:46 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 2707 15:58:46 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','273','10267' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 2708 15:58:46 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','273','10267' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 2709 15:58:46 SQL Prepare: ORACLE - Commit 2710 15:58:46 SQL Execute: ORACLE - Commit 2711 15:58:46 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 2712 15:58:46 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 2713 15:58:46 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2714 15:58:46 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2715 15:58:46 SQL Prepare: ORACLE - Select SYSDATE from Dual 2716 15:58:46 SQL Execute: ORACLE - Select SYSDATE from Dual 2717 15:58:46 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 2718 15:58:46 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 2719 15:58:46 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 2720 15:58:46 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 2721 15:58:46 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 2722 15:58:46 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 2723 15:58:46 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 2724 15:58:46 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 2725 15:58:46 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 2726 15:58:46 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 2727 15:58:46 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='G' 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 ('a','b','9','8') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 2728 15:58:46 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='G' 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 ('a','b','9','8') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 2729 15:59:17 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' 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='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 2730 15:59:17 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' 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='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 2731 15:59:17 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 2732 15:59:17 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 2733 15:59:17 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 2734 15:59:17 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 2735 15:59:17 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 2736 15:59:17 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 2737 15:59:17 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 2738 15:59:17 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 2739 15:59:17 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 2740 15:59:17 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 2741 15:59:17 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 2742 15:59:17 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')) 2743 15:59:17 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899161,476,'wlzx-3','G',nvl('37706003',' '),'192.168.12.120#273:10267@Prj_GDZC.exe+固定资产核算管理系统',169) 2744 15:59:17 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899161,476,'wlzx-3','G',nvl('37706003',' '),'192.168.12.120#273:10267@Prj_GDZC.exe+固定资产核算管理系统',169) 2745 15:59:17 SQL Prepare: ORACLE - Commit 2746 15:59:17 SQL Execute: ORACLE - Commit 2747 15:59:17 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 169 2748 15:59:17 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 169 2749 15:59:17 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 2750 15:59:17 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 2751 15:59:17 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 2752 15:59:17 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 2753 15:59:17 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 2754 15:59:17 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 2755 15:59:17 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 2756 15:59:17 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 2757 15:59:17 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 169 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 2758 15:59:17 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 169 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 2759 15:59:17 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 2760 15:59:17 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 2761 15:59:17 SQL Prepare: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 2762 15:59:17 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 2763 15:59:17 SQL Prepare: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 2764 15:59:17 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 2765 15:59:17 SQL Prepare: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 2766 15:59:17 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 2767 15:59:17 SQL Prepare: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 2768 15:59:17 SQL Execute: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 2769 15:59:18 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 2770 15:59:18 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 2771 15:59:18 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 2772 15:59:18 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 2773 15:59:18 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',169,' )>0 ) 2774 15:59:18 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',169,' )>0 ) 2775 15:59:18 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 2776 15:59:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 2777 15:59:18 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 2778 15:59:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 2779 15:59:18 SQL Prepare: ORACLE - select sysdate nowtime from dual 2780 15:59:18 SQL Execute: ORACLE - select sysdate nowtime from dual 2781 15:59:18 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 2782 15:59:18 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 2783 15:59:18 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 2784 15:59:18 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 2785 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 2786 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 2787 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 2788 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 2789 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 2790 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 2791 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 2792 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 2793 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 2794 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 2795 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 2796 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 2797 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 2798 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 2799 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 2800 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 2801 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 2802 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 2803 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 2804 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 2805 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 2806 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 2807 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 2808 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 2809 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 2810 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 2811 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 2812 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 2813 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 2814 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 2815 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 2816 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 2817 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 2818 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 2819 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 2820 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 2821 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 2822 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 2823 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 2824 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 2825 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 2826 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 2827 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 2828 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 2829 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 2830 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 2831 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 2832 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 2833 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 2834 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 2835 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 2836 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 2837 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 2838 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 2839 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 2840 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 2841 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 2842 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 2843 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZCDAXGCJBQXS' 2844 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZCDAXGCJBQXS' 2845 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_XXGJBKZKHBZJ' 2846 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_XXGJBKZKHBZJ' 2847 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_DAKPDKDYGS' 2848 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_DAKPDKDYGS' 2849 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PDDYFJJESFTJ' 2850 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PDDYFJJESFTJ' 2851 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_TJYSBFLSFACKFK' 2852 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_TJYSBFLSFACKFK' 2853 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZJJDSFZJZJ' 2854 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZJJDSFZJZJ' 2855 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPLCKXS' 2856 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPLCKXS' 2857 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKMXHZCXSFBKTK' 2858 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKMXHZCXSFBKTK' 2859 15:59:18 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 2860 15:59:18 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 2861 15:59:18 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ') 2862 15:59:18 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ') 2863 15:59:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='G'))) 2864 15:59:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='G'))) 2865 15:59:18 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||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 2866 15:59:18 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||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 2867 15:59:18 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 2868 15:59:18 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 '))) 2869 15:59:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 2870 15:59:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 2871 15:59:18 SQL Prepare: 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='+ '))) 2872 15:59:18 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='+ '))) 2873 15:59:51 SQL Prepare: ORACLE - SELECT SBLBID,SBLBMC FROM VW_BM_SBLB00 ORDER BY SBLBBH 2874 15:59:51 SQL Execute: ORACLE - SELECT SBLBID,SBLBMC FROM VW_BM_SBLB00 ORDER BY SBLBBH 2875 15:59:51 SQL Prepare: ORACLE - SELECT TJLBID,TJLBMC FROM VW_BM_SBTJLB ORDER BY TJLBBH 2876 15:59:51 SQL Execute: ORACLE - SELECT TJLBID,TJLBMC FROM VW_BM_SBTJLB ORDER BY TJLBBH 2877 15:59:51 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2878 15:59:51 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2879 15:59:53 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2880 15:59:53 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2881 15:59:54 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='030' AND SBBH00<='039' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='030000' AND SBBH00<='039999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2882 15:59:54 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='030' AND SBBH00<='039' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='030000' AND SBBH00<='039999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2883 15:59:54 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='03' 2884 15:59:54 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='03' 2885 16:03:26 SQL Prepare: ORACLE - SELECT SBLBID,SBLBMC FROM VW_BM_SBLB00 ORDER BY SBLBBH 2886 16:03:26 SQL Execute: ORACLE - SELECT SBLBID,SBLBMC FROM VW_BM_SBLB00 ORDER BY SBLBBH 2887 16:03:26 SQL Prepare: ORACLE - SELECT TJLBID,TJLBMC FROM VW_BM_SBTJLB ORDER BY TJLBBH 2888 16:03:26 SQL Execute: ORACLE - SELECT TJLBID,TJLBMC FROM VW_BM_SBTJLB ORDER BY TJLBBH 2889 16:03:26 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2890 16:03:26 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2891 16:03:28 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2892 16:03:28 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2893 16:03:29 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2894 16:03:29 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2895 16:03:29 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 2896 16:03:29 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 2897 16:03:31 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2898 16:03:31 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2899 16:03:31 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 2900 16:03:31 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 2901 16:03:33 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0240' AND SBBH00<='0249' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='024000' AND SBBH00<='024999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2902 16:03:33 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0240' AND SBBH00<='0249' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='024000' AND SBBH00<='024999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2903 16:03:33 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='024' 2904 16:03:33 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='024' 2905 16:03:34 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0230' AND SBBH00<='0239' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='023000' AND SBBH00<='023999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2906 16:03:34 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0230' AND SBBH00<='0239' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='023000' AND SBBH00<='023999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2907 16:03:34 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='023' 2908 16:03:34 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='023' 2909 16:03:36 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0260' AND SBBH00<='0269' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='026000' AND SBBH00<='026999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2910 16:03:36 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0260' AND SBBH00<='0269' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='026000' AND SBBH00<='026999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2911 16:03:36 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='026' 2912 16:03:36 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='026' 2913 16:03:36 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0260' AND SBBH00<='0269' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='026000' AND SBBH00<='026999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2914 16:03:36 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0260' AND SBBH00<='0269' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='026000' AND SBBH00<='026999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2915 16:03:36 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='026' 2916 16:03:36 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='026' 2917 16:03:37 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='026100' AND SBBH00<='026199' AND LENGTH(TRIM(SBBH00))<=6 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2918 16:03:37 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='026100' AND SBBH00<='026199' AND LENGTH(TRIM(SBBH00))<=6 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 2919 16:03:37 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='0261' 2920 16:03:37 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='0261' 2921 16:05:44 SQL Prepare: ORACLE - rollback 2922 16:05:44 SQL Execute: ORACLE - rollback 2923 16:05:44 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2899161 2924 16:05:44 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2899161 2925 16:05:44 SQL Prepare: ORACLE - Commit 2926 16:05:44 SQL Execute: ORACLE - Commit 2927 16:05:44 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 2928 16:05:44 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 2929 16:05:44 SQL Prepare: ORACLE - Commit 2930 16:05:44 SQL Execute: ORACLE - Commit 2931 16:05:44 Log started for: 后台维护系统 2932 16:06:29 Log started for: 固定资产核算管理系统 2933 16:06:29 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','768','2095' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 2934 16:06:29 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','768','2095' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 2935 16:06:29 SQL Prepare: ORACLE - Commit 2936 16:06:29 SQL Execute: ORACLE - Commit 2937 16:06:29 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 2938 16:06:29 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 2939 16:06:29 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 2940 16:06:29 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 2941 16:06:29 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2942 16:06:29 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2943 16:06:29 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 2944 16:06:29 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 2945 16:06:29 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','259','9478' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 2946 16:06:29 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','259','9478' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 2947 16:06:29 SQL Prepare: ORACLE - Commit 2948 16:06:29 SQL Execute: ORACLE - Commit 2949 16:06:29 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 2950 16:06:29 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 2951 16:06:29 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2952 16:06:29 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2953 16:06:29 SQL Prepare: ORACLE - Select SYSDATE from Dual 2954 16:06:29 SQL Execute: ORACLE - Select SYSDATE from Dual 2955 16:06:29 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 2956 16:06:29 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 2957 16:06:29 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 2958 16:06:29 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 2959 16:06:29 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 2960 16:06:29 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 2961 16:06:29 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 2962 16:06:29 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 2963 16:06:29 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 2964 16:06:29 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 2965 16:06:29 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='G' 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 ('a','b','9','8') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 2966 16:06:29 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='G' 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 ('a','b','9','8') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 2967 16:06:32 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' 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='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 2968 16:06:32 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' 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='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 2969 16:06:32 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 2970 16:06:32 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 2971 16:06:32 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 2972 16:06:32 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 2973 16:06:32 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 2974 16:06:32 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 2975 16:06:32 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 2976 16:06:32 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 2977 16:06:32 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 2978 16:06:32 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 2979 16:06:32 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 2980 16:06:32 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')) 2981 16:06:32 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899173,476,'wlzx-3','G',nvl('37706043',' '),'192.168.12.120#259:9478@Prj_GDZC.exe+固定资产核算管理系统',169) 2982 16:06:32 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899173,476,'wlzx-3','G',nvl('37706043',' '),'192.168.12.120#259:9478@Prj_GDZC.exe+固定资产核算管理系统',169) 2983 16:06:32 SQL Prepare: ORACLE - Commit 2984 16:06:32 SQL Execute: ORACLE - Commit 2985 16:06:32 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 169 2986 16:06:32 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 169 2987 16:06:32 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 2988 16:06:32 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 2989 16:06:32 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 2990 16:06:32 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 2991 16:06:32 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 2992 16:06:32 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 2993 16:06:32 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 2994 16:06:32 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 2995 16:06:32 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 169 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 2996 16:06:32 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 169 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 2997 16:06:32 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 2998 16:06:32 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 2999 16:06:32 SQL Prepare: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 3000 16:06:32 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 3001 16:06:32 SQL Prepare: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 3002 16:06:32 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 3003 16:06:32 SQL Prepare: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 3004 16:06:32 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 3005 16:06:32 SQL Prepare: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 3006 16:06:32 SQL Execute: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 3007 16:06:32 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3008 16:06:32 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3009 16:06:32 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 3010 16:06:32 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 3011 16:06:32 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',169,' )>0 ) 3012 16:06:32 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',169,' )>0 ) 3013 16:06:32 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3014 16:06:32 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3015 16:06:32 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3016 16:06:32 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3017 16:06:32 SQL Prepare: ORACLE - select sysdate nowtime from dual 3018 16:06:32 SQL Execute: ORACLE - select sysdate nowtime from dual 3019 16:06:32 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 3020 16:06:32 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 3021 16:06:32 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 3022 16:06:32 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 3023 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 3024 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 3025 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 3026 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 3027 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 3028 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 3029 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 3030 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 3031 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 3032 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 3033 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 3034 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 3035 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 3036 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 3037 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 3038 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 3039 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 3040 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 3041 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 3042 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 3043 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 3044 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 3045 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 3046 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 3047 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 3048 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 3049 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 3050 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 3051 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 3052 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 3053 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 3054 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 3055 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 3056 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 3057 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 3058 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 3059 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 3060 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 3061 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 3062 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 3063 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 3064 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 3065 16:06:32 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 3066 16:06:32 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 3067 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 3068 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 3069 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 3070 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 3071 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 3072 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 3073 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 3074 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 3075 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 3076 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 3077 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 3078 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 3079 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 3080 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 3081 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZCDAXGCJBQXS' 3082 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZCDAXGCJBQXS' 3083 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_XXGJBKZKHBZJ' 3084 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_XXGJBKZKHBZJ' 3085 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_DAKPDKDYGS' 3086 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_DAKPDKDYGS' 3087 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PDDYFJJESFTJ' 3088 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PDDYFJJESFTJ' 3089 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_TJYSBFLSFACKFK' 3090 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_TJYSBFLSFACKFK' 3091 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZJJDSFZJZJ' 3092 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZJJDSFZJZJ' 3093 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPLCKXS' 3094 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPLCKXS' 3095 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKMXHZCXSFBKTK' 3096 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKMXHZCXSFBKTK' 3097 16:06:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 3098 16:06:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 3099 16:06:33 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ') 3100 16:06:33 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ') 3101 16:06:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='G'))) 3102 16:06:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='G'))) 3103 16:06:33 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||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 3104 16:06:33 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||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 3105 16:06:33 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 3106 16:06:33 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 '))) 3107 16:06:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 3108 16:06:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 3109 16:06:33 SQL Prepare: 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='+ '))) 3110 16:06:33 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='+ '))) 3111 16:06:36 SQL Prepare: ORACLE - SELECT SBLBID,SBLBMC FROM VW_BM_SBLB00 ORDER BY SBLBBH 3112 16:06:36 SQL Execute: ORACLE - SELECT SBLBID,SBLBMC FROM VW_BM_SBLB00 ORDER BY SBLBBH 3113 16:06:36 SQL Prepare: ORACLE - SELECT TJLBID,TJLBMC FROM VW_BM_SBTJLB ORDER BY TJLBBH 3114 16:06:36 SQL Execute: ORACLE - SELECT TJLBID,TJLBMC FROM VW_BM_SBTJLB ORDER BY TJLBBH 3115 16:06:36 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3116 16:06:36 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3117 16:06:37 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3118 16:06:37 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3119 16:06:39 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3120 16:06:39 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3121 16:06:39 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 3122 16:06:39 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 3123 16:06:40 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3124 16:06:40 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3125 16:06:40 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 3126 16:06:40 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 3127 16:06:41 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3128 16:06:41 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3129 16:06:41 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 3130 16:06:41 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 3131 16:06:43 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0210' AND SBBH00<='0219' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='021000' AND SBBH00<='021999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3132 16:06:43 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='0210' AND SBBH00<='0219' AND LENGTH(TRIM(SBBH00))<=4) or (SBBH00>='021000' AND SBBH00<='021999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,5,2)='00') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3133 16:06:43 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='021' 3134 16:06:43 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='021' 3135 16:07:01 SQL Prepare: ORACLE - SELECT SBLBID,SBLBMC FROM VW_BM_SBLB00 ORDER BY SBLBBH 3136 16:07:01 SQL Execute: ORACLE - SELECT SBLBID,SBLBMC FROM VW_BM_SBLB00 ORDER BY SBLBBH 3137 16:07:01 SQL Prepare: ORACLE - SELECT TJLBID,TJLBMC FROM VW_BM_SBTJLB ORDER BY TJLBBH 3138 16:07:01 SQL Execute: ORACLE - SELECT TJLBID,TJLBMC FROM VW_BM_SBTJLB ORDER BY TJLBBH 3139 16:07:01 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3140 16:07:01 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3141 16:07:04 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3142 16:07:04 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3143 16:07:04 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3144 16:07:04 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3145 16:07:05 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3146 16:07:05 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3147 16:07:06 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3148 16:07:06 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3149 16:07:07 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3150 16:07:07 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3151 16:07:08 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3152 16:07:08 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='020' AND SBBH00<='029' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='020000' AND SBBH00<='029999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3153 16:07:08 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 3154 16:07:08 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='02' 3155 16:07:15 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='130' AND SBBH00<='139' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='130000' AND SBBH00<='139999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3156 16:07:15 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='130' AND SBBH00<='139' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='130000' AND SBBH00<='139999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3157 16:07:15 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='13' 3158 16:07:15 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='13' 3159 16:07:22 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='110' AND SBBH00<='119' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='110000' AND SBBH00<='119999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3160 16:07:22 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='110' AND SBBH00<='119' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='110000' AND SBBH00<='119999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3161 16:07:22 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='11' 3162 16:07:22 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='11' 3163 16:07:24 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='170' AND SBBH00<='179' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='170000' AND SBBH00<='179999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3164 16:07:24 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='170' AND SBBH00<='179' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='170000' AND SBBH00<='179999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3165 16:07:24 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='17' 3166 16:07:24 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='17' 3167 16:07:25 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='200' AND SBBH00<='209' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='200000' AND SBBH00<='209999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3168 16:07:25 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='200' AND SBBH00<='209' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='200000' AND SBBH00<='209999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3169 16:07:25 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='20' 3170 16:07:25 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='20' 3171 16:07:30 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='600' AND SBBH00<='609' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='600000' AND SBBH00<='609999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3172 16:07:30 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='600' AND SBBH00<='609' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='600000' AND SBBH00<='609999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3173 16:07:30 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='60' 3174 16:07:30 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='60' 3175 16:07:49 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='600' AND SBBH00<='609' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='600000' AND SBBH00<='609999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3176 16:07:49 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE (SBBH00>='600' AND SBBH00<='609' AND LENGTH(TRIM(SBBH00))<=3) or (SBBH00>='600000' AND SBBH00<='609999' AND LENGTH(TRIM(SBBH00))<=6 and substr(SBBH00,4,3)='000') and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3177 16:07:49 SQL Prepare: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='60' 3178 16:07:49 SQL Execute: ORACLE - SELECT T1.*,T2.SBMC00 FLMC00 FROM BM_SBBM00 T1,BM_FLBM00 T2 WHERE T1.FLSBID=T2.FLSBID(+) AND T1.SBBH00='60' 3179 16:07:53 SQL Prepare: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3180 16:07:53 SQL Execute: ORACLE - SELECT * FROM BM_SBBM00 WHERE SBBH00>='00' AND SBBH00<='99' AND LENGTH(TRIM(SBBH00))<=2 and ((CKBH00=169 or nvl(CKBH00,0)=0) and nvl(flag00,'0')='0' or nvl(flag00,'0')='1' ) order by SBBH00 3181 16:07:56 SQL Prepare: ORACLE - rollback 3182 16:07:56 SQL Execute: ORACLE - rollback 3183 16:07:56 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2899173 3184 16:07:56 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2899173 3185 16:07:56 SQL Prepare: ORACLE - Commit 3186 16:07:56 SQL Execute: ORACLE - Commit 3187 16:07:56 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 3188 16:07:56 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 3189 16:07:56 SQL Prepare: ORACLE - Commit 3190 16:07:56 SQL Execute: ORACLE - Commit 3191 16:07:57 Log started for: 后台维护系统 3192 16:09:18 Log started for: 固定资产核算管理系统 3193 16:09:18 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','89','5301' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from dual 3194 16:09:18 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','89','5301' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from dual 3195 16:09:18 SQL Prepare: ORACLE - Commit 3196 16:09:18 SQL Execute: ORACLE - Commit 3197 16:09:18 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3198 16:09:18 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3199 16:09:18 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 3200 16:09:18 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 3201 16:09:18 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3202 16:09:18 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3203 16:09:18 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3204 16:09:18 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3205 16:09:18 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','92','6358' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from dual 3206 16:09:18 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','92','6358' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from dual 3207 16:09:18 SQL Prepare: ORACLE - Commit 3208 16:09:18 SQL Execute: ORACLE - Commit 3209 16:09:18 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 3210 16:09:18 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 3211 16:09:18 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3212 16:09:18 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3213 16:09:18 SQL Prepare: ORACLE - Select SYSDATE from Dual 3214 16:09:18 SQL Execute: ORACLE - Select SYSDATE from Dual 3215 16:09:18 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 3216 16:09:18 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 3217 16:09:18 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3218 16:09:18 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3219 16:09:18 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 3220 16:09:18 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 3221 16:09:18 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3222 16:09:18 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3223 16:09:18 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 3224 16:09:18 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 3225 16:09:18 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='G' 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 ('a','b','9','8') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 3226 16:09:18 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='G' 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 ('a','b','9','8') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 3227 16:09:20 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' 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='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 3228 16:09:20 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' 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='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 3229 16:09:21 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 3230 16:09:21 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 3231 16:09:21 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3232 16:09:21 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3233 16:09:21 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 3234 16:09:21 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 3235 16:09:21 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 3236 16:09:21 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 3237 16:09:21 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 3238 16:09:21 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 3239 16:09:21 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 3240 16:09:21 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')) 3241 16:09:21 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2456789,476,'wlzx-3','G',nvl('15361519',' '),'192.168.12.120#92:6358@Prj_GDZC.exe+固定资产核算管理系统',169) 3242 16:09:21 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2456789,476,'wlzx-3','G',nvl('15361519',' '),'192.168.12.120#92:6358@Prj_GDZC.exe+固定资产核算管理系统',169) 3243 16:09:21 SQL Prepare: ORACLE - Commit 3244 16:09:21 SQL Execute: ORACLE - Commit 3245 16:09:21 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 169 3246 16:09:21 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 169 3247 16:09:21 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 3248 16:09:21 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 3249 16:09:21 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 3250 16:09:21 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 3251 16:09:21 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 3252 16:09:21 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 3253 16:09:21 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 3254 16:09:21 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 3255 16:09:21 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 169 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 3256 16:09:21 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 169 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 3257 16:09:21 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 3258 16:09:21 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 3259 16:09:21 SQL Prepare: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 3260 16:09:21 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 3261 16:09:21 SQL Prepare: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 3262 16:09:21 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 3263 16:09:21 SQL Prepare: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 3264 16:09:21 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 3265 16:09:21 SQL Prepare: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 3266 16:09:21 SQL Execute: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 3267 16:09:22 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3268 16:09:22 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3269 16:09:22 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 3270 16:09:22 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 3271 16:09:22 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',169,' )>0 ) 3272 16:09:22 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',169,' )>0 ) 3273 16:09:22 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3274 16:09:22 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3275 16:09:22 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3276 16:09:22 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3277 16:09:22 SQL Prepare: ORACLE - select sysdate nowtime from dual 3278 16:09:22 SQL Execute: ORACLE - select sysdate nowtime from dual 3279 16:09:22 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 3280 16:09:22 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 3281 16:09:22 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 3282 16:09:22 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 3283 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 3284 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 3285 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 3286 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 3287 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 3288 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 3289 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 3290 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 3291 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 3292 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 3293 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 3294 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 3295 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 3296 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 3297 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 3298 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 3299 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 3300 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 3301 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 3302 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 3303 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 3304 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 3305 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 3306 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 3307 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 3308 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 3309 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 3310 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 3311 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 3312 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 3313 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 3314 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 3315 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 3316 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 3317 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 3318 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 3319 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 3320 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 3321 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 3322 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 3323 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 3324 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 3325 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 3326 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 3327 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 3328 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 3329 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 3330 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 3331 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 3332 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 3333 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 3334 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 3335 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 3336 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 3337 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 3338 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 3339 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 3340 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 3341 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZCDAXGCJBQXS' 3342 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZCDAXGCJBQXS' 3343 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_XXGJBKZKHBZJ' 3344 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_XXGJBKZKHBZJ' 3345 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_DAKPDKDYGS' 3346 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_DAKPDKDYGS' 3347 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PDDYFJJESFTJ' 3348 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PDDYFJJESFTJ' 3349 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_TJYSBFLSFACKFK' 3350 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_TJYSBFLSFACKFK' 3351 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZJJDSFZJZJ' 3352 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZJJDSFZJZJ' 3353 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPLCKXS' 3354 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPLCKXS' 3355 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKMXHZCXSFBKTK' 3356 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKMXHZCXSFBKTK' 3357 16:09:22 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 3358 16:09:22 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 3359 16:09:22 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ') 3360 16:09:22 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ') 3361 16:09:27 SQL Prepare: ORACLE - select * from VW_SB_JJYTZD 3362 16:09:27 SQL Execute: ORACLE - select * from VW_SB_JJYTZD 3363 16:09:27 SQL Prepare: ORACLE - select * from VW_SB_ZJFFZD 3364 16:09:27 SQL Execute: ORACLE - select * from VW_SB_ZJFFZD 3365 16:09:27 SQL Prepare: ORACLE - select * from VW_SB_ZDLBZD 3366 16:09:27 SQL Execute: ORACLE - select * from VW_SB_ZDLBZD 3367 16:09:27 SQL Prepare: ORACLE - select * from VW_SB_CGLBZD 3368 16:09:27 SQL Execute: ORACLE - select * from VW_SB_CGLBZD 3369 16:09:27 SQL Prepare: ORACLE - select * from VW_SB_WHQKZD 3370 16:09:27 SQL Execute: ORACLE - select * from VW_SB_WHQKZD 3371 16:10:22 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3372 16:10:22 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3373 16:10:34 SQL Prepare: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1' 3374 16:10:34 SQL Execute: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1' 3375 16:10:34 SQL Prepare: ORACLE - select KFBMBH,KFBMMC from bm_sbkfb0 3376 16:10:34 SQL Execute: ORACLE - select KFBMBH,KFBMMC from bm_sbkfb0 3377 16:10:34 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='1' and CKBH00=169 and LRR000=476 and SHBZ00 in ('0','1') order by rckid0 3378 16:10:34 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='1' and CKBH00=169 and LRR000=476 and SHBZ00 in ('0','1') order by rckid0 3379 16:10:34 SQL Prepare: ORACLE - select * from vw_SB_RCKMX0 where RCKID0='' and CXBZ00='Z' 3380 16:10:34 SQL Execute: ORACLE - select * from vw_SB_RCKMX0 where RCKID0='' and CXBZ00='Z' 3381 16:10:37 SQL Prepare: ORACLE - Rollback 3382 16:10:37 SQL Execute: ORACLE - Rollback 3383 16:10:45 SQL Prepare: ORACLE - select sysdate N from dual 3384 16:10:45 SQL Execute: ORACLE - select sysdate N from dual 3385 16:10:55 SQL Prepare: ORACLE - select sysdate N from dual 3386 16:10:55 SQL Execute: ORACLE - select sysdate N from dual 3387 16:11:10 SQL Prepare: ORACLE - select * from VW_SB_JJYTZD 3388 16:11:10 SQL Execute: ORACLE - select * from VW_SB_JJYTZD 3389 16:11:10 SQL Prepare: ORACLE - select * from VW_SB_ZJFFZD 3390 16:11:10 SQL Execute: ORACLE - select * from VW_SB_ZJFFZD 3391 16:11:10 SQL Prepare: ORACLE - select * from VW_SB_ZDLBZD 3392 16:11:10 SQL Execute: ORACLE - select * from VW_SB_ZDLBZD 3393 16:11:10 SQL Prepare: ORACLE - select * from VW_SB_CGLBZD 3394 16:11:10 SQL Execute: ORACLE - select * from VW_SB_CGLBZD 3395 16:11:10 SQL Prepare: ORACLE - select * from VW_SB_WHQKZD 3396 16:11:10 SQL Execute: ORACLE - select * from VW_SB_WHQKZD 3397 16:11:17 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 3398 16:11:17 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 3399 16:11:17 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3400 16:11:17 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3401 16:11:30 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3402 16:11:30 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3403 16:11:38 SQL Prepare: ORACLE - select * from VW_SB_JJYTZD 3404 16:11:38 SQL Execute: ORACLE - select * from VW_SB_JJYTZD 3405 16:11:38 SQL Prepare: ORACLE - select * from VW_SB_ZJFFZD 3406 16:11:38 SQL Execute: ORACLE - select * from VW_SB_ZJFFZD 3407 16:11:38 SQL Prepare: ORACLE - select * from VW_SB_ZDLBZD 3408 16:11:38 SQL Execute: ORACLE - select * from VW_SB_ZDLBZD 3409 16:11:38 SQL Prepare: ORACLE - select * from VW_SB_CGLBZD 3410 16:11:38 SQL Execute: ORACLE - select * from VW_SB_CGLBZD 3411 16:11:38 SQL Prepare: ORACLE - select * from VW_SB_WHQKZD 3412 16:11:38 SQL Execute: ORACLE - select * from VW_SB_WHQKZD 3413 16:11:40 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3414 16:11:40 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3415 16:12:06 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3416 16:12:06 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3417 16:12:07 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3418 16:12:07 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3419 16:12:08 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3420 16:12:08 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3421 16:12:09 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3422 16:12:09 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3423 16:12:38 SQL Prepare: ORACLE - select * from BM_SBLB00 where SBLBID= 1 3424 16:12:38 SQL Execute: ORACLE - select * from BM_SBLB00 where SBLBID= 1 3425 16:12:38 SQL Prepare: ORACLE - select * from BM_SBTJLB where TJLBID= 1 3426 16:12:38 SQL Execute: ORACLE - select * from BM_SBTJLB where TJLBID= 1 3427 16:12:38 SQL Prepare: ORACLE - select SP_SB_GetKPH000('017') KPH000 from dual 3428 16:12:38 SQL Execute: ORACLE - select SP_SB_GetKPH000('017') KPH000 from dual 3429 16:12:44 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3430 16:12:44 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3431 16:12:55 SQL Prepare: ORACLE - select * from BM_SBLB00 where SBLBID= 1 3432 16:12:55 SQL Execute: ORACLE - select * from BM_SBLB00 where SBLBID= 1 3433 16:12:55 SQL Prepare: ORACLE - select * from BM_SBTJLB where TJLBID= 1 3434 16:12:55 SQL Execute: ORACLE - select * from BM_SBTJLB where TJLBID= 1 3435 16:12:55 SQL Prepare: ORACLE - select SP_SB_GetKPH000('014300') KPH000 from dual 3436 16:12:55 SQL Execute: ORACLE - select SP_SB_GetKPH000('014300') KPH000 from dual 3437 16:12:59 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3438 16:12:59 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3439 16:12:59 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3440 16:12:59 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3441 16:13:02 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100 3442 16:13:02 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100 3443 16:13:03 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100 3444 16:13:03 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100 3445 16:13:04 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100 3446 16:13:04 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100 3447 16:13:05 SQL Prepare: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100 3448 16:13:05 SQL Execute: ORACLE - Select * from (select SBBH00,SBMC00,GG0000,XH0000,JLDW00,PYSM00,WBSM00,SYLX00,SBLBID,TJLBID,SBID00,CKDJ00,WXZCBZ from BM_SBBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100 3449 16:13:45 SQL Prepare: ORACLE - select * from BM_SBLB00 where SBLBID= 2 3450 16:13:45 SQL Execute: ORACLE - select * from BM_SBLB00 where SBLBID= 2 3451 16:13:45 SQL Prepare: ORACLE - select * from BM_SBTJLB where TJLBID= 4 3452 16:13:45 SQL Execute: ORACLE - select * from BM_SBTJLB where TJLBID= 4 3453 16:13:45 SQL Prepare: ORACLE - select SP_SB_GetKPH000('45230403') KPH000 from dual 3454 16:13:45 SQL Execute: ORACLE - select SP_SB_GetKPH000('45230403') KPH000 from dual 3455 16:14:40 SQL Prepare: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,YGBH00 from BM_YGBM00 where (XKH000 Like :1) Order By XKH000) where Rownum<=100 3456 16:14:40 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,YGBH00 from BM_YGBM00 where (XKH000 Like ?) Order By XKH000) where Rownum<=100 3457 16:14:45 SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (BH0000 Like :1) Order By BH0000) where Rownum<=100 3458 16:14:45 SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (BH0000 Like ?) Order By BH0000) where Rownum<=100 3459 16:14:59 SQL Prepare: ORACLE - select * from BM_SBLB00 where SBLBID= 2 3460 16:14:59 SQL Execute: ORACLE - select * from BM_SBLB00 where SBLBID= 2 3461 16:14:59 SQL Prepare: ORACLE - select * from BM_SBTJLB where TJLBID= 4 3462 16:14:59 SQL Execute: ORACLE - select * from BM_SBTJLB where TJLBID= 4 3463 16:14:59 SQL Prepare: ORACLE - select SP_SB_GetKPH000('45230403') KPH000 from dual 3464 16:14:59 SQL Execute: ORACLE - select SP_SB_GetKPH000('45230403') KPH000 from dual 3465 16:15:15 SQL Prepare: ORACLE - select SQ_SB_DA0000_DAXXID.nextval NUM from dual 3466 16:15:15 SQL Execute: ORACLE - select SQ_SB_DA0000_DAXXID.nextval NUM from dual 3467 16:15:15 SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_KSSYDJ" (AD_DAXXID => :AD_DAXXID,AD_BMBH00 => :AD_BMBH00,AD_SYBFB0 => :AD_SYBFB0,AD_FTJE00 => :AD_FTJE00,as_QYRQ00 => :as_QYRQ00,ad_CZY000 => :ad_CZY000,as_SFQCJD => :as_SFQCJD,ad_FTCZZJ => :ad_FTCZZJ,ad_FTKJXM => :ad_FTKJXM,ad_FTQTZJ => :ad_FTQTZJ,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 3468 16:15:15 SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_KSSYDJ" (AD_DAXXID => :AD_DAXXID,AD_BMBH00 => :AD_BMBH00,AD_SYBFB0 => :AD_SYBFB0,AD_FTJE00 => :AD_FTJE00,as_QYRQ00 => :as_QYRQ00,ad_CZY000 => :ad_CZY000,as_SFQCJD => :as_SFQCJD,ad_FTCZZJ => :ad_FTCZZJ,ad_FTKJXM => :ad_FTKJXM,ad_FTQTZJ => :ad_FTQTZJ,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 3469 16:15:15 SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_REG000" (AD_DAXXID => :AD_DAXXID,AS_SYBZ00 => :AS_SYBZ00,AS_FPH000 => :AS_FPH000,AS_FPRQ00 => :AS_FPRQ00,AS_HTH000 => :AS_HTH000,AD_RCMXID => :AD_RCMXID,AS_DAH000 => :AS_DAH000,AS_DABH00 => :AS_DABH00,AD_SBID00 => :AD_SBID00,AS_SBMC00 => :AS_SBMC00,AS_JLDW00 => :AS_JLDW00,AD_SYNX00 => :AD_SYNX00,AS_GG0000 => :AS_GG0000,AS_XH0000 => :AS_XH0000,AD_SL0000 => :AD_SL0000,AD_DJ0000 => :AD_DJ0000,AD_FJFY00 => :AD_FJFY00,AD_AZFY00 => :AD_AZFY00,AD_YZ0000 => :AD_YZ0000,AD_JCZL00 => :AD_JCZL00,AD_QCZJ00 => :AD_QCZJ00,AD_SHJSZJ => :AD_SHJSZJ,AS_ZJFFMC => :AS_ZJFFMC,AD_YZJL00 => :AD_YZJL00,AD_LJZJ00 => :AD_LJZJ00,AD_JZ0000 => :AD_JZ0000,AD_CJID00 => :AD_CJID00,AD_GHDWID => :AD_GHDWID,AD_CFDD00 => :AD_CFDD00,AD_SSBM00 => :AD_SSBM00,AD_KSSYSL => :AD_KSSYSL,AD_CGR000 => :AD_CGR000,AD_YSR000 => :AD_YSR000,AD_BGR000 => :AD_BGR000,AD_XBJE00 => :AD_XBJE00,AD_ZCJE00 => :AD_ZCJE00,AD_QTJFJE => :AD_QTJFJE,AS_FJBZ00 => :AS_FJBZ00,AS_CCBH00 => :AS_CCBH00,AS_CCRQ00 => :AS_CCRQ00,AS_RKRQ00 => :AS_RKRQ00,AS_RKSJ00 => :AS_RKSJ00,AS_CKRQ00 => :AS_CKRQ00,AS_CKSJ00 => :AS_CKSJ00,AS_QYRQ00 => :AS_QYRQ00,AS_RZRQ00 => :AS_RZRQ00,AS_ZLDJ00 => :AS_ZLDJ00,AS_KCBZ00 => :AS_KCBZ00,AD_SYZT00 => :AD_SYZT00,AS_JJYT00 => :AS_JJYT00,AS_CGFS00 => :AS_CGFS00,AS_WHQK00 => :AS_WHQK00,AS_JDBZ00 => :AS_JDBZ00,AS_JDLBMC => :AS_JDLBMC,AS_LRRQ00 => :AS_LRRQ00,AS_LRSJ00 => :AS_LRSJ00,AD_LRR000 => :AD_LRR000,AD_ZDMJ00 => :AD_ZDMJ00,AS_GZYQBZ => :AS_GZYQBZ,AS_JLYQBZ => :AS_JLYQBZ,AD_BXQ000 => :AD_BXQ000,AS_AZRQ00 => :AS_AZRQ00,AS_YSRQ00 => :AS_YSRQ00,AS_YJQK00 => :AS_YJQK00,AS_SJZL00 => :AS_SJZL00,AS_JSGG00 => :AS_JSGG00,AS_ZCLY00 => :AS_ZCLY00,AS_FJZD00 => :AS_FJZD00,AS_FJZD01 => :AS_FJZD01,AS_FJZD02 => :AS_FJZD02,AS_FJZD03 => :AS_FJZD03,AS_FJZD04 => :AS_FJZD04,AS_FJZD05 => :AS_FJZD05,AS_FJZD06 => :AS_FJZD06,AS_FJZD07 => :AS_FJZD07,AS_FJZD08 => :AS_FJZD08,AS_FJZD09 => :AS_FJZD09,AS_FJZD10 => :AS_FJZD10,AS_BZ0000 => :AS_BZ0000,AS_CZBZ00 => :AS_CZBZ00,AS_CKBH00 => :AS_CKBH00,AS_WXZCBZ => :AS_WXZCBZ,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 3470 16:15:15 SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_REG000" (AD_DAXXID => :AD_DAXXID,AS_SYBZ00 => :AS_SYBZ00,AS_FPH000 => :AS_FPH000,AS_FPRQ00 => :AS_FPRQ00,AS_HTH000 => :AS_HTH000,AD_RCMXID => :AD_RCMXID,AS_DAH000 => :AS_DAH000,AS_DABH00 => :AS_DABH00,AD_SBID00 => :AD_SBID00,AS_SBMC00 => :AS_SBMC00,AS_JLDW00 => :AS_JLDW00,AD_SYNX00 => :AD_SYNX00,AS_GG0000 => :AS_GG0000,AS_XH0000 => :AS_XH0000,AD_SL0000 => :AD_SL0000,AD_DJ0000 => :AD_DJ0000,AD_FJFY00 => :AD_FJFY00,AD_AZFY00 => :AD_AZFY00,AD_YZ0000 => :AD_YZ0000,AD_JCZL00 => :AD_JCZL00,AD_QCZJ00 => :AD_QCZJ00,AD_SHJSZJ => :AD_SHJSZJ,AS_ZJFFMC => :AS_ZJFFMC,AD_YZJL00 => :AD_YZJL00,AD_LJZJ00 => :AD_LJZJ00,AD_JZ0000 => :AD_JZ0000,AD_CJID00 => :AD_CJID00,AD_GHDWID => :AD_GHDWID,AD_CFDD00 => :AD_CFDD00,AD_SSBM00 => :AD_SSBM00,AD_KSSYSL => :AD_KSSYSL,AD_CGR000 => :AD_CGR000,AD_YSR000 => :AD_YSR000,AD_BGR000 => :AD_BGR000,AD_XBJE00 => :AD_XBJE00,AD_ZCJE00 => :AD_ZCJE00,AD_QTJFJE => :AD_QTJFJE,AS_FJBZ00 => :AS_FJBZ00,AS_CCBH00 => :AS_CCBH00,AS_CCRQ00 => :AS_CCRQ00,AS_RKRQ00 => :AS_RKRQ00,AS_RKSJ00 => :AS_RKSJ00,AS_CKRQ00 => :AS_CKRQ00,AS_CKSJ00 => :AS_CKSJ00,AS_QYRQ00 => :AS_QYRQ00,AS_RZRQ00 => :AS_RZRQ00,AS_ZLDJ00 => :AS_ZLDJ00,AS_KCBZ00 => :AS_KCBZ00,AD_SYZT00 => :AD_SYZT00,AS_JJYT00 => :AS_JJYT00,AS_CGFS00 => :AS_CGFS00,AS_WHQK00 => :AS_WHQK00,AS_JDBZ00 => :AS_JDBZ00,AS_JDLBMC => :AS_JDLBMC,AS_LRRQ00 => :AS_LRRQ00,AS_LRSJ00 => :AS_LRSJ00,AD_LRR000 => :AD_LRR000,AD_ZDMJ00 => :AD_ZDMJ00,AS_GZYQBZ => :AS_GZYQBZ,AS_JLYQBZ => :AS_JLYQBZ,AD_BXQ000 => :AD_BXQ000,AS_AZRQ00 => :AS_AZRQ00,AS_YSRQ00 => :AS_YSRQ00,AS_YJQK00 => :AS_YJQK00,AS_SJZL00 => :AS_SJZL00,AS_JSGG00 => :AS_JSGG00,AS_ZCLY00 => :AS_ZCLY00,AS_FJZD00 => :AS_FJZD00,AS_FJZD01 => :AS_FJZD01,AS_FJZD02 => :AS_FJZD02,AS_FJZD03 => :AS_FJZD03,AS_FJZD04 => :AS_FJZD04,AS_FJZD05 => :AS_FJZD05,AS_FJZD06 => :AS_FJZD06,AS_FJZD07 => :AS_FJZD07,AS_FJZD08 => :AS_FJZD08,AS_FJZD09 => :AS_FJZD09,AS_FJZD10 => :AS_FJZD10,AS_BZ0000 => :AS_BZ0000,AS_CZBZ00 => :AS_CZBZ00,AS_CKBH00 => :AS_CKBH00,AS_WXZCBZ => :AS_WXZCBZ,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 3471 16:15:15 SQL Prepare: ORACLE - commit 3472 16:15:15 SQL Execute: ORACLE - commit 3473 16:15:25 SQL Prepare: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3474 16:15:25 SQL Execute: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3475 16:15:25 SQL Prepare: ORACLE - select * from vw_BM_SBTJLB where CKBH00=169 or CKBH00=0 3476 16:15:25 SQL Execute: ORACLE - select * from vw_BM_SBTJLB where CKBH00=169 or CKBH00=0 3477 16:15:25 SQL Prepare: ORACLE - select * From BM_SYZT00 where SFYX00='Y' 3478 16:15:25 SQL Execute: ORACLE - select * From BM_SYZT00 where SFYX00='Y' 3479 16:15:26 SQL Prepare: ORACLE - select F.SYZTMC,E.BMMC00,C.SBLBMC,D.TJLBMC,B.GJBM00,A.* from sb_da0000 A,bm_sbbm00 B,bm_sblb00 C,BM_SBTJLB D,bm_bmbm00 E,BM_SYZT00 F where A.sbid00=B.sbid00 and B.SBLBID=C.SBLBID and B.TJLBID=D.TJLBID and A.SYZT00 = F.SYZT00(+) and A.SFYX00='Y' and A.SSBM00 = E.BMBH00(+) and a.CKBH00=169 and A.BFRQ00 is null and A.SSBM00 is not null 3480 16:15:26 SQL Execute: ORACLE - select F.SYZTMC,E.BMMC00,C.SBLBMC,D.TJLBMC,B.GJBM00,A.* from sb_da0000 A,bm_sbbm00 B,bm_sblb00 C,BM_SBTJLB D,bm_bmbm00 E,BM_SYZT00 F where A.sbid00=B.sbid00 and B.SBLBID=C.SBLBID and B.TJLBID=D.TJLBID and A.SYZT00 = F.SYZT00(+) and A.SFYX00='Y' and A.SSBM00 = E.BMBH00(+) and a.CKBH00=169 and A.BFRQ00 is null and A.SSBM00 is not null 3481 16:15:27 SQL Prepare: ORACLE - select * from sb_dafj00 where daxxid=:1 order by XLH000 3482 16:15:27 SQL Execute: ORACLE - select * from sb_dafj00 where daxxid=? order by XLH000 3483 16:15:28 SQL Prepare: ORACLE - select * from sb_dafj00 where daxxid=:1 order by XLH000 3484 16:15:28 SQL Execute: ORACLE - select * from sb_dafj00 where daxxid=? order by XLH000 3485 16:15:30 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3486 16:15:30 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3487 16:15:31 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3488 16:15:31 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3489 16:15:31 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3490 16:15:31 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3491 16:15:32 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3492 16:15:32 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3493 16:15:34 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBMC00 Like :1) Order By SBMC00) where Rownum<=100 3494 16:15:34 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBMC00 Like ?) Order By SBMC00) where Rownum<=100 3495 16:15:34 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100 3496 16:15:34 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100 3497 16:15:37 SQL Prepare: ORACLE - select F.SYZTMC,E.BMMC00,C.SBLBMC,D.TJLBMC,B.GJBM00,A.* from sb_da0000 A,bm_sbbm00 B,bm_sblb00 C,BM_SBTJLB D,bm_bmbm00 E,BM_SYZT00 F where A.sbid00=B.sbid00 and B.SBLBID=C.SBLBID and B.TJLBID=D.TJLBID and A.SYZT00 = F.SYZT00(+) and A.SFYX00='Y' and A.SSBM00 = E.BMBH00(+) and a.CKBH00=169 and A.SBMC00 = '活检钳' and A.BFRQ00 is null and A.SSBM00 is not null 3498 16:15:37 SQL Execute: ORACLE - select F.SYZTMC,E.BMMC00,C.SBLBMC,D.TJLBMC,B.GJBM00,A.* from sb_da0000 A,bm_sbbm00 B,bm_sblb00 C,BM_SBTJLB D,bm_bmbm00 E,BM_SYZT00 F where A.sbid00=B.sbid00 and B.SBLBID=C.SBLBID and B.TJLBID=D.TJLBID and A.SYZT00 = F.SYZT00(+) and A.SFYX00='Y' and A.SSBM00 = E.BMBH00(+) and a.CKBH00=169 and A.SBMC00 = '活检钳' and A.BFRQ00 is null and A.SSBM00 is not null 3499 16:15:37 SQL Prepare: ORACLE - select * from sb_dafj00 where daxxid=:1 order by XLH000 3500 16:15:37 SQL Execute: ORACLE - select * from sb_dafj00 where daxxid=? order by XLH000 3501 16:15:41 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3502 16:15:41 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3503 16:15:44 SQL Prepare: ORACLE - select * from sb_dafj00 where daxxid=:1 order by XLH000 3504 16:15:44 SQL Execute: ORACLE - select * from sb_dafj00 where daxxid=? order by XLH000 3505 16:16:04 SQL Prepare: ORACLE - select sysdate N from dual 3506 16:16:04 SQL Execute: ORACLE - select sysdate N from dual 3507 16:16:10 SQL Prepare: ORACLE - select to_date(QYRQ00,'yyyymmdd')QYRQ00,SHJSZJ from sb_da0000 where daxxid='37701' 3508 16:16:10 SQL Execute: ORACLE - select to_date(QYRQ00,'yyyymmdd')QYRQ00,SHJSZJ from sb_da0000 where daxxid='37701' 3509 16:16:10 SQL Prepare: ORACLE - select E.ZDMC00,C.SBLBMC,D.TJLBMC,F.CGFSMC,G.WHQKMC, A.* , (select sccjid from sb_rckmx0 where rcmxid = a.rcmxid) sccjid from sb_da0000 A,bm_sbbm00 B,bm_sblb00 C,bm_sbtjlb D,BM_ZDZH00 E,BM_CGFS00 F,BM_WHQK00 G where A.sbid00 = B.sbid00 and B.SBLBID = C.SBLBID(+) and B.TJLBID = D.TJLBID(+) and A.JDLB00 = E.ZDID00(+) and A.DAXXID =:1 and A.CGFS00 = F.CGFS00(+) and A.WHQK00 = G.WHQK00(+) 3510 16:16:10 SQL Execute: ORACLE - select E.ZDMC00,C.SBLBMC,D.TJLBMC,F.CGFSMC,G.WHQKMC, A.* , (select sccjid from sb_rckmx0 where rcmxid = a.rcmxid) sccjid from sb_da0000 A,bm_sbbm00 B,bm_sblb00 C,bm_sbtjlb D,BM_ZDZH00 E,BM_CGFS00 F,BM_WHQK00 G where A.sbid00 = B.sbid00 and B.SBLBID = C.SBLBID(+) and B.TJLBID = D.TJLBID(+) and A.JDLB00 = E.ZDID00(+) and A.DAXXID =? and A.CGFS00 = F.CGFS00(+) and A.WHQK00 = G.WHQK00(+) 3511 16:16:10 SQL Prepare: ORACLE - select * from sb_da0000 where JDBZ00='2' and daxxid=37701 3512 16:16:10 SQL Execute: ORACLE - select * from sb_da0000 where JDBZ00='2' and daxxid=37701 3513 16:16:10 SQL Prepare: ORACLE - select * from sb_gdzczj where daxxid = 37701 3514 16:16:10 SQL Execute: ORACLE - select * from sb_gdzczj where daxxid = 37701 3515 16:16:10 SQL Prepare: ORACLE - select * from BM_YGBM00 where YGBH00 =:1 3516 16:16:10 SQL Execute: ORACLE - select * from BM_YGBM00 where YGBH00 =? 3517 16:16:10 SQL Prepare: ORACLE - select * from BM_BMBM00 where BMBH00 =:1 3518 16:16:10 SQL Execute: ORACLE - select * from BM_BMBM00 where BMBH00 =? 3519 16:16:10 SQL Prepare: ORACLE - select * from BM_BMBM00 where BMBH00 =:1 3520 16:16:10 SQL Execute: ORACLE - select * from BM_BMBM00 where BMBH00 =? 3521 16:16:10 SQL Prepare: ORACLE - select * from VW_SB_ZJFFZD where 1 = 1 and ID0000 = 27 3522 16:16:10 SQL Execute: ORACLE - select * from VW_SB_ZJFFZD where 1 = 1 and ID0000 = 27 3523 16:16:10 SQL Prepare: ORACLE - select * from VW_SB_JJYTZD 3524 16:16:10 SQL Execute: ORACLE - select * from VW_SB_JJYTZD 3525 16:16:10 SQL Prepare: ORACLE - select * from VW_SB_ZDLBZD 3526 16:16:10 SQL Execute: ORACLE - select * from VW_SB_ZDLBZD 3527 16:16:10 SQL Prepare: ORACLE - select * from VW_SB_CGLBZD 3528 16:16:10 SQL Execute: ORACLE - select * from VW_SB_CGLBZD 3529 16:16:10 SQL Prepare: ORACLE - select * from VW_SB_WHQKZD 3530 16:16:10 SQL Execute: ORACLE - select * from VW_SB_WHQKZD 3531 16:16:25 SQL Prepare: ORACLE - select sysdate N from dual 3532 16:16:25 SQL Execute: ORACLE - select sysdate N from dual 3533 16:16:27 SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_KSSBTQ" (AD_TQNF00 => :AD_TQNF00,AD_TQYF00 => :AD_TQYF00,AD_TQR000 => :AD_TQR000); END; 3534 16:16:27 SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_KSSBTQ" (AD_TQNF00 => :AD_TQNF00,AD_TQYF00 => :AD_TQYF00,AD_TQR000 => :AD_TQR000); END; 3535 16:22:37 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=169 and DLXTMC='固定资产核算管理系统' and CTMC00='frmGDZC_XGJJ00_RBB000' 3536 16:22:37 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=169 and DLXTMC='固定资产核算管理系统' and CTMC00='frmGDZC_XGJJ00_RBB000' 3537 16:22:43 SQL Prepare: ORACLE - select sysdate N from dual 3538 16:22:43 SQL Execute: ORACLE - select sysdate N from dual 3539 16:22:43 SQL Prepare: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and TQYF00 =12) 3540 16:22:43 SQL Execute: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and TQYF00 =12) 3541 16:22:46 SQL Prepare: ORACLE - select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 union all SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,D.TQKS00 BMBH00,E.BH0000 BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 group by D.TQKS00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all select ' 部门合计'BMMC00 ,1000 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 group by E.BMXZ00 order by SX,BMBH00 3542 16:22:46 SQL Execute: ORACLE - select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 union all SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,D.TQKS00 BMBH00,E.BH0000 BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 group by D.TQKS00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all select ' 部门合计'BMMC00 ,1000 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 169 group by E.BMXZ00 order by SX,BMBH00 3543 16:22:59 SQL Prepare: ORACLE - delete XT_ZDYLXS where YGBH00=476 and BMBH00=169 and DLXTMC='固定资产核算管理系统' and CTMC00='frmGDZC_XGJJ00_RBB000' and DBGRIN='DBGridEh1' 3544 16:22:59 SQL Execute: ORACLE - delete XT_ZDYLXS where YGBH00=476 and BMBH00=169 and DLXTMC='固定资产核算管理系统' and CTMC00='frmGDZC_XGJJ00_RBB000' and DBGRIN='DBGridEh1' 3545 16:22:59 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',0,'N', 'BH0000','科室编号',109) 3546 16:22:59 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',0,'N', 'BH0000','科室编号',109) 3547 16:22:59 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',1,'Y', 'BMMC00','科室名称',183) 3548 16:22:59 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',1,'Y', 'BMMC00','科室名称',183) 3549 16:22:59 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',2,'Y', 'YZ0000','资产原值',96) 3550 16:22:59 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',2,'Y', 'YZ0000','资产原值',96) 3551 16:22:59 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',3,'Y', 'BYZJE0','本月计提',79) 3552 16:22:59 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',3,'Y', 'BYZJE0','本月计提',79) 3553 16:22:59 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',4,'Y', 'BYBTJE','本月补提',82) 3554 16:22:59 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',4,'Y', 'BYBTJE','本月补提',82) 3555 16:22:59 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',5,'Y', 'LJZJ00','累计计提',83) 3556 16:22:59 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',5,'Y', 'LJZJ00','累计计提',83) 3557 16:22:59 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',6,'Y', 'JZ0000','资产净值',99) 3558 16:22:59 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00) values(476,169, '固定资产核算管理系统','frmGDZC_XGJJ00_RBB000','DBGridEh1',6,'Y', 'JZ0000','资产净值',99) 3559 16:22:59 SQL Prepare: ORACLE - Commit 3560 16:22:59 SQL Execute: ORACLE - Commit 3561 16:22:59 SQL Prepare: ORACLE - Rollback 3562 16:22:59 SQL Execute: ORACLE - Rollback 3563 16:23:10 SQL Prepare: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3564 16:23:10 SQL Execute: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3565 16:23:10 SQL Prepare: ORACLE - select * from VW_SB_SBTJLB where CKBH00= 169 or CKBH00=0 3566 16:23:10 SQL Execute: ORACLE - select * from VW_SB_SBTJLB where CKBH00= 169 or CKBH00=0 3567 16:23:10 SQL Prepare: ORACLE - select * from VW_SB_SYZTZD 3568 16:23:10 SQL Execute: ORACLE - select * from VW_SB_SYZTZD 3569 16:23:10 SQL Prepare: ORACLE - select * from VW_SB_ZDLBZD 3570 16:23:10 SQL Execute: ORACLE - select * from VW_SB_ZDLBZD 3571 16:23:10 SQL Prepare: ORACLE - select * from VW_SB_CGLBZD 3572 16:23:10 SQL Execute: ORACLE - select * from VW_SB_CGLBZD 3573 16:23:10 SQL Prepare: ORACLE - select * from VW_SB_WHQKZD 3574 16:23:10 SQL Execute: ORACLE - select * from VW_SB_WHQKZD 3575 16:23:12 SQL Prepare: ORACLE - select BMMC00,SBLBMC,BYZJE0,DAXXID,DAH000,SBMC00,YZ0000,LJZJ00,JZ0000,KSSYSL,RZRQ00,SYNX00,CKBH00 from (select E.BMMC00,C.SBLBMC,D.BYZJE0,A.DAXXID,A.DAH000,A.SBMC00,D.TQYZ00 YZ0000,d.LJZJJE LJZJ00,d.zjhjz0 JZ0000,A.KSSYSL,A.RZRQ00,A.SYNX00,A.CKBH00, B.SBLBID,B.TJLBID,A.GG0000,A.XH0000,A.JLDW00,A.CCBH00,A.CJID00,A.CCRQ00,A.QYRQ00,A.BXQ000,F.SYZTMC,A.CFDD00,A.WHQK00,A.CGFS00,A.SHJSZJ,B.GJBM00 from SB_DA0000 A,BM_SBBM00 B,BM_SBLB00 C,SB_GDZCZJ D,BM_BMBM00 E,BM_SYZT00 F where D.TQKS00+0 = E.BMBH00 and A.SBID00 = B.SBID00 and B.SBLBID = C.SBLBID and A.DAXXID = D.DAXXID and A.SYZT00 = F.SYZT00(+) and D.TQNF00 = 2012 and D.TQYF00 = 01 ) x where 1=1 and x.CKBH00= 169 3576 16:23:12 SQL Execute: ORACLE - select BMMC00,SBLBMC,BYZJE0,DAXXID,DAH000,SBMC00,YZ0000,LJZJ00,JZ0000,KSSYSL,RZRQ00,SYNX00,CKBH00 from (select E.BMMC00,C.SBLBMC,D.BYZJE0,A.DAXXID,A.DAH000,A.SBMC00,D.TQYZ00 YZ0000,d.LJZJJE LJZJ00,d.zjhjz0 JZ0000,A.KSSYSL,A.RZRQ00,A.SYNX00,A.CKBH00, B.SBLBID,B.TJLBID,A.GG0000,A.XH0000,A.JLDW00,A.CCBH00,A.CJID00,A.CCRQ00,A.QYRQ00,A.BXQ000,F.SYZTMC,A.CFDD00,A.WHQK00,A.CGFS00,A.SHJSZJ,B.GJBM00 from SB_DA0000 A,BM_SBBM00 B,BM_SBLB00 C,SB_GDZCZJ D,BM_BMBM00 E,BM_SYZT00 F where D.TQKS00+0 = E.BMBH00 and A.SBID00 = B.SBID00 and B.SBLBID = C.SBLBID and A.DAXXID = D.DAXXID and A.SYZT00 = F.SYZT00(+) and D.TQNF00 = 2012 and D.TQYF00 = 01 ) x where 1=1 and x.CKBH00= 169 3577 16:23:15 SQL Prepare: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3578 16:23:15 SQL Execute: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3579 16:23:15 SQL Prepare: ORACLE - select * from VW_SB_SBTJLB where CKBH00= 169 or CKBH00=0 3580 16:23:15 SQL Execute: ORACLE - select * from VW_SB_SBTJLB where CKBH00= 169 or CKBH00=0 3581 16:23:15 SQL Prepare: ORACLE - select * from VW_SB_SYZTZD 3582 16:23:15 SQL Execute: ORACLE - select * from VW_SB_SYZTZD 3583 16:23:15 SQL Prepare: ORACLE - select * from VW_SB_ZDLBZD 3584 16:23:15 SQL Execute: ORACLE - select * from VW_SB_ZDLBZD 3585 16:23:15 SQL Prepare: ORACLE - select * from VW_SB_CGLBZD 3586 16:23:15 SQL Execute: ORACLE - select * from VW_SB_CGLBZD 3587 16:23:15 SQL Prepare: ORACLE - select * from VW_SB_WHQKZD 3588 16:23:15 SQL Execute: ORACLE - select * from VW_SB_WHQKZD 3589 16:23:22 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3590 16:23:22 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3591 16:23:35 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3592 16:23:35 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3593 16:23:38 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3594 16:23:38 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3595 16:23:45 SQL Prepare: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3596 16:23:45 SQL Execute: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3597 16:23:45 SQL Prepare: ORACLE - select * from VW_SB_SBTJLB where CKBH00= 169 or CKBH00=0 3598 16:23:45 SQL Execute: ORACLE - select * from VW_SB_SBTJLB where CKBH00= 169 or CKBH00=0 3599 16:23:45 SQL Prepare: ORACLE - select * from VW_SB_SYZTZD 3600 16:23:45 SQL Execute: ORACLE - select * from VW_SB_SYZTZD 3601 16:23:45 SQL Prepare: ORACLE - select * from VW_SB_ZDLBZD 3602 16:23:45 SQL Execute: ORACLE - select * from VW_SB_ZDLBZD 3603 16:23:45 SQL Prepare: ORACLE - select * from VW_SB_CGLBZD 3604 16:23:45 SQL Execute: ORACLE - select * from VW_SB_CGLBZD 3605 16:23:45 SQL Prepare: ORACLE - select * from VW_SB_WHQKZD 3606 16:23:45 SQL Execute: ORACLE - select * from VW_SB_WHQKZD 3607 16:23:47 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3608 16:23:47 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3609 16:23:48 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3610 16:23:48 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3611 16:23:48 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3612 16:23:48 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3613 16:23:49 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3614 16:23:49 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3615 16:23:52 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100 3616 16:23:52 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100 3617 16:23:55 SQL Prepare: ORACLE - select BMMC00,SBLBMC,BYZJE0,DAXXID,DAH000,SBMC00,YZ0000,LJZJ00,JZ0000,KSSYSL,RZRQ00,SYNX00,CKBH00 from (select E.BMMC00,C.SBLBMC,D.BYZJE0,A.DAXXID,A.DAH000,A.SBMC00,D.TQYZ00 YZ0000,d.LJZJJE LJZJ00,d.zjhjz0 JZ0000,A.KSSYSL,A.RZRQ00,A.SYNX00,A.CKBH00, B.SBLBID,B.TJLBID,A.GG0000,A.XH0000,A.JLDW00,A.CCBH00,A.CJID00,A.CCRQ00,A.QYRQ00,A.BXQ000,F.SYZTMC,A.CFDD00,A.WHQK00,A.CGFS00,A.SHJSZJ,B.GJBM00 from SB_DA0000 A,BM_SBBM00 B,BM_SBLB00 C,SB_GDZCZJ D,BM_BMBM00 E,BM_SYZT00 F where D.TQKS00+0 = E.BMBH00 and A.SBID00 = B.SBID00 and B.SBLBID = C.SBLBID and A.DAXXID = D.DAXXID and A.SYZT00 = F.SYZT00(+) and D.TQNF00 = 2012 and D.TQYF00 = 01 ) x where 1=1 and trim(x.SBMC00) = trim('活检钳') and x.CKBH00= 169 3618 16:23:55 SQL Execute: ORACLE - select BMMC00,SBLBMC,BYZJE0,DAXXID,DAH000,SBMC00,YZ0000,LJZJ00,JZ0000,KSSYSL,RZRQ00,SYNX00,CKBH00 from (select E.BMMC00,C.SBLBMC,D.BYZJE0,A.DAXXID,A.DAH000,A.SBMC00,D.TQYZ00 YZ0000,d.LJZJJE LJZJ00,d.zjhjz0 JZ0000,A.KSSYSL,A.RZRQ00,A.SYNX00,A.CKBH00, B.SBLBID,B.TJLBID,A.GG0000,A.XH0000,A.JLDW00,A.CCBH00,A.CJID00,A.CCRQ00,A.QYRQ00,A.BXQ000,F.SYZTMC,A.CFDD00,A.WHQK00,A.CGFS00,A.SHJSZJ,B.GJBM00 from SB_DA0000 A,BM_SBBM00 B,BM_SBLB00 C,SB_GDZCZJ D,BM_BMBM00 E,BM_SYZT00 F where D.TQKS00+0 = E.BMBH00 and A.SBID00 = B.SBID00 and B.SBLBID = C.SBLBID and A.DAXXID = D.DAXXID and A.SYZT00 = F.SYZT00(+) and D.TQNF00 = 2012 and D.TQYF00 = 01 ) x where 1=1 and trim(x.SBMC00) = trim('活检钳') and x.CKBH00= 169 3619 16:24:02 SQL Prepare: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3620 16:24:02 SQL Execute: ORACLE - select * from VW_SB_SBLB00 where CKBH00 = 169 or CKBH00=0 3621 16:24:02 SQL Prepare: ORACLE - select * from VW_SB_SBTJLB where CKBH00= 169 or CKBH00=0 3622 16:24:02 SQL Execute: ORACLE - select * from VW_SB_SBTJLB where CKBH00= 169 or CKBH00=0 3623 16:24:02 SQL Prepare: ORACLE - select * from VW_SB_SYZTZD 3624 16:24:02 SQL Execute: ORACLE - select * from VW_SB_SYZTZD 3625 16:24:02 SQL Prepare: ORACLE - select * from VW_SB_ZDLBZD 3626 16:24:02 SQL Execute: ORACLE - select * from VW_SB_ZDLBZD 3627 16:24:02 SQL Prepare: ORACLE - select * from VW_SB_CGLBZD 3628 16:24:02 SQL Execute: ORACLE - select * from VW_SB_CGLBZD 3629 16:24:02 SQL Prepare: ORACLE - select * from VW_SB_WHQKZD 3630 16:24:02 SQL Execute: ORACLE - select * from VW_SB_WHQKZD 3631 16:24:04 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3632 16:24:04 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3633 16:24:05 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3634 16:24:05 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3635 16:24:05 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3636 16:24:05 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3637 16:24:05 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like :1) Order By SBBH00) where Rownum<=100 3638 16:24:05 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBBH00 Like ?) Order By SBBH00) where Rownum<=100 3639 16:24:07 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBMC00 Like :1) Order By SBMC00) where Rownum<=100 3640 16:24:07 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (SBMC00 Like ?) Order By SBMC00) where Rownum<=100 3641 16:24:08 SQL Prepare: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100 3642 16:24:08 SQL Execute: ORACLE - Select * from (select SBMC00,SBBH00,PYSM00,WBSM00,JLDW00,SYLX00,SBLBID,TJLBID,SBID00 from BM_SBBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100 3643 16:24:10 SQL Prepare: ORACLE - select BMMC00,SBLBMC,BYZJE0,DAXXID,DAH000,SBMC00,YZ0000,LJZJ00,JZ0000,KSSYSL,RZRQ00,SYNX00,CKBH00 from (select E.BMMC00,C.SBLBMC,D.BYZJE0,A.DAXXID,A.DAH000,A.SBMC00,D.TQYZ00 YZ0000,d.LJZJJE LJZJ00,d.zjhjz0 JZ0000,A.KSSYSL,A.RZRQ00,A.SYNX00,A.CKBH00, B.SBLBID,B.TJLBID,A.GG0000,A.XH0000,A.JLDW00,A.CCBH00,A.CJID00,A.CCRQ00,A.QYRQ00,A.BXQ000,F.SYZTMC,A.CFDD00,A.WHQK00,A.CGFS00,A.SHJSZJ,B.GJBM00 from SB_DA0000 A,BM_SBBM00 B,BM_SBLB00 C,SB_GDZCZJ D,BM_BMBM00 E,BM_SYZT00 F where D.TQKS00+0 = E.BMBH00 and A.SBID00 = B.SBID00 and B.SBLBID = C.SBLBID and A.DAXXID = D.DAXXID and A.SYZT00 = F.SYZT00(+) and D.TQNF00 = 2010 and D.TQYF00 = 12 ) x where 1=1 and trim(x.SBMC00) = trim('活检钳') and x.CKBH00= 169 3644 16:24:10 SQL Execute: ORACLE - select BMMC00,SBLBMC,BYZJE0,DAXXID,DAH000,SBMC00,YZ0000,LJZJ00,JZ0000,KSSYSL,RZRQ00,SYNX00,CKBH00 from (select E.BMMC00,C.SBLBMC,D.BYZJE0,A.DAXXID,A.DAH000,A.SBMC00,D.TQYZ00 YZ0000,d.LJZJJE LJZJ00,d.zjhjz0 JZ0000,A.KSSYSL,A.RZRQ00,A.SYNX00,A.CKBH00, B.SBLBID,B.TJLBID,A.GG0000,A.XH0000,A.JLDW00,A.CCBH00,A.CJID00,A.CCRQ00,A.QYRQ00,A.BXQ000,F.SYZTMC,A.CFDD00,A.WHQK00,A.CGFS00,A.SHJSZJ,B.GJBM00 from SB_DA0000 A,BM_SBBM00 B,BM_SBLB00 C,SB_GDZCZJ D,BM_BMBM00 E,BM_SYZT00 F where D.TQKS00+0 = E.BMBH00 and A.SBID00 = B.SBID00 and B.SBLBID = C.SBLBID and A.DAXXID = D.DAXXID and A.SYZT00 = F.SYZT00(+) and D.TQNF00 = 2010 and D.TQYF00 = 12 ) x where 1=1 and trim(x.SBMC00) = trim('活检钳') and x.CKBH00= 169 3645 16:24:54 SQL Prepare: ORACLE - select to_date(QYRQ00,'yyyymmdd')QYRQ00,SHJSZJ from sb_da0000 where daxxid='37701' 3646 16:24:54 SQL Execute: ORACLE - select to_date(QYRQ00,'yyyymmdd')QYRQ00,SHJSZJ from sb_da0000 where daxxid='37701' 3647 16:24:54 SQL Prepare: ORACLE - select E.ZDMC00,C.SBLBMC,D.TJLBMC,F.CGFSMC,G.WHQKMC, A.* , (select sccjid from sb_rckmx0 where rcmxid = a.rcmxid) sccjid from sb_da0000 A,bm_sbbm00 B,bm_sblb00 C,bm_sbtjlb D,BM_ZDZH00 E,BM_CGFS00 F,BM_WHQK00 G where A.sbid00 = B.sbid00 and B.SBLBID = C.SBLBID(+) and B.TJLBID = D.TJLBID(+) and A.JDLB00 = E.ZDID00(+) and A.DAXXID =:1 and A.CGFS00 = F.CGFS00(+) and A.WHQK00 = G.WHQK00(+) 3648 16:24:54 SQL Execute: ORACLE - select E.ZDMC00,C.SBLBMC,D.TJLBMC,F.CGFSMC,G.WHQKMC, A.* , (select sccjid from sb_rckmx0 where rcmxid = a.rcmxid) sccjid from sb_da0000 A,bm_sbbm00 B,bm_sblb00 C,bm_sbtjlb D,BM_ZDZH00 E,BM_CGFS00 F,BM_WHQK00 G where A.sbid00 = B.sbid00 and B.SBLBID = C.SBLBID(+) and B.TJLBID = D.TJLBID(+) and A.JDLB00 = E.ZDID00(+) and A.DAXXID =? and A.CGFS00 = F.CGFS00(+) and A.WHQK00 = G.WHQK00(+) 3649 16:24:54 SQL Prepare: ORACLE - select * from sb_da0000 where JDBZ00='2' and daxxid=37701 3650 16:24:54 SQL Execute: ORACLE - select * from sb_da0000 where JDBZ00='2' and daxxid=37701 3651 16:24:54 SQL Prepare: ORACLE - select * from sb_gdzczj where daxxid = 37701 3652 16:24:54 SQL Execute: ORACLE - select * from sb_gdzczj where daxxid = 37701 3653 16:24:54 SQL Prepare: ORACLE - select * from BM_YGBM00 where YGBH00 =:1 3654 16:24:54 SQL Execute: ORACLE - select * from BM_YGBM00 where YGBH00 =? 3655 16:24:54 SQL Prepare: ORACLE - select * from BM_BMBM00 where BMBH00 =:1 3656 16:24:54 SQL Execute: ORACLE - select * from BM_BMBM00 where BMBH00 =? 3657 16:24:54 SQL Prepare: ORACLE - select * from BM_BMBM00 where BMBH00 =:1 3658 16:24:54 SQL Execute: ORACLE - select * from BM_BMBM00 where BMBH00 =? 3659 16:24:54 SQL Prepare: ORACLE - select * from VW_SB_ZJFFZD where 1 = 1 and ID0000 = 27 3660 16:24:54 SQL Execute: ORACLE - select * from VW_SB_ZJFFZD where 1 = 1 and ID0000 = 27 3661 16:24:54 SQL Prepare: ORACLE - select * from VW_SB_JJYTZD 3662 16:24:54 SQL Execute: ORACLE - select * from VW_SB_JJYTZD 3663 16:24:54 SQL Prepare: ORACLE - select * from VW_SB_ZDLBZD 3664 16:24:54 SQL Execute: ORACLE - select * from VW_SB_ZDLBZD 3665 16:24:54 SQL Prepare: ORACLE - select * from VW_SB_CGLBZD 3666 16:24:54 SQL Execute: ORACLE - select * from VW_SB_CGLBZD 3667 16:24:54 SQL Prepare: ORACLE - select * from VW_SB_WHQKZD 3668 16:24:54 SQL Execute: ORACLE - select * from VW_SB_WHQKZD 3669 16:30:47 Log started for: 药库管理系统 3670 16:30:47 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','821','41070' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 3671 16:30:47 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','821','41070' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 3672 16:30:47 SQL Prepare: ORACLE - Commit 3673 16:30:47 SQL Execute: ORACLE - Commit 3674 16:30:47 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3675 16:30:47 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3676 16:30:47 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 3677 16:30:47 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 3678 16:30:47 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3679 16:30:47 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3680 16:30:47 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3681 16:30:47 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3682 16:30:47 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','754','56204' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 3683 16:30:47 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','754','56204' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 3684 16:30:47 SQL Prepare: ORACLE - Commit 3685 16:30:47 SQL Execute: ORACLE - Commit 3686 16:30:47 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3' 3687 16:30:47 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3' 3688 16:30:47 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3689 16:30:47 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3690 16:30:47 SQL Prepare: ORACLE - Select SYSDATE from Dual 3691 16:30:47 SQL Execute: ORACLE - Select SYSDATE from Dual 3692 16:30:47 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 3693 16:30:47 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 3694 16:30:47 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3695 16:30:47 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3696 16:30:47 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3' 3697 16:30:47 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3' 3698 16:30:47 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3699 16:30:47 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3700 16:30:47 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 3701 16:30:47 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 3702 16:30:47 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3' 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 ('6') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 3703 16:30:47 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3' 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 ('6') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 3704 16:30:49 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '3' 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='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 3705 16:30:49 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '3' 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='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 3706 16:30:49 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 3707 16:30:49 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 3708 16:30:49 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3709 16:30:49 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3710 16:30:49 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 3711 16:30:49 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 3712 16:30:49 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 3713 16:30:49 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 3714 16:30:49 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 3715 16:30:49 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 3716 16:30:49 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 3717 16:30:49 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')) 3718 16:30:49 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899216,476,'wlzx-3','3',nvl('37706179',' '),'192.168.12.120#754:56204@appYP_YK.exe+药库管理系统',12) 3719 16:30:49 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899216,476,'wlzx-3','3',nvl('37706179',' '),'192.168.12.120#754:56204@appYP_YK.exe+药库管理系统',12) 3720 16:30:49 SQL Prepare: ORACLE - Commit 3721 16:30:49 SQL Execute: ORACLE - Commit 3722 16:30:49 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12 3723 16:30:49 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12 3724 16:30:49 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 3725 16:30:49 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 3726 16:30:49 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 3727 16:30:49 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 3728 16:30:49 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 3729 16:30:49 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 3730 16:30:49 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 3731 16:30:49 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 3732 16:30:49 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 12 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 3733 16:30:49 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 12 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 3734 16:30:49 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 3735 16:30:49 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 3736 16:30:49 SQL Prepare: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 3737 16:30:49 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 3738 16:30:49 SQL Prepare: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 3739 16:30:49 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 3740 16:30:49 SQL Prepare: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 3741 16:30:49 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 3742 16:30:49 SQL Prepare: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 3743 16:30:49 SQL Execute: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 3744 16:30:49 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3745 16:30:49 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3746 16:30:49 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 3747 16:30:49 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 3748 16:30:49 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 ) 3749 16:30:49 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 ) 3750 16:30:49 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3751 16:30:49 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3752 16:30:49 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3753 16:30:49 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3754 16:30:50 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12 3755 16:30:50 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12 3756 16:30:50 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID' 3757 16:30:50 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID' 3758 16:30:50 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID' 3759 16:30:50 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID' 3760 16:30:50 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID' 3761 16:30:50 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID' 3762 16:30:50 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED' 3763 16:30:50 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED' 3764 16:30:50 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_triggers where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED' 3765 16:30:50 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_triggers where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED' 3766 16:30:50 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%' 3767 16:30:50 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%' 3768 16:30:50 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 3769 16:30:50 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 3770 16:30:50 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='3'))) 3771 16:30:50 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='3'))) 3772 16:30:50 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||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 3773 16:30:50 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||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 3774 16:30:50 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 3775 16:30:50 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 '))) 3776 16:30:50 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 3777 16:30:50 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 3778 16:30:50 SQL Prepare: 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='+ '))) 3779 16:30:50 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='+ '))) 3780 16:30:50 SQL Prepare: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 3781 16:30:50 SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 3782 16:30:50 SQL Prepare: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX WHERE YKBMBH=12 AND KCSL00 '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 3827 16:31:00 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 3828 16:31:00 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='2' 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 ('2','3') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 3829 16:31:00 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='2' 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 ('2','3') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 3830 16:31:02 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' 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='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 3831 16:31:02 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' 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='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 3832 16:31:02 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 3833 16:31:02 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 3834 16:31:02 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3835 16:31:02 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3836 16:31:02 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 3837 16:31:02 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 3838 16:31:02 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 3839 16:31:02 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 3840 16:31:02 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 3841 16:31:02 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 3842 16:31:02 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 3843 16:31:02 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 3844 16:31:02 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899217,476,'wlzx-3','2',nvl('37706184',' '),'192.168.12.120#754:56285@appYP_YF.exe+药房管理系统',70) 3845 16:31:02 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2899217,476,'wlzx-3','2',nvl('37706184',' '),'192.168.12.120#754:56285@appYP_YF.exe+药房管理系统',70) 3846 16:31:02 SQL Prepare: ORACLE - Commit 3847 16:31:02 SQL Execute: ORACLE - Commit 3848 16:31:02 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 70 3849 16:31:02 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 70 3850 16:31:02 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 3851 16:31:02 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 3852 16:31:02 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 3853 16:31:02 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 3854 16:31:02 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 3855 16:31:02 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 3856 16:31:02 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 3857 16:31:02 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 3858 16:31:02 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 70 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 3859 16:31:02 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 70 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 3860 16:31:02 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 3861 16:31:02 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 3862 16:31:02 SQL Prepare: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 3863 16:31:02 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 3864 16:31:02 SQL Prepare: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 3865 16:31:02 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 3866 16:31:02 SQL Prepare: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 3867 16:31:02 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 3868 16:31:02 SQL Prepare: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 3869 16:31:02 SQL Execute: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 3870 16:31:02 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3871 16:31:02 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3872 16:31:02 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 3873 16:31:02 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 3874 16:31:02 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',70,' )>0 ) 3875 16:31:02 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20120131' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',70,' )>0 ) 3876 16:31:02 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3877 16:31:02 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3878 16:31:02 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3879 16:31:02 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3880 16:31:03 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 3881 16:31:03 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 3882 16:31:03 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 3883 16:31:03 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 3884 16:31:03 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 3885 16:31:03 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 3886 16:31:03 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=70 3887 16:31:03 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=70 3888 16:31:03 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 3889 16:31:03 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 3890 16:31:03 SQL Prepare: ORACLE - select * from XT_XTCS00 3891 16:31:03 SQL Execute: ORACLE - select * from XT_XTCS00 3892 16:31:05 SQL Prepare: ORACLE - select * from BM_YPLB00 3893 16:31:05 SQL Execute: ORACLE - select * from BM_YPLB00 3894 16:31:05 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 3895 16:31:05 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 3896 16:31:05 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='2' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='2'))) 3897 16:31:05 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='2' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='2'))) 3898 16:31:05 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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 3899 16:31:05 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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 3900 16:31:05 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 3901 16:31:05 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 '))) 3902 16:31:05 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 3903 16:31:05 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 3904 16:31:05 SQL Prepare: 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='+ '))) 3905 16:31:05 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='+ '))) 3906 16:31:05 SQL Prepare: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 3907 16:31:05 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 3908 16:31:05 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 3909 16:31:05 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 3910 16:31:05 SQL Prepare: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=70 AND YKKCSL'0' 3911 16:31:05 SQL Execute: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=70 AND YKKCSL'0' 3912 16:31:07 SQL Prepare: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=70 and X.SFQR00='N' and T.SFQR00='Y' 3913 16:31:07 SQL Execute: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=70 and X.SFQR00='N' and T.SFQR00='Y' 3914 16:31:14 SQL Prepare: ORACLE - SELECT X.* FROM VW_YF_YPRKCX X,BM_YD0000 D WHERE X.YFBMBH=:1 AND X.RKZT00<>'0' AND X.QRRQ00>=:2 AND X.YPNM00=D.YPNM00 AND X.QRRQ00<=:3 AND X.QRRQ00||X.QRSJ00>=:4 AND X.QRRQ00||X.QRSJ00<=:5 ORDER BY X.RKLXMC,X.RKDH00,X.YPRKPC 3915 16:31:14 SQL Execute: ORACLE - SELECT X.* FROM VW_YF_YPRKCX X,BM_YD0000 D WHERE X.YFBMBH=? AND X.RKZT00<>'0' AND X.QRRQ00>=? AND X.YPNM00=D.YPNM00 AND X.QRRQ00<=? AND X.QRRQ00||X.QRSJ00>=? AND X.QRRQ00||X.QRSJ00<=? ORDER BY X.RKLXMC,X.RKDH00,X.YPRKPC 3916 16:31:25 SQL Prepare: ORACLE - SELECT X.* FROM VW_YF_YPRKCX X,BM_YD0000 D WHERE X.YFBMBH=:1 AND X.RKZT00<>'0' AND X.QRRQ00>=:2 AND X.YPNM00=D.YPNM00 AND X.QRRQ00<=:3 AND X.QRRQ00||X.QRSJ00>=:4 AND X.QRRQ00||X.QRSJ00<=:5 ORDER BY X.RKLXMC,X.RKDH00,X.YPRKPC 3917 16:31:25 SQL Execute: ORACLE - SELECT X.* FROM VW_YF_YPRKCX X,BM_YD0000 D WHERE X.YFBMBH=? AND X.RKZT00<>'0' AND X.QRRQ00>=? AND X.YPNM00=D.YPNM00 AND X.QRRQ00<=? AND X.QRRQ00||X.QRSJ00>=? AND X.QRRQ00||X.QRSJ00<=? ORDER BY X.RKLXMC,X.RKDH00,X.YPRKPC 3918 16:31:42 SQL Prepare: ORACLE - SELECT R.RKDH00,R.RKRQ00,R.QRRQ00,L.RKLXMC,G.BMMC00, X.YPMC00,X.YPGG00,X.RKDW00,X.RKSL00,X.GJDJ00,X.LSDJ00, ROUND(X.RKSL00*X.LSDJ00,2) AS LSJE00, ROUND(X.RKSL00*X.GJDJ00,2) AS GJJE00, ROUND(X.RKSL00*X.LSDJ00,2)-ROUND(X.RKSL00*X.GJDJ00,2) AS JXCJ00 FROM YF_YPRKD0 R,VW_YF_YPGHDW G,BM_YFRKLX L,YF_YPRKMX X WHERE R.RKDH00=X.RKDH00 AND R.RKBMBH=G.BMBH00 AND R.RKLXBH=L.RKLXBH(+) AND R.RKDH00='134920' 3919 16:31:42 SQL Execute: ORACLE - SELECT R.RKDH00,R.RKRQ00,R.QRRQ00,L.RKLXMC,G.BMMC00, X.YPMC00,X.YPGG00,X.RKDW00,X.RKSL00,X.GJDJ00,X.LSDJ00, ROUND(X.RKSL00*X.LSDJ00,2) AS LSJE00, ROUND(X.RKSL00*X.GJDJ00,2) AS GJJE00, ROUND(X.RKSL00*X.LSDJ00,2)-ROUND(X.RKSL00*X.GJDJ00,2) AS JXCJ00 FROM YF_YPRKD0 R,VW_YF_YPGHDW G,BM_YFRKLX L,YF_YPRKMX X WHERE R.RKDH00=X.RKDH00 AND R.RKBMBH=G.BMBH00 AND R.RKLXBH=L.RKLXBH(+) AND R.RKDH00='134920' 3920 16:31:46 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 3921 16:31:46 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL