1 15:01:02 Log started for: SQL Navigator for Oracle 2 15:01:03 SQL Execute: select version from SYS.PRODUCT_COMPONENT_VERSION where upper(product) like '%ORACLE%' 3 15:01:03 SQL Execute: SELECT table_name, table_owner FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'QUEST_COM_TEAM_CODING' 4 15:01:05 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 5 15:01:05 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 6 15:01:05 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.all_objects a,sys.all_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 7 15:01:06 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 8 15:01:06 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 9 15:01:06 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.all_objects a,sys.all_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 10 15:01:06 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 11 15:01:06 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 12 15:01:06 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.all_objects a,sys.all_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 13 15:01:06 SQL Execute: ALTER SESSION SET NLS_DATE_FORMAT='DD-Mon-RRRR' 14 15:01:06 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 15 15:01:06 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 16 15:01:06 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 17 15:01:56 SQL Execute: select owner,object_id,created,nvl(last_ddl_time,created) last_ddl_time,decode(status,'VALID',0,'INVALID',1,2) status,object_name,object_name,decode(object_type,'TABLE',1,'VIEW',2,'INDEX',3,'SNAPSHOT LOG',4,'PROCEDURE',5,'FUNCTION',6,'PACKAGE',7,'PACKAGE BODY',8,'TRIGGER',9,'SEQUENCE',10,'SYNONYM',11,'CLUSTER',12,'DATABASE LINK',13,'SNAPSHOT',14,'MATERIALIZED VIEW',14,'TYPE',15,'TYPE BODY',16,'LIBRARY',19,'DIRECTORY',20,'QUEUE',21,'JAVA SOURCE',22,'JAVA CLASS',23,'JAVA RESOURCE',24,'INDEXTYPE',25,'OPERATOR',26,'DIMENSION',31,'CONTEXT',32,'RESOURCE PLAN',33,'CONSUMER GROUP',34,0) object_type from (select owner,object_id,created,last_ddl_time,status,object_name,object_type from sys.all_objects where upper(owner) like 'SD_HOSPITAL' and upper(object_name) like 'SP_ZY_CYBRFY_BB0000' and object_type in ('TABLE','VIEW','INDEX','PROCEDURE','FUNCTION','PACKAGE','TRIGGER','SEQUENCE','SYNONYM','CLUSTER','DATABASE LINK','TYPE','LIBRARY','DIRECTORY','QUEUE','JAVA SOURCE','JAVA CLASS','JAVA RESOURCE','INDEXTYPE','OPERATOR','DIMENSION','CONTEXT','RESOURCE PLAN','CONSUMER GROUP') and object_name not in (select OBJECT_NAME from USER_RECYCLEBIN) UNION ALL select owner,-1 object_id,created,to_date(NULL) last_ddl_time,NULL status,db_link object_name,'DATABASE LINK' object_type from sys.all_db_links where upper(owner) like 'SD_HOSPITAL' and upper(db_link) like 'SP_ZY_CYBRFY_BB0000') 18 15:01:57 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 19 15:01:57 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 20 15:01:57 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 21 15:01:57 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 22 15:01:57 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 23 15:01:57 SQL Execute: select owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from sys.all_objects a where a.owner like :schema and object_name like :object_name and object_type=:object_type 24 15:01:57 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 25 15:01:57 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 26 15:01:57 SQL Execute: select text,line from sys.all_source where owner='SD_HOSPITAL' and name='SP_ZY_CYBRFY_BB0000' and type='PROCEDURE' order by line 27 15:04:23 SQL Prepare: select D.ZYID00,nvl(F.BAXMID,0),sum(A.HJJE00),sum(A.ZFJE00),sum(A.JZJE00),sum(A.GFJE00) from ZY_FYMX00 A,ZY_BRFY00 D,ZY_BRXXB0 E,BM_YYSFXM F,BQ_BRLDXX G where A.DJH000 = D.DJH000 and D.ZYID00 = E.ZYID00 and A.XMBH00 = F.SFXMID and D.ZYID00 = G.ZYID00 and ( ((as_DWLB00='0') and (E.DQBQ00 = ls_KSBH00 or ls_KSBH00=-1))or ((as_DWLB00='1') and (E.DQKS00 = ls_KSBH00 or ls_KSBH00=-1))) and G.BQJSRQ >='20140603' and G.BQJSRQ <= '20160603' and G.JSZT00='出院' and G.YXBZ00='1' Upper(substrb(E.ZYH000,1,1)) not in ('F','M','g') group by D.ZYID00,nvl(F.BAXMID,0) 28 15:04:30 SQL Prepare: select D.ZYID00,nvl(F.BAXMID,0),sum(A.HJJE00),sum(A.ZFJE00),sum(A.JZJE00),sum(A.GFJE00) from ZY_FYMX00 A,ZY_BRFY00 D,ZY_BRXXB0 E,BM_YYSFXM F,BQ_BRLDXX G where A.DJH000 = D.DJH000 and D.ZYID00 = E.ZYID00 and A.XMBH00 = F.SFXMID and D.ZYID00 = G.ZYID00 and ( ((as_DWLB00='0') and (E.DQBQ00 = ls_KSBH00 or ls_KSBH00=-1))or ((as_DWLB00='1') and (E.DQKS00 = ls_KSBH00 or ls_KSBH00=-1))) and G.BQJSRQ >='20140603' and G.BQJSRQ <= '20160603' and G.JSZT00='出院' and G.YXBZ00='1' and Upper(substrb(E.ZYH000,1,1)) not in ('F','M','g') group by D.ZYID00,nvl(F.BAXMID,0) 29 15:04:38 SQL Prepare: select D.ZYID00,nvl(F.BAXMID,0),sum(A.HJJE00),sum(A.ZFJE00),sum(A.JZJE00),sum(A.GFJE00) from ZY_FYMX00 A,ZY_BRFY00 D,ZY_BRXXB0 E,BM_YYSFXM F,BQ_BRLDXX G where A.DJH000 = D.DJH000 and D.ZYID00 = E.ZYID00 and A.XMBH00 = F.SFXMID and D.ZYID00 = G.ZYID00 and G.BQJSRQ >='20140603' and G.BQJSRQ <= '20160603' and G.JSZT00='出院' and G.YXBZ00='1' and Upper(substrb(E.ZYH000,1,1)) not in ('F','M','g') group by D.ZYID00,nvl(F.BAXMID,0) 30 15:04:38 SQL Execute: select D.ZYID00,nvl(F.BAXMID,0),sum(A.HJJE00),sum(A.ZFJE00),sum(A.JZJE00),sum(A.GFJE00) from ZY_FYMX00 A,ZY_BRFY00 D,ZY_BRXXB0 E,BM_YYSFXM F,BQ_BRLDXX G where A.DJH000 = D.DJH000 and D.ZYID00 = E.ZYID00 and A.XMBH00 = F.SFXMID and D.ZYID00 = G.ZYID00 and G.BQJSRQ >='20140603' and G.BQJSRQ <= '20160603' and G.JSZT00='出院' and G.YXBZ00='1' and Upper(substrb(E.ZYH000,1,1)) not in ('F','M','g') group by D.ZYID00,nvl(F.BAXMID,0) 31 15:04:56 SQL Prepare: select D.ZYID00,nvl(F.BAXMID,0),sum(A.HJJE00),sum(A.ZFJE00),sum(A.JZJE00),sum(A.GFJE00) from ZY_FYMX00 A,ZY_BRFY00 D,ZY_BRXXB0 E,BM_YYSFXM F,BQ_BRLDXX G where A.DJH000 = D.DJH000 and D.ZYID00 = E.ZYID00 and A.XMBH00 = F.SFXMID and D.ZYID00 = G.ZYID00 and G.BQJSRQ >='20140603' and G.BQJSRQ <= '20140603' and G.JSZT00='出院' and G.YXBZ00='1' and Upper(substrb(E.ZYH000,1,1)) not in ('F','M','g') group by D.ZYID00,nvl(F.BAXMID,0) 32 15:04:56 SQL Execute: select D.ZYID00,nvl(F.BAXMID,0),sum(A.HJJE00),sum(A.ZFJE00),sum(A.JZJE00),sum(A.GFJE00) from ZY_FYMX00 A,ZY_BRFY00 D,ZY_BRXXB0 E,BM_YYSFXM F,BQ_BRLDXX G where A.DJH000 = D.DJH000 and D.ZYID00 = E.ZYID00 and A.XMBH00 = F.SFXMID and D.ZYID00 = G.ZYID00 and G.BQJSRQ >='20140603' and G.BQJSRQ <= '20140603' and G.JSZT00='出院' and G.YXBZ00='1' and Upper(substrb(E.ZYH000,1,1)) not in ('F','M','g') group by D.ZYID00,nvl(F.BAXMID,0) 33 15:05:51 SQL Prepare: select D.ZYID00,nvl(F.BAXMID,0),sum(A.HJJE00),sum(A.ZFJE00),sum(A.JZJE00),sum(A.GFJE00) from ZY_FYMX00 A,ZY_BRFY00 D,ZY_BRXXB0 E,BM_YYSFXM F,BQ_BRLDXX G where A.DJH000 = D.DJH000 and D.ZYID00 = E.ZYID00 and A.XMBH00 = F.SFXMID and D.ZYID00 = G.ZYID00 and G.BQJSRQ >='20140604' and G.BQJSRQ <= '20140604' and G.JSZT00='出院' and G.YXBZ00='1' and Upper(substrb(E.ZYH000,1,1)) not in ('F','M','g') group by D.ZYID00,nvl(F.BAXMID,0) 34 15:05:51 SQL Execute: select D.ZYID00,nvl(F.BAXMID,0),sum(A.HJJE00),sum(A.ZFJE00),sum(A.JZJE00),sum(A.GFJE00) from ZY_FYMX00 A,ZY_BRFY00 D,ZY_BRXXB0 E,BM_YYSFXM F,BQ_BRLDXX G where A.DJH000 = D.DJH000 and D.ZYID00 = E.ZYID00 and A.XMBH00 = F.SFXMID and D.ZYID00 = G.ZYID00 and G.BQJSRQ >='20140604' and G.BQJSRQ <= '20140604' and G.JSZT00='出院' and G.YXBZ00='1' and Upper(substrb(E.ZYH000,1,1)) not in ('F','M','g') group by D.ZYID00,nvl(F.BAXMID,0) 35 15:11:41 Log started for: 健康体检系统 36 15:11:45 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 37 15:11:45 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 38 15:11:45 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 39 15:11:45 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 40 15:11:45 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 41 15:11:45 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 42 15:11:45 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 43 15:11:45 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 44 15:11:46 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 45 15:11:46 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 46 15:11:46 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 47 15:11:46 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 48 15:11:46 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 49 15:11:46 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 50 15:11:46 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 51 15:11:46 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 52 15:14:49 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 53 15:14:49 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 54 15:14:49 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 55 15:14:49 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 56 15:14:50 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 57 15:14:50 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 58 15:14:50 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 59 15:14:50 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 60 15:14:58 SQL Prepare: ORACLE - update TJ_ZHXM00 set SFYX00=DECODE('Y','Y','N','Y') where bh0000='49' and ZLXMID='5503' 61 15:14:58 SQL Execute: ORACLE - update TJ_ZHXM00 set SFYX00=DECODE('Y','Y','N','Y') where bh0000='49' and ZLXMID='5503' 62 15:14:58 SQL Prepare: ORACLE - commit 63 15:14:58 SQL Execute: ORACLE - commit 64 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT A.*, (SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = A.KSBH00) YYID00 FROM (SELECT zlxmid, ksbh00, mc0000, jclx00, xh0000 xmxh00, tsxx00, jghqfs, zlxmjc, wbsm00, pysm00, ksxh00, zydtzh, lbbh00, sfyx00, cksbh0 FROM vw_tj_zhxm00 UNION SELECT 0 zlxmid, ksbh00, mc0000, '' jclx00, 0 xmxh00, '' tsxx00, '' jghqfs, mc0000 zlmxjc, '' wbsm00, '' pysm00, xh0000 ksxh00, 0 zydtzh, 0 lbbh00, 'Y' sfyx00, cksbh0 FROM tj_kslb00 WHERE ksbh00 > 0) A) WHERE YYID00 = '222137' ORDER BY ksxh00, xmxh00 65 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT A.*, (SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = A.KSBH00) YYID00 FROM (SELECT zlxmid, ksbh00, mc0000, jclx00, xh0000 xmxh00, tsxx00, jghqfs, zlxmjc, wbsm00, pysm00, ksxh00, zydtzh, lbbh00, sfyx00, cksbh0 FROM vw_tj_zhxm00 UNION SELECT 0 zlxmid, ksbh00, mc0000, '' jclx00, 0 xmxh00, '' tsxx00, '' jghqfs, mc0000 zlmxjc, '' wbsm00, '' pysm00, xh0000 ksxh00, 0 zydtzh, 0 lbbh00, 'Y' sfyx00, cksbh0 FROM tj_kslb00 WHERE ksbh00 > 0) A) WHERE YYID00 = '222137' ORDER BY ksxh00, xmxh00 66 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='151' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 67 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='151' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 68 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='214' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 69 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='214' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 70 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='212' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 71 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='212' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 72 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='27' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 73 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='27' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 74 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='122' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 75 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='122' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 76 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='325' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 77 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='325' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 78 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='46' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 79 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='46' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 80 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT A.*, (SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = A.KSBH00) YYID00 FROM (SELECT zlxmid, ksbh00, mc0000, jclx00, xh0000 xmxh00, tsxx00, jghqfs, zlxmjc, wbsm00, pysm00, ksxh00, zydtzh, lbbh00, sfyx00, cksbh0 FROM vw_tj_zhxm00 UNION SELECT 0 zlxmid, ksbh00, mc0000, '' jclx00, 0 xmxh00, '' tsxx00, '' jghqfs, mc0000 zlmxjc, '' wbsm00, '' pysm00, xh0000 ksxh00, 0 zydtzh, 0 lbbh00, 'Y' sfyx00, cksbh0 FROM tj_kslb00 WHERE ksbh00 > 0) A) WHERE YYID00 = '222137' ORDER BY ksxh00, xmxh00 81 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT A.*, (SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = A.KSBH00) YYID00 FROM (SELECT zlxmid, ksbh00, mc0000, jclx00, xh0000 xmxh00, tsxx00, jghqfs, zlxmjc, wbsm00, pysm00, ksxh00, zydtzh, lbbh00, sfyx00, cksbh0 FROM vw_tj_zhxm00 UNION SELECT 0 zlxmid, ksbh00, mc0000, '' jclx00, 0 xmxh00, '' tsxx00, '' jghqfs, mc0000 zlmxjc, '' wbsm00, '' pysm00, xh0000 ksxh00, 0 zydtzh, 0 lbbh00, 'Y' sfyx00, cksbh0 FROM tj_kslb00 WHERE ksbh00 > 0) A) WHERE YYID00 = '222137' ORDER BY ksxh00, xmxh00 82 15:14:58 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 83 15:14:58 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 84 15:14:58 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 85 15:14:58 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 86 15:15:10 SQL Prepare: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 87 15:15:10 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 88 15:15:10 SQL Prepare: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 89 15:15:10 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 90 15:15:10 SQL Prepare: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 91 15:15:10 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 92 15:15:10 SQL Prepare: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 93 15:15:10 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 94 15:15:10 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 95 15:15:10 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 96 15:15:10 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 97 15:15:10 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 98 15:15:10 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 99 15:15:10 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 100 15:15:10 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 101 15:15:10 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 102 15:15:12 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 103 15:15:12 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 104 15:15:12 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 105 15:15:12 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 106 15:15:12 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 107 15:15:12 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 108 15:15:12 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 109 15:15:12 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 110 15:15:16 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765828' 111 15:15:16 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765828' 112 15:15:16 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933055' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 113 15:15:16 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933055' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 114 15:15:16 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765828 115 15:15:16 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765828 116 15:15:16 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933055) 117 15:15:16 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933055) 118 15:15:16 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 119 15:15:16 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 120 15:15:16 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 121 15:15:16 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 122 15:15:16 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 123 15:15:16 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 124 15:15:16 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 125 15:15:16 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 126 15:16:08 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='151' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 127 15:16:08 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='151' AND ZLXMID='0' ORDER BY KSXH00,XMXH00 128 15:16:08 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 129 15:16:08 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 130 15:16:08 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 131 15:16:08 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 132 15:16:12 SQL Prepare: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 133 15:16:12 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 134 15:16:12 SQL Prepare: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 135 15:16:12 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 136 15:16:12 SQL Prepare: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 137 15:16:12 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 138 15:16:12 SQL Prepare: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 139 15:16:12 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 140 15:16:12 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 141 15:16:12 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 142 15:16:12 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 143 15:16:12 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 144 15:16:12 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 145 15:16:12 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 146 15:16:12 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 147 15:16:12 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 148 15:16:15 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3492769' 149 15:16:15 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3492769' 150 15:16:15 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='12236205' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 151 15:16:15 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='12236205' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 152 15:16:16 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3492769 153 15:16:16 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3492769 154 15:16:16 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=12236205) 155 15:16:16 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=12236205) 156 15:16:28 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 157 15:16:28 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 158 15:16:28 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 159 15:16:28 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 160 15:16:28 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 161 15:16:28 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 162 15:16:28 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 163 15:16:28 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 164 15:17:22 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 165 15:17:22 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 166 15:17:22 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 167 15:17:22 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 168 15:17:22 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 169 15:17:22 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 170 15:17:22 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 171 15:17:22 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 172 15:17:36 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19528' ORDER BY KSXH00,XMXH00 173 15:17:36 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19528' ORDER BY KSXH00,XMXH00 174 15:17:36 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 175 15:17:36 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 176 15:17:37 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 177 15:17:37 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 178 15:17:37 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 179 15:17:37 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 180 15:17:41 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19528' ORDER BY KSXH00,XMXH00 181 15:17:41 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19528' ORDER BY KSXH00,XMXH00 182 15:17:41 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 183 15:17:41 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 184 15:17:41 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 185 15:17:41 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 186 15:17:41 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 187 15:17:41 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 188 15:17:44 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19528' ORDER BY KSXH00,XMXH00 189 15:17:44 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19528' ORDER BY KSXH00,XMXH00 190 15:17:44 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 191 15:17:44 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 192 15:17:45 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 193 15:17:45 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 194 15:17:45 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 195 15:17:45 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 196 15:17:57 SQL Prepare: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 197 15:17:57 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 198 15:17:57 SQL Prepare: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 199 15:17:57 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 200 15:17:57 SQL Prepare: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 201 15:17:57 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 202 15:17:57 SQL Prepare: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 203 15:17:57 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 204 15:17:57 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 205 15:17:57 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 206 15:17:57 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 207 15:17:57 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 208 15:17:57 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 209 15:17:57 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 210 15:17:57 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 211 15:17:57 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 212 15:18:00 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3576817' 213 15:18:00 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3576817' 214 15:18:00 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='12479398' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 215 15:18:00 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='12479398' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 216 15:18:00 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3576817 217 15:18:00 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3576817 218 15:18:00 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=12479398) 219 15:18:00 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=12479398) 220 15:18:01 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3550895' 221 15:18:01 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3550895' 222 15:18:01 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='12442184' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 223 15:18:01 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='12442184' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 224 15:18:01 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3550895 225 15:18:01 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3550895 226 15:18:01 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=12442184) 227 15:18:01 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=12442184) 228 15:20:55 SQL Prepare: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 229 15:20:55 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 230 15:20:55 SQL Prepare: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 231 15:20:55 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 232 15:20:55 SQL Prepare: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 233 15:20:55 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 234 15:20:55 SQL Prepare: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 235 15:20:55 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 236 15:20:55 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 237 15:20:55 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 238 15:20:55 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 239 15:20:55 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 240 15:20:55 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 241 15:20:55 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 242 15:20:55 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 243 15:20:55 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 244 15:21:17 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 245 15:21:17 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 246 15:21:17 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 247 15:21:17 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 248 15:21:17 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 249 15:21:17 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 250 15:21:18 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 251 15:21:18 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 252 15:22:34 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19513' ORDER BY KSXH00,XMXH00 253 15:22:34 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19513' ORDER BY KSXH00,XMXH00 254 15:22:34 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 255 15:22:34 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 256 15:22:36 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 257 15:22:36 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 258 15:22:36 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 259 15:22:36 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 260 15:22:38 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19513' ORDER BY KSXH00,XMXH00 261 15:22:38 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='19513' ORDER BY KSXH00,XMXH00 262 15:22:38 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 263 15:22:38 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 264 15:22:39 SQL Prepare: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 265 15:22:39 SQL Execute: ORACLE - SELECT * FROM ( SELECT ZLXMID,KSBH00,MC0000,JCLX00,XH0000 XMXH00,TSXX00,JGHQFS, ZLXMJC,WBSM00,PYSM00,SFJE00,KSXH00,ZYDTZH,SFYX00,ZYDDY0,ZCJXJ0,XJNR00,JCYY00 FROM VW_TJ_ZHXM00 UNION SELECT 0 ZLXMID,KSBH00,MC0000,'' JCLX00,0 XMXH00,'' TSXX00,'' JGHQFS, MC0000 ZLMXJC,'' WBSM00,'' PYSM00,0 SFJE00,XH0000 KSXH00,0 ZYDTZH,'Y' SFYX00,'N' ZYDDY0,'N' ZCJXJ0, '' XJNR00, NULL JCYY00 FROM TJ_KSLB00 ) WHERE KSBH00='49' AND ZLXMID='5503' ORDER BY KSXH00,XMXH00 266 15:22:39 SQL Prepare: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:1 and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=:2 and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 267 15:22:39 SQL Execute: ORACLE - select * from (select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'Y' sfxy00 from VW_TJ_TJKSXM a where a.sybz00='1' and exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) union select a.xmmc00,a.xmxh00,a.pysm00,a.jcxmid,'N' sfxy00 from VW_TJ_TJKSXM a where a.sybz00= '1' and not exists (select 'Y' from tj_zljcdy c where c.KSBH00='49' and c.zlxmid=? and c.jcxmid=a.jcxmid) ) order by SFXY00 DESC 268 15:22:42 SQL Prepare: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 269 15:22:42 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 270 15:22:42 SQL Prepare: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 271 15:22:42 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 272 15:22:42 SQL Prepare: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 273 15:22:42 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 274 15:22:42 SQL Prepare: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 275 15:22:42 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 276 15:22:42 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 277 15:22:42 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 278 15:22:42 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 279 15:22:42 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 280 15:22:42 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 281 15:22:42 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 282 15:22:42 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 283 15:22:42 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 284 15:22:47 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 285 15:22:47 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 286 15:22:47 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 287 15:22:47 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 288 15:22:47 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 289 15:22:47 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 290 15:22:47 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 291 15:22:47 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 292 15:23:19 SQL Prepare: ORACLE - select ZGZKL0 AS ZKL000 from BM_ZKLQXB where YGBH00 = 476 293 15:23:19 SQL Execute: ORACLE - select ZGZKL0 AS ZKL000 from BM_ZKLQXB where YGBH00 = 476 294 15:23:22 SQL Prepare: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like :1 or DWBH00 Like :2) and( YYID00 = '222137' ) Order By DWBH00,Instrb(PY0000,'2'),PY0000) where Rownum<=200 295 15:23:22 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '222137' ) Order By DWBH00,Instrb(PY0000,'2'),PY0000) where Rownum<=200 296 15:23:22 SQL Prepare: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like :1 or DWBH00 Like :2) and( YYID00 = '222137' ) Order By DWBH00,Instrb(PY0000,'20'),PY0000) where Rownum<=200 297 15:23:22 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '222137' ) Order By DWBH00,Instrb(PY0000,'20'),PY0000) where Rownum<=200 298 15:23:22 SQL Prepare: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like :1 or DWBH00 Like :2) and( YYID00 = '222137' ) Order By DWBH00,Instrb(PY0000,'201'),PY0000) where Rownum<=200 299 15:23:22 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '222137' ) Order By DWBH00,Instrb(PY0000,'201'),PY0000) where Rownum<=200 300 15:23:23 SQL Prepare: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like :1 or DWBH00 Like :2) and( YYID00 = '222137' ) Order By DWBH00,Instrb(PY0000,'2013'),PY0000) where Rownum<=200 301 15:23:23 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '222137' ) Order By DWBH00,Instrb(PY0000,'2013'),PY0000) where Rownum<=200 302 15:23:24 SQL Prepare: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like :1) and( YYID00 = '222137' ) Order By Instrb(PY0000,'2013n'),PY0000) where Rownum<=200 303 15:23:24 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By Instrb(PY0000,'2013n'),PY0000) where Rownum<=200 304 15:23:25 SQL Prepare: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like :1) and( YYID00 = '222137' ) Order By Instrb(PY0000,'2013nb'),PY0000) where Rownum<=200 305 15:23:25 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By Instrb(PY0000,'2013nb'),PY0000) where Rownum<=200 306 15:23:27 SQL Prepare: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 307 15:23:27 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 308 15:23:27 SQL Prepare: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 309 15:23:27 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 310 15:23:27 SQL Prepare: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 311 15:23:27 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 312 15:23:27 SQL Prepare: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 313 15:23:27 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 314 15:23:27 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 315 15:23:27 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 316 15:23:27 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 317 15:23:27 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 318 15:23:27 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 319 15:23:27 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 320 15:23:27 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 321 15:23:27 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 322 15:23:27 SQL Prepare: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 323 15:23:27 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=575 324 15:23:27 SQL Prepare: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 325 15:23:27 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='575' order by dwzbid 326 15:23:27 SQL Prepare: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 327 15:23:27 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 328 15:23:27 SQL Prepare: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 329 15:23:27 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='575' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 330 15:23:28 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 331 15:23:28 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3347681' 332 15:23:28 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 333 15:23:28 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='11724311' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 334 15:23:28 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 335 15:23:28 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3347681 336 15:23:28 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 337 15:23:28 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=11724311) 338 15:23:51 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 339 15:23:51 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 340 15:23:51 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 341 15:23:51 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 342 15:23:51 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 343 15:23:51 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 344 15:23:51 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 345 15:23:51 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 346 15:24:33 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 347 15:24:33 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3765834' 348 15:24:33 SQL Prepare: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 349 15:24:33 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13933141' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 350 15:24:33 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 351 15:24:33 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3765834 352 15:24:33 SQL Prepare: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141) 353 15:24:33 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13933141)