1 08:32:22 Log started for: 健康体检系统 2 08:32:22 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','T','MedicalExa.exe'||'+'||'健康体检系统','203','15180' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual 3 08:32:22 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','T','MedicalExa.exe'||'+'||'健康体检系统','203','15180' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual 4 08:32:22 SQL Data In: ORACLE - Rows affected = 1 5 08:32:22 SQL Prepare: ORACLE - Commit 6 08:32:22 SQL Execute: ORACLE - Commit 7 08:32:22 SQL Data In: ORACLE - Rows affected = 0 8 08:32:22 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 08:32:22 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 08:32:22 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 11 08:32:22 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 08:32:22 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 13 08:32:22 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 14 08:32:22 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 15 08:32:22 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 16 08:32:22 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','T','MedicalExa.exe'||'+'||'健康体检系统','656','46814' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual 17 08:32:22 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','T','MedicalExa.exe'||'+'||'健康体检系统','656','46814' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual 18 08:32:22 SQL Data In: ORACLE - Rows affected = 1 19 08:32:22 SQL Prepare: ORACLE - Commit 20 08:32:22 SQL Execute: ORACLE - Commit 21 08:32:22 SQL Data In: ORACLE - Rows affected = 0 22 08:32:22 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 23 08:32:22 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 24 08:32:22 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 25 08:32:22 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 26 08:32:22 SQL Prepare: ORACLE - Select SYSDATE from Dual 27 08:32:22 SQL Execute: ORACLE - Select SYSDATE from Dual 28 08:32:22 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 29 08:32:22 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 30 08:32:22 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 31 08:32:22 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 32 08:32:22 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 33 08:32:22 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 34 08:32:22 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 35 08:32:22 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 36 08:32:22 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 37 08:32:22 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 38 08:32:22 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) order by b.PLXH00,a.BH0000 39 08:32:22 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) order by b.PLXH00,a.BH0000 40 08:32:22 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '343'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 41 08:32:22 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '343'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 42 08:32:22 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 43 08:32:22 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 44 08:32:23 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 45 08:32:23 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 46 08:32:23 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 47 08:32:23 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 48 08:32:23 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 49 08:32:23 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 50 08:32:23 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 51 08:32:23 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 52 08:32:23 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')) 53 08:32:23 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')) 54 08:32:23 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3978178,1143,'wlzx-1','T',nvl('227107516',' '),'192.168.5.22#656:46814@MedicalExa.exe+健康体检系统',125) 55 08:32:23 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3978178,1143,'wlzx-1','T',nvl('227107516',' '),'192.168.5.22#656:46814@MedicalExa.exe+健康体检系统',125) 56 08:32:23 SQL Data In: ORACLE - Rows affected = 1 57 08:32:23 SQL Prepare: ORACLE - Commit 58 08:32:23 SQL Execute: ORACLE - Commit 59 08:32:23 SQL Data In: ORACLE - Rows affected = 0 60 08:32:23 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 61 08:32:23 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 62 08:32:23 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 63 08:32:23 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 64 08:32:23 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 65 08:32:23 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 66 08:32:23 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 67 08:32:23 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 68 08:32:23 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 69 08:32:23 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 70 08:32:23 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 125 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 71 08:32:23 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 125 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 72 08:32:23 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 73 08:32:23 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 74 08:32:23 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 75 08:32:23 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 76 08:32:26 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 77 08:32:26 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 78 08:32:26 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 79 08:32:26 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 80 08:32:26 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140210' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='T') 81 08:32:26 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140210' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='T') 82 08:32:26 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 83 08:32:26 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 84 08:32:26 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 85 08:32:26 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 86 08:32:26 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='T'))) 87 08:32:26 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='T'))) 88 08:32:26 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 89 08:32:26 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 90 08:32:26 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 91 08:32:26 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 92 08:32:26 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 93 08:32:26 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 94 08:32:26 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 95 08:32:26 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 96 08:32:26 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 97 08:32:26 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 98 08:32:26 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 99 08:32:26 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 100 08:32:26 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '1143' 101 08:32:26 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '1143' 102 08:32:26 SQL Prepare: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 103 08:32:26 SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 104 08:32:26 SQL Prepare: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID') 105 08:32:26 SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID') 106 08:32:26 SQL Prepare: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 107 08:32:26 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 108 08:32:32 SQL Prepare: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZJTQYS' 109 08:32:32 SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZJTQYS' 110 08:32:38 SQL Prepare: ORACLE - SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = (SELECT GHID00 FROM SF_BRXXB0 WHERE GHH000 = '6502979' AND ROWNUM = 1) 111 08:32:38 SQL Execute: ORACLE - SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = (SELECT GHID00 FROM SF_BRXXB0 WHERE GHH000 = '6502979' AND ROWNUM = 1) 112 08:32:38 SQL Prepare: ORACLE - select a.ghid00 from tj_brxxb0 a,sf_brxxb0 b where a.grghid=b.ghid00 and b.ghh000='6502979' 113 08:32:38 SQL Execute: ORACLE - select a.ghid00 from tj_brxxb0 a,sf_brxxb0 b where a.grghid=b.ghid00 and b.ghh000='6502979' 114 08:32:38 SQL Prepare: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE GHID00>0 AND GHID00=(select ghid00 from sf_brxxb0 where ghh000='6502979') 115 08:32:38 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE GHID00>0 AND GHID00=(select ghid00 from sf_brxxb0 where ghh000='6502979') 116 08:32:38 SQL Prepare: ORACLE - select GRGHID from TJ_BRXXB0 where GHID00=12982350 117 08:32:38 SQL Execute: ORACLE - select GRGHID from TJ_BRXXB0 where GHID00=12982350 118 08:32:38 SQL Prepare: ORACLE - SELECT TRIM(NVL(LQQK00,'')) FROM TJ_BRXXB0 WHERE GHID00 = '12982350' 119 08:32:38 SQL Execute: ORACLE - SELECT TRIM(NVL(LQQK00,'')) FROM TJ_BRXXB0 WHERE GHID00 = '12982350' 120 08:32:38 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3685783' 121 08:32:38 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3685783' 122 08:32:38 SQL Prepare: ORACLE - BEGIN "SP_TJ_INSTJ_TJBG00" (PGHID00 => :PGHID00,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PYYID00 => :PYYID00); END; 123 08:32:38 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 12982350 124 08:32:38 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 125 08:32:38 SQL Data In: ORACLE - Param = 3, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨家秀 126 08:32:38 SQL Data In: ORACLE - Param = 4, Name = PYYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137 127 08:32:38 SQL Execute: ORACLE - BEGIN "SP_TJ_INSTJ_TJBG00" (PGHID00 => :PGHID00,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PYYID00 => :PYYID00); END; 128 08:32:38 SQL Prepare: ORACLE - select lpad(ksbh00,5,' ')||zlxmid ksxmid,zlxmid,nvl(yjdjh0,0) yjdjh0, ksbh00,zlxmjc,xh0000,lbbh00,bgys00,CKSBH0,YYID00 ,KSLX00, JGHQFS from ( select mc0000 zlxmjc,a.ksbh00,xh0000,0 zlxmid,0 yjdjh0, DECODE(LX0000,'2','4','0') lbbh00,a.bgys00,A.CKSBH0, B.YYID00, KSLX00, NULL JGHQFS from tj_kslb00 a, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = D.ZLXMID AND ROWNUM = 1 AND BH0000 = D.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = D.KSBH00) KSLX00 from tj_tjbg00 D where ghid00=12982350) b where a.ksbh00=b.ksbh00 union select zlxmjc zlxmjc,b.ksbh00,c.xh0000,a.zlxmid,b.yjdjh0, TO_CHAR(a.lbbh00) LBBH00,c.bgys00,C.CKSBH0, B.YYID00, KSLX00, JGHQFS from bm_zlzd00 a,tj_kslb00 c, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND ROWNUM = 1 AND BH0000 = E.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = E.KSBH00) KSLX00, (SELECT JGHQFS FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND BH0000 = E.KSBH00) JGHQFS from tj_tjbg00 E where ghid00=12982350) b where a.zlxmid=b.zlxmid and b.ksbh00=c.ksbh00 AND A.ZLXMID IN (SELECT ZLXMID FROM TJ_ZHXM00 WHERE SFYX00 = 'Y') ) where 1=1 AND YYID00 = '222137' order by xh0000,ksbh00,zlxmid, yjdjh0 129 08:32:38 SQL Execute: ORACLE - select lpad(ksbh00,5,' ')||zlxmid ksxmid,zlxmid,nvl(yjdjh0,0) yjdjh0, ksbh00,zlxmjc,xh0000,lbbh00,bgys00,CKSBH0,YYID00 ,KSLX00, JGHQFS from ( select mc0000 zlxmjc,a.ksbh00,xh0000,0 zlxmid,0 yjdjh0, DECODE(LX0000,'2','4','0') lbbh00,a.bgys00,A.CKSBH0, B.YYID00, KSLX00, NULL JGHQFS from tj_kslb00 a, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = D.ZLXMID AND ROWNUM = 1 AND BH0000 = D.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = D.KSBH00) KSLX00 from tj_tjbg00 D where ghid00=12982350) b where a.ksbh00=b.ksbh00 union select zlxmjc zlxmjc,b.ksbh00,c.xh0000,a.zlxmid,b.yjdjh0, TO_CHAR(a.lbbh00) LBBH00,c.bgys00,C.CKSBH0, B.YYID00, KSLX00, JGHQFS from bm_zlzd00 a,tj_kslb00 c, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND ROWNUM = 1 AND BH0000 = E.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = E.KSBH00) KSLX00, (SELECT JGHQFS FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND BH0000 = E.KSBH00) JGHQFS from tj_tjbg00 E where ghid00=12982350) b where a.zlxmid=b.zlxmid and b.ksbh00=c.ksbh00 AND A.ZLXMID IN (SELECT ZLXMID FROM TJ_ZHXM00 WHERE SFYX00 = 'Y') ) where 1=1 AND YYID00 = '222137' order by xh0000,ksbh00,zlxmid, yjdjh0 130 08:32:38 SQL Prepare: ORACLE - select GHID00,TJJL00,TJJY00,ZJYS00,ZJYSXM,BGRQ00,FCRQ00,CZY000,CZYXM0,TJSGJL from VW_TJ_BRXXB0 where GHID00='12982350' 131 08:32:38 SQL Execute: ORACLE - select GHID00,TJJL00,TJJY00,ZJYS00,ZJYSXM,BGRQ00,FCRQ00,CZY000,CZYXM0,TJSGJL from VW_TJ_BRXXB0 where GHID00='12982350' 132 08:32:38 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 = 'VW_TJ_TJJYB0' order by 1 ASC, 2 ASC 133 08:32:38 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 = 'VW_TJ_TJJYB0' order by 1 ASC, 2 ASC 134 08:32:38 SQL Prepare: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'VW_TJ_TJJYB0' order by owner ASC, index_name ASC 135 08:32:38 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'VW_TJ_TJJYB0' order by owner ASC, index_name ASC 136 08:32:39 SQL Prepare: ORACLE - SELECT "ID0000", "DWID00", "BRID00", "GHID00", "GHH000", "ICD900", "JBMC00", "JY0000", "SFDDDY" FROM "VW_TJ_TJJYB0" WHERE ((("DWID00") = ('0')) AND (("BRID00") = ('3685783'))) AND (("GHID00") = ('12982350')) 137 08:32:39 SQL Execute: ORACLE - SELECT "ID0000", "DWID00", "BRID00", "GHID00", "GHH000", "ICD900", "JBMC00", "JY0000", "SFDDDY" FROM "VW_TJ_TJJYB0" WHERE ((("DWID00") = ('0')) AND (("BRID00") = ('3685783'))) AND (("GHID00") = ('12982350')) 138 08:32:39 SQL Prepare: ORACLE - select JYJZKS,(select BMMC00 from BM_BMBM00 where BMBH00=JYJZKS) JYKSMC, JYJZYS,(select ZWXM00 from BM_YGBM00 where YGBH00=JYJZYS) JYYSXM, JYKS01,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS01) JYMC01, JYYS01,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS01) JYXM01, JYKS02,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS02) JYMC02, JYYS02,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS02) JYXM02, JYKS03,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS03) JYMC03, JYYS03,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS03) JYXM03, JYKS04,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS04) JYMC04, JYYS04,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS04) JYXM04 from TJ_BRXXB0 a where GHID00='12982350' 139 08:32:39 SQL Execute: ORACLE - select JYJZKS,(select BMMC00 from BM_BMBM00 where BMBH00=JYJZKS) JYKSMC, JYJZYS,(select ZWXM00 from BM_YGBM00 where YGBH00=JYJZYS) JYYSXM, JYKS01,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS01) JYMC01, JYYS01,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS01) JYXM01, JYKS02,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS02) JYMC02, JYYS02,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS02) JYXM02, JYKS03,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS03) JYMC03, JYYS03,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS03) JYXM03, JYKS04,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS04) JYMC04, JYYS04,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS04) JYXM04 from TJ_BRXXB0 a where GHID00='12982350' 140 08:32:39 SQL Prepare: ORACLE - select * from TJ_JKZJG0 where ghid00=12982350 141 08:32:39 SQL Execute: ORACLE - select * from TJ_JKZJG0 where ghid00=12982350 142 08:32:39 SQL Prepare: ORACLE - SELECT C.* FROM ( select yjdjh0,yjfzh0,a.zlxmid,b.zlxmjc,b.lbbh00,xmzt00,SL0000,YJKSBH, DECODE(XMZT00,'0','已申请','1','已计价','2','已收费','3','已执行', '6','已作废','7','已退费','D','已取消') XMZTMC, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = A.ZLXMID AND ROWNUM = 1 AND BH0000 = A.YJKSBH) YYID00 from TJ_YJDJH0 a,bm_zlzd00 b where a.zlxmid=b.zlxmid and xmzt00 in('0','1','2','6','D') and (not exists (select 'y' from yj_yw0000 c where c.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and (ghid00='12982350' or ghid00='') ) C WHERE YYID00 = '222137' 143 08:32:39 SQL Execute: ORACLE - SELECT C.* FROM ( select yjdjh0,yjfzh0,a.zlxmid,b.zlxmjc,b.lbbh00,xmzt00,SL0000,YJKSBH, DECODE(XMZT00,'0','已申请','1','已计价','2','已收费','3','已执行', '6','已作废','7','已退费','D','已取消') XMZTMC, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = A.ZLXMID AND ROWNUM = 1 AND BH0000 = A.YJKSBH) YYID00 from TJ_YJDJH0 a,bm_zlzd00 b where a.zlxmid=b.zlxmid and xmzt00 in('0','1','2','6','D') and (not exists (select 'y' from yj_yw0000 c where c.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and (ghid00='12982350' or ghid00='') ) C WHERE YYID00 = '222137' 144 08:32:39 SQL Prepare: ORACLE - select * from ( select SJLX00,BGID00,XSSX00,A.ZLXMID,A.YJDJH0,A.JCXMID,XXZ000,SXZ000,XXTS00,SXTS00,CKZ000,JCRQ00,SFCSTS,XMMC00,CDZ000,DW0000,JGSM00,JCYS00,JCYSXM,B.XH0000 ZLXMXH,SFJRXJ,CDMS00,ICD900,JBMC00,A.SFDY00 from VW_TJ_TJBG00_DIS A,TJ_ZHXM00 B where A.ZLXMID=B.ZLXMID AND GHID00='12982350' and A.KSBH00='33' AND A.KSBH00=B.BH0000 UNION select 'C' SJLX00,0 BGID00,0 XSSX00,A.ZLXMID,C.YJDJH0,0 JCXMID,0 XXZ000,0 SXZ000,'' XXTS00,'' SXTS00,'' CKZ000,C.JCRQ00,'' SFCSTS,B.ZLXMJC XMMC00,'' CDZ000,'' DW0000,'' JGSM00,C.JCYS00,C.JCYSXM,A.XH0000 ZLXMXH,'N' SFJRXJ,'' CDMS00,'' ICD900,'' JBMC00,'N' SFDY00 from TJ_ZHXM00 A,BM_ZLZD00 B,VW_TJ_TJBG00_DIS C WHERE C.GHID00='12982350' and C.KSBH00='33' and A.ZLXMID=B.ZLXMID AND A.ZLXMID=C.ZLXMID and A.BH0000=C.KSBH00 and ((exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is not null) or (not exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is null)) )order by ZLXMXH,ZLXMID,YJDJH0,XSSX00 145 08:32:39 SQL Execute: ORACLE - select * from ( select SJLX00,BGID00,XSSX00,A.ZLXMID,A.YJDJH0,A.JCXMID,XXZ000,SXZ000,XXTS00,SXTS00,CKZ000,JCRQ00,SFCSTS,XMMC00,CDZ000,DW0000,JGSM00,JCYS00,JCYSXM,B.XH0000 ZLXMXH,SFJRXJ,CDMS00,ICD900,JBMC00,A.SFDY00 from VW_TJ_TJBG00_DIS A,TJ_ZHXM00 B where A.ZLXMID=B.ZLXMID AND GHID00='12982350' and A.KSBH00='33' AND A.KSBH00=B.BH0000 UNION select 'C' SJLX00,0 BGID00,0 XSSX00,A.ZLXMID,C.YJDJH0,0 JCXMID,0 XXZ000,0 SXZ000,'' XXTS00,'' SXTS00,'' CKZ000,C.JCRQ00,'' SFCSTS,B.ZLXMJC XMMC00,'' CDZ000,'' DW0000,'' JGSM00,C.JCYS00,C.JCYSXM,A.XH0000 ZLXMXH,'N' SFJRXJ,'' CDMS00,'' ICD900,'' JBMC00,'N' SFDY00 from TJ_ZHXM00 A,BM_ZLZD00 B,VW_TJ_TJBG00_DIS C WHERE C.GHID00='12982350' and C.KSBH00='33' and A.ZLXMID=B.ZLXMID AND A.ZLXMID=C.ZLXMID and A.BH0000=C.KSBH00 and ((exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is not null) or (not exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is null)) )order by ZLXMXH,ZLXMID,YJDJH0,XSSX00 146 08:32:39 SQL Prepare: ORACLE - select * from TJ_TJXJB0 where GHID00='12982350' and KSBH00='33' and SFDDDY='N' 147 08:32:39 SQL Execute: ORACLE - select * from TJ_TJXJB0 where GHID00='12982350' and KSBH00='33' and SFDDDY='N' 148 08:32:39 SQL Prepare: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='12982350' and ksbh00='33' order by ID0000 149 08:32:39 SQL Execute: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='12982350' and ksbh00='33' order by ID0000 150 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=33 and ZLXMID=3963 and YJDJH0=16275600 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 151 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=33 and ZLXMID=3963 and YJDJH0=16275600 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 152 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=38 and ZLXMID=3963 and YJDJH0=16275600 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 153 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=38 and ZLXMID=3963 and YJDJH0=16275600 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 154 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=48 and ZLXMID=4273 and YJDJH0=16275628 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 155 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=48 and ZLXMID=4273 and YJDJH0=16275628 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 156 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_PACSJG where ghid00=12982350 and KSBH00=48 and ZLXMID=4273 and YJDJH0=16275628 and JCRQ00 IS NOT NULL and rownum=1 157 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12982350 and KSBH00=48 and ZLXMID=4273 and YJDJH0=16275628 and JCRQ00 IS NOT NULL and rownum=1 158 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=50 and ZLXMID=19373 and YJDJH0=16275611 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 159 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=50 and ZLXMID=19373 and YJDJH0=16275611 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 160 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=47 and ZLXMID=3966 and YJDJH0=16275679 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 161 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=47 and ZLXMID=3966 and YJDJH0=16275679 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 162 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_PACSJG where ghid00=12982350 and KSBH00=47 and ZLXMID=3966 and YJDJH0=16275679 and JCRQ00 IS NOT NULL and rownum=1 163 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12982350 and KSBH00=47 and ZLXMID=3966 and YJDJH0=16275679 and JCRQ00 IS NOT NULL and rownum=1 164 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3014 and YJDJH0=16275601 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 165 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3014 and YJDJH0=16275601 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 166 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3016 and YJDJH0=16275604 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 167 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3016 and YJDJH0=16275604 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 168 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3921 and YJDJH0=16275605 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 169 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3921 and YJDJH0=16275605 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 170 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=4531 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 171 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=4531 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 172 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=5207 and YJDJH0=16275624 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 173 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=5207 and YJDJH0=16275624 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 174 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17105 and YJDJH0=16275606 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 175 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17105 and YJDJH0=16275606 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 176 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17170 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 177 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17170 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 178 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17173 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 179 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17173 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 180 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17183 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 181 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17183 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 182 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17207 and YJDJH0=16275606 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 183 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17207 and YJDJH0=16275606 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 184 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16275621 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 185 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16275621 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 186 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22599 and YJDJH0=16275635 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 187 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22599 and YJDJH0=16275635 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 188 08:32:39 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22767 and YJDJH0=16275613 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 189 08:32:39 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22767 and YJDJH0=16275613 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 190 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=33 and ZLXMID=3963 and YJDJH0=16275600 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 191 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=33 and ZLXMID=3963 and YJDJH0=16275600 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 192 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=38 and ZLXMID=3963 and YJDJH0=16275600 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 193 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=38 and ZLXMID=3963 and YJDJH0=16275600 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 194 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=48 and ZLXMID=4273 and YJDJH0=16275628 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 195 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=48 and ZLXMID=4273 and YJDJH0=16275628 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 196 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_PACSJG where ghid00=12982350 and KSBH00=48 and ZLXMID=4273 and YJDJH0=16275628 and JCRQ00 IS NOT NULL and rownum=1 197 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12982350 and KSBH00=48 and ZLXMID=4273 and YJDJH0=16275628 and JCRQ00 IS NOT NULL and rownum=1 198 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=50 and ZLXMID=19373 and YJDJH0=16275611 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 199 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=50 and ZLXMID=19373 and YJDJH0=16275611 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 200 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=47 and ZLXMID=3966 and YJDJH0=16275679 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 201 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=47 and ZLXMID=3966 and YJDJH0=16275679 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 202 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_PACSJG where ghid00=12982350 and KSBH00=47 and ZLXMID=3966 and YJDJH0=16275679 and JCRQ00 IS NOT NULL and rownum=1 203 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12982350 and KSBH00=47 and ZLXMID=3966 and YJDJH0=16275679 and JCRQ00 IS NOT NULL and rownum=1 204 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3014 and YJDJH0=16275601 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 205 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3014 and YJDJH0=16275601 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 206 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3016 and YJDJH0=16275604 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 207 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3016 and YJDJH0=16275604 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 208 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3921 and YJDJH0=16275605 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 209 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=3921 and YJDJH0=16275605 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 210 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=4531 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 211 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=4531 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 212 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=5207 and YJDJH0=16275624 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 213 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=5207 and YJDJH0=16275624 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 214 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17105 and YJDJH0=16275606 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 215 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17105 and YJDJH0=16275606 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 216 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17170 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 217 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17170 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 218 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17173 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 219 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17173 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 220 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17183 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 221 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17183 and YJDJH0=16275612 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 222 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17207 and YJDJH0=16275606 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 223 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=17207 and YJDJH0=16275606 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 224 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16275621 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 225 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16275621 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 226 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22599 and YJDJH0=16275635 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 227 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22599 and YJDJH0=16275635 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 228 08:38:36 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22767 and YJDJH0=16275613 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 229 08:38:36 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12982350 and KSBH00=46 and ZLXMID=22767 and YJDJH0=16275613 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999