1 15:39:40 Log started for: 健康体检系统 2 15:39:40 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 15:39:40 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','T','MedicalExa.exe'||'+'||'健康体检系统','303','22484' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from dual 4 15:39:40 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','T','MedicalExa.exe'||'+'||'健康体检系统','303','22484' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from dual 5 15:39:40 SQL Data In: ORACLE - Rows affected = 1 6 15:39:40 SQL Prepare: ORACLE - Commit 7 15:39:40 SQL Execute: ORACLE - Commit 8 15:39:40 SQL Data In: ORACLE - Rows affected = 0 9 15:39:40 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 15:39:40 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 15:39:40 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 15:39:40 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 15:39:40 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 14 15:39:40 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 15 15:39:40 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 16 15:39:40 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 15:39:40 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','T','MedicalExa.exe'||'+'||'健康体检系统','297','17112' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from dual 18 15:39:40 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','T','MedicalExa.exe'||'+'||'健康体检系统','297','17112' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from dual 19 15:39:40 SQL Data In: ORACLE - Rows affected = 1 20 15:39:40 SQL Prepare: ORACLE - Commit 21 15:39:40 SQL Execute: ORACLE - Commit 22 15:39:40 SQL Data In: ORACLE - Rows affected = 0 23 15:39:40 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 24 15:39:40 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 25 15:39:40 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 26 15:39:40 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 27 15:39:40 SQL Prepare: ORACLE - Select SYSDATE from Dual 28 15:39:40 SQL Execute: ORACLE - Select SYSDATE from Dual 29 15:39:40 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 30 15:39:40 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 15:39:40 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 32 15:39:40 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 15:39:40 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 34 15:39:40 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 35 15:39:40 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 36 15:39:40 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 15:39:40 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 38 15:39:40 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 39 15:39:40 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)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 40 15:39:40 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 41 15:39:46 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 42 15:39:46 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 43 15:39:46 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 44 15:39:46 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 45 15:39:46 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 46 15:39:46 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 15:39:46 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 48 15:39:46 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 15:39:46 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 50 15:39:46 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 15:39:46 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 52 15:39:46 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 15:39:46 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')) 54 15:39:46 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')) 55 15:39:46 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3441580,476,'wlzx','T',nvl('92404148',' '),'192.168.9.99#297:17112@MedicalExa.exe+健康体检系统',125) 56 15:39:46 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3441580,476,'wlzx','T',nvl('92404148',' '),'192.168.9.99#297:17112@MedicalExa.exe+健康体检系统',125) 57 15:39:46 SQL Data In: ORACLE - Rows affected = 1 58 15:39:46 SQL Prepare: ORACLE - Commit 59 15:39:46 SQL Execute: ORACLE - Commit 60 15:39:46 SQL Data In: ORACLE - Rows affected = 0 61 15:39:46 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 62 15:39:46 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 63 15:39:46 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 64 15:39:46 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 65 15:39:46 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 66 15:39:46 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 67 15:39:46 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.99' 68 15:39:46 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.99' 69 15:39:46 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 70 15:39:46 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 71 15:39:46 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 72 15:39:46 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 73 15:39:46 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 74 15:39:46 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 75 15:39:46 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 76 15:39:46 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 77 15:39:48 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 78 15:39:48 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 79 15:39:48 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 80 15:39:48 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 81 15:39:48 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20131216' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='T') 82 15:39:48 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20131216' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='T') 83 15:39:48 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 84 15:39:48 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 85 15:39:48 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 86 15:39:48 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 87 15:39:48 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='T'))) 88 15:39:48 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='T'))) 89 15:39:48 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 90 15:39:48 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 91 15:39:48 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 92 15:39:48 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 93 15:39:48 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 94 15:39:48 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 95 15:39:48 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 96 15:39:48 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 97 15:39:48 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 98 15:39:48 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 99 15:39:48 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 100 15:39:48 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 101 15:39:48 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '476' 102 15:39:48 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '476' 103 15:39:48 SQL Prepare: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 104 15:39:48 SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 105 15:39:48 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') 106 15:39:48 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') 107 15:39:48 SQL Prepare: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 108 15:39:48 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 109 15:39:51 SQL Prepare: ORACLE - select GZGZKL AS ZKL000 from BM_ZKLQXB where YGBH00 = 476 110 15:39:51 SQL Execute: ORACLE - select GZGZKL AS ZKL000 from BM_ZKLQXB where YGBH00 = 476 111 15:39:51 SQL Prepare: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_TJKSSFZJSF' 112 15:39:51 SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_TJKSSFZJSF' 113 15:39:58 SQL Prepare: ORACLE - Select SYSDATE from Dual 114 15:39:58 SQL Execute: ORACLE - Select SYSDATE from Dual 115 15:39:58 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 116 15:39:58 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 117 15:39:58 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 118 15:39:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 119 15:39:58 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137600858685' and ICKNBH = '0222137600858685' 120 15:39:58 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137600858685' and ICKNBH = '0222137600858685' 121 15:39:58 SQL Prepare: ORACLE - Select * from BM_BRXXB0 where BRID00=1191896 122 15:39:58 SQL Execute: ORACLE - Select * from BM_BRXXB0 where BRID00=1191896 123 15:39:58 SQL Prepare: ORACLE - SELECT * FROM VW_TJ_BRXXB0 a WHERE DWID00=0 AND SFTJ00='N' and BRID00='1191896' order by GHID00 desc 124 15:39:58 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 a WHERE DWID00=0 AND SFTJ00='N' and BRID00='1191896' order by GHID00 desc 125 15:39:58 SQL Prepare: ORACLE - select TO_CHAR(SYSDATE-TO_NUMBER('365'),'YYYYMMDD') YXRQ00,GHRQ00 from sf_brxxb0 where ghid00=10352012 126 15:39:58 SQL Execute: ORACLE - select TO_CHAR(SYSDATE-TO_NUMBER('365'),'YYYYMMDD') YXRQ00,GHRQ00 from sf_brxxb0 where ghid00=10352012 127 15:39:58 SQL Prepare: ORACLE - commit 128 15:39:58 SQL Execute: ORACLE - commit 129 15:39:58 SQL Data In: ORACLE - Rows affected = 0 130 15:39:58 SQL Prepare: ORACLE - SELECT * FROM VW_TJ_BRXXB0 a WHERE DWID00=0 AND SFTJ00='N' and BRID00='1191896' order by GHID00 desc 131 15:39:58 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 a WHERE DWID00=0 AND SFTJ00='N' and BRID00='1191896' order by GHID00 desc 132 15:39:58 SQL Prepare: ORACLE - SELECT * FROM TJ_BRXXB0 WHERE GHID00 = '10352012' 133 15:39:58 SQL Execute: ORACLE - SELECT * FROM TJ_BRXXB0 WHERE GHID00 = '10352012' 134 15:39:58 SQL Prepare: ORACLE - select BRID00, YBZX00, YBLB00, YBID00, YBXM00, YBXB00, YBGZZT, YBDWMC from TJ_BRXXB0 A where GHID00 = 10352012 135 15:39:58 SQL Execute: ORACLE - select BRID00, YBZX00, YBLB00, YBID00, YBXM00, YBXB00, YBGZZT, YBDWMC from TJ_BRXXB0 A where GHID00 = 10352012 136 15:39:58 SQL Prepare: ORACLE - SELECT A.DWZBID, A.ZBMC00 MC0000, B.YYID00 FROM TJ_DWZB00 A, BM_TYDWB0 B WHERE A.DWID00 = B.DWID00 AND A.DWID00=0 AND B.YYID00 = '222137' 137 15:39:58 SQL Execute: ORACLE - SELECT A.DWZBID, A.ZBMC00 MC0000, B.YYID00 FROM TJ_DWZB00 A, BM_TYDWB0 B WHERE A.DWID00 = B.DWID00 AND A.DWID00=0 AND B.YYID00 = '222137' 138 15:39:58 SQL Prepare: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' 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 139 15:39:58 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' 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 140 15:39:59 SQL Prepare: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 141 15:39:59 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 142 15:39:59 SQL Prepare: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' AND ROWNUM = 1 AND XMZT00 < 2 143 15:39:59 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' AND ROWNUM = 1 AND XMZT00 < 2 144 15:39:59 SQL Prepare: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 145 15:39:59 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 146 15:40:00 SQL Prepare: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 147 15:40:00 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 148 15:40:03 SQL Prepare: ORACLE - select DISTINCT ZLXMID,ZLXMJC,LBBH00,XH0000 ,(SELECT SUM(SFJE00*SFCS00) SFJE00 FROM VW_BM_YYSFXM C,VW_XT_ZLJGMX D,VW_BM_ZLZD00 E WHERE C.SFXMID=D.SFXMID AND D.ZLXMID=E.ZLXMID AND E.ZLXMID=A.ZLXMID) SFJE00 from VW_TJ_TCXMWH A where TCBH00='201' order by xh0000 149 15:40:03 SQL Execute: ORACLE - select DISTINCT ZLXMID,ZLXMJC,LBBH00,XH0000 ,(SELECT SUM(SFJE00*SFCS00) SFJE00 FROM VW_BM_YYSFXM C,VW_XT_ZLJGMX D,VW_BM_ZLZD00 E WHERE C.SFXMID=D.SFXMID AND D.ZLXMID=E.ZLXMID AND E.ZLXMID=A.ZLXMID) SFJE00 from VW_TJ_TCXMWH A where TCBH00='201' order by xh0000 150 15:40:05 SQL Prepare: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,3963,19373,22591,22641) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC 151 15:40:05 SQL Execute: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,3963,19373,22591,22641) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC 152 15:40:05 SQL Prepare: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='10352012' and zlxmid='3963' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 153 15:40:05 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='10352012' and zlxmid='3963' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 154 15:40:08 SQL Prepare: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='3963' 155 15:40:08 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='3963' 156 15:40:08 SQL Prepare: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=3963 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '222137' AND SFYX00 = 'Y' 157 15:40:08 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=3963 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '222137' AND SFYX00 = 'Y' 158 15:40:08 SQL Prepare: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 159 15:40:08 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 160 15:40:08 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 161 15:40:08 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3963.000000 162 15:40:08 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10352012 163 15:40:08 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 164 15:40:08 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 165 15:40:08 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3963 166 15:40:08 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 167 15:40:08 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 168 15:40:08 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 169 15:40:08 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 170 15:40:08 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 125.000000 171 15:40:08 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 34 172 15:40:08 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 173 15:40:08 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 174 15:40:08 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 175 15:40:08 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 176 15:40:08 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 177 15:40:08 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 178 15:40:08 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 179 15:40:08 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 180 15:40:08 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 181 15:40:08 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 182 15:40:09 SQL Prepare: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='14451858' 183 15:40:09 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='14451858' 184 15:40:09 SQL Data In: ORACLE - Rows affected = 1 185 15:40:09 SQL Prepare: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='14451858' 186 15:40:09 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='14451858' 187 15:40:09 SQL Data In: ORACLE - Rows affected = 1 188 15:40:09 SQL Prepare: ORACLE - BEGIN "SP_TJ_REWRITEJE" (PGHID00 => :PGHID00); END; 189 15:40:09 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10352012 190 15:40:09 SQL Execute: ORACLE - BEGIN "SP_TJ_REWRITEJE" (PGHID00 => :PGHID00); END; 191 15:40:09 SQL Prepare: ORACLE - update TJ_YJDJH0 set SFTCXM = 'Y' where YJDJH0 = 14451858 192 15:40:09 SQL Execute: ORACLE - update TJ_YJDJH0 set SFTCXM = 'Y' where YJDJH0 = 14451858 193 15:40:09 SQL Data In: ORACLE - Rows affected = 1 194 15:40:09 SQL Prepare: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='10352012' and zlxmid='19373' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 195 15:40:09 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='10352012' and zlxmid='19373' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 196 15:40:10 SQL Prepare: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='19373' 197 15:40:10 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='19373' 198 15:40:10 SQL Prepare: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=19373 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '222137' AND SFYX00 = 'Y' 199 15:40:10 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=19373 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '222137' AND SFYX00 = 'Y' 200 15:40:10 SQL Prepare: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 201 15:40:10 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 202 15:40:10 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 203 15:40:10 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19373.000000 204 15:40:10 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10352012 205 15:40:10 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 206 15:40:10 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 207 15:40:10 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 19373 208 15:40:10 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 209 15:40:10 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 210 15:40:10 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 211 15:40:10 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 212 15:40:10 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 125.000000 213 15:40:10 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 50 214 15:40:10 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 215 15:40:10 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 216 15:40:10 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 217 15:40:10 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 218 15:40:10 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 219 15:40:10 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 220 15:40:10 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 221 15:40:10 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 222 15:40:10 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 223 15:40:10 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 224 15:40:11 SQL Prepare: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='14451859' 225 15:40:11 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='14451859' 226 15:40:11 SQL Data In: ORACLE - Rows affected = 1 227 15:40:11 SQL Prepare: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='14451859' 228 15:40:11 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='14451859' 229 15:40:11 SQL Data In: ORACLE - Rows affected = 1 230 15:40:11 SQL Prepare: ORACLE - BEGIN "SP_TJ_REWRITEJE" (PGHID00 => :PGHID00); END; 231 15:40:11 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10352012 232 15:40:11 SQL Execute: ORACLE - BEGIN "SP_TJ_REWRITEJE" (PGHID00 => :PGHID00); END; 233 15:40:11 SQL Prepare: ORACLE - update TJ_YJDJH0 set SFTCXM = 'Y' where YJDJH0 = 14451859 234 15:40:11 SQL Execute: ORACLE - update TJ_YJDJH0 set SFTCXM = 'Y' where YJDJH0 = 14451859 235 15:40:11 SQL Data In: ORACLE - Rows affected = 1 236 15:40:11 SQL Prepare: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='10352012' and zlxmid='22591' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 237 15:40:11 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='10352012' and zlxmid='22591' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 238 15:40:11 SQL Prepare: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='22591' 239 15:40:11 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='22591' 240 15:40:11 SQL Prepare: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=22591 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '222137' AND SFYX00 = 'Y' 241 15:40:11 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=22591 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '222137' AND SFYX00 = 'Y' 242 15:40:11 SQL Prepare: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 243 15:40:11 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 244 15:40:11 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 245 15:40:11 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22591.000000 246 15:40:11 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10352012 247 15:40:11 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 248 15:40:11 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 249 15:40:11 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 22591 250 15:40:11 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 251 15:40:11 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 252 15:40:11 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 253 15:40:11 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 254 15:40:11 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 125.000000 255 15:40:11 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 46 256 15:40:11 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 257 15:40:11 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 258 15:40:11 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 259 15:40:11 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 260 15:40:11 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 261 15:40:11 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 262 15:40:11 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 263 15:40:11 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 264 15:40:11 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 265 15:40:11 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 266 15:40:12 SQL Prepare: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='14451860' 267 15:40:12 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='14451860' 268 15:40:12 SQL Data In: ORACLE - Rows affected = 1 269 15:40:12 SQL Prepare: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='14451860' 270 15:40:12 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='14451860' 271 15:40:12 SQL Data In: ORACLE - Rows affected = 1 272 15:40:12 SQL Prepare: ORACLE - BEGIN "SP_TJ_REWRITEJE" (PGHID00 => :PGHID00); END; 273 15:40:12 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10352012 274 15:40:12 SQL Execute: ORACLE - BEGIN "SP_TJ_REWRITEJE" (PGHID00 => :PGHID00); END; 275 15:40:12 SQL Prepare: ORACLE - update TJ_YJDJH0 set SFTCXM = 'Y' where YJDJH0 = 14451860 276 15:40:12 SQL Execute: ORACLE - update TJ_YJDJH0 set SFTCXM = 'Y' where YJDJH0 = 14451860 277 15:40:12 SQL Data In: ORACLE - Rows affected = 1 278 15:40:12 SQL Prepare: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='10352012' and zlxmid='22641' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 279 15:40:12 SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='10352012' and zlxmid='22641' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) 280 15:40:13 SQL Prepare: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='22641' 281 15:40:13 SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='22641' 282 15:40:13 SQL Prepare: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=22641 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '222137' AND SFYX00 = 'Y' 283 15:40:13 SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00 where ZLXMID=22641 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '222137' AND SFYX00 = 'Y' 284 15:40:13 SQL Prepare: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 285 15:40:13 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 286 15:40:13 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 287 15:40:13 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22641.000000 288 15:40:13 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10352012 289 15:40:13 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 290 15:40:13 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 291 15:40:13 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 22641 292 15:40:13 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 293 15:40:13 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 294 15:40:13 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 295 15:40:13 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 296 15:40:13 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 125.000000 297 15:40:13 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 125 298 15:40:13 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 299 15:40:13 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 300 15:40:13 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 301 15:40:13 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 302 15:40:13 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 303 15:40:13 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 304 15:40:13 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 305 15:40:13 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 306 15:40:13 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 307 15:40:13 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 308 15:40:13 SQL Prepare: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='14451861' 309 15:40:13 SQL Execute: ORACLE - UPDATE YJ_YW0000 SET YJLRBZ='T' WHERE YJDJH0='14451861' 310 15:40:13 SQL Data In: ORACLE - Rows affected = 1 311 15:40:13 SQL Prepare: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='14451861' 312 15:40:13 SQL Execute: ORACLE - update TJ_YJDJH0 set ZKL000='100' where YJDJH0='14451861' 313 15:40:13 SQL Data In: ORACLE - Rows affected = 1 314 15:40:13 SQL Prepare: ORACLE - BEGIN "SP_TJ_REWRITEJE" (PGHID00 => :PGHID00); END; 315 15:40:13 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10352012 316 15:40:13 SQL Execute: ORACLE - BEGIN "SP_TJ_REWRITEJE" (PGHID00 => :PGHID00); END; 317 15:40:13 SQL Prepare: ORACLE - update TJ_YJDJH0 set SFTCXM = 'Y' where YJDJH0 = 14451861 318 15:40:13 SQL Execute: ORACLE - update TJ_YJDJH0 set SFTCXM = 'Y' where YJDJH0 = 14451861 319 15:40:13 SQL Data In: ORACLE - Rows affected = 1 320 15:40:13 SQL Prepare: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=1191896 321 15:40:13 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=1191896 322 15:40:13 SQL Prepare: ORACLE - UPDATE YJ_YWJJ00 A SET SL0000=(SELECT SL0000*ZKL000/100 FROM TJ_YJDJH0 WHERE YJDJH0=A.YJDJH0) WHERE YJDJH0 IN (SELECT YJDJH0 FROM TJ_YJDJH0 WHERE GHID00=10352012) AND GDBZ00='Y' 323 15:40:13 SQL Execute: ORACLE - UPDATE YJ_YWJJ00 A SET SL0000=(SELECT SL0000*ZKL000/100 FROM TJ_YJDJH0 WHERE YJDJH0=A.YJDJH0) WHERE YJDJH0 IN (SELECT YJDJH0 FROM TJ_YJDJH0 WHERE GHID00=10352012) AND GDBZ00='Y' 324 15:40:13 SQL Data In: ORACLE - Rows affected = 100 325 15:40:13 SQL Prepare: ORACLE - Commit 326 15:40:13 SQL Execute: ORACLE - Commit 327 15:40:13 SQL Data In: ORACLE - Rows affected = 0 328 15:40:13 SQL Prepare: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' 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 329 15:40:13 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' 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 330 15:40:13 SQL Prepare: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 331 15:40:13 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 332 15:40:13 SQL Prepare: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' AND ROWNUM = 1 AND XMZT00 < 2 333 15:40:13 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' AND ROWNUM = 1 AND XMZT00 < 2 334 15:40:13 SQL Prepare: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 335 15:40:13 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 336 15:40:22 SQL Prepare: ORACLE - Select KDRQ00 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND KDRQ00 IS NOT NULL AND ROWNUM = 1 337 15:40:22 SQL Execute: ORACLE - Select KDRQ00 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND KDRQ00 IS NOT NULL AND ROWNUM = 1 338 15:40:22 SQL Prepare: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 339 15:40:22 SQL Execute: ORACLE - SELECT NVL(sum(ZJE000),0) from yj_yw0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and xmzt00 < '2' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 340 15:40:22 SQL Prepare: ORACLE - SELECT YJDJH0 FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' AND ROWNUM = 1 AND XMZT00 < 2 341 15:40:22 SQL Execute: ORACLE - SELECT YJDJH0 FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' AND ROWNUM = 1 AND XMZT00 < 2 342 15:40:22 SQL Prepare: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' AND ROWNUM = 1 AND XMZT00 < 2 343 15:40:22 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' AND ROWNUM = 1 AND XMZT00 < 2 344 15:40:26 SQL Prepare: ORACLE - SELECT DJH000 FROM SF_FYMX00 WHERE DJH000 IN (SELECT DJH000 FROM SF_BRFY00 WHERE JZDH00 = '0' and MZID00 = '10352012') AND ROWNUM = 1 AND XMBH00 = '2917' 345 15:40:26 SQL Execute: ORACLE - SELECT DJH000 FROM SF_FYMX00 WHERE DJH000 IN (SELECT DJH000 FROM SF_BRFY00 WHERE JZDH00 = '0' and MZID00 = '10352012') AND ROWNUM = 1 AND XMBH00 = '2917' 346 15:40:26 SQL Prepare: ORACLE - select to_char(sysdate,'YYYYMMDD') from dual 347 15:40:26 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') from dual 348 15:40:26 SQL Prepare: ORACLE - select * from TJ_TJQMQX where YGBH00 = '476' and (QSRQ00 is not null and ZZRQ00 is not null) AND (QSRQ00 <= '20131216' AND ZZRQ00 >= '20131216') AND QMCS00 > 0 349 15:40:26 SQL Execute: ORACLE - select * from TJ_TJQMQX where YGBH00 = '476' and (QSRQ00 is not null and ZZRQ00 is not null) AND (QSRQ00 <= '20131216' AND ZZRQ00 >= '20131216') AND QMCS00 > 0 350 15:40:26 SQL Prepare: ORACLE - select * from TJ_TJQMQX where YGBH00 = '476' and (QSRQ00 is not null and ZZRQ00 is not null) AND (QSRQ00 <= '20131216' AND ZZRQ00 >= '20131216') AND QMCS00 > 0 351 15:40:26 SQL Execute: ORACLE - select * from TJ_TJQMQX where YGBH00 = '476' and (QSRQ00 is not null and ZZRQ00 is not null) AND (QSRQ00 <= '20131216' AND ZZRQ00 >= '20131216') AND QMCS00 > 0 352 15:40:27 SQL Prepare: ORACLE - update TJ_TJQMQX set QMCS00 = QMCS00 - 1 where YGBH00 = '476' 353 15:40:27 SQL Execute: ORACLE - update TJ_TJQMQX set QMCS00 = QMCS00 - 1 where YGBH00 = '476' 354 15:40:27 SQL Data In: ORACLE - Rows affected = 1 355 15:40:27 SQL Prepare: ORACLE - BEGIN "SF_TJ_ZEZKCZ" (PGRDWBZ => :PGRDWBZ,PZYGHID => :PZYGHID,PMZH000 => :PMZH000,PBRID00 => :PBRID00,PSFMF00 => :PSFMF00,PZKJE00 => :PZKJE00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0); END; 356 15:40:27 SQL Data In: ORACLE - Param = 1, Name = PGRDWBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 357 15:40:27 SQL Data In: ORACLE - Param = 2, Name = PZYGHID, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10352012 358 15:40:27 SQL Data In: ORACLE - Param = 3, Name = PMZH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5523393 359 15:40:27 SQL Data In: ORACLE - Param = 4, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1191896 360 15:40:27 SQL Data In: ORACLE - Param = 5, Name = PSFMF00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 361 15:40:27 SQL Data In: ORACLE - Param = 6, Name = PZKJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -203.060000 362 15:40:27 SQL Data In: ORACLE - Param = 7, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 363 15:40:27 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 125.000000 364 15:40:27 SQL Execute: ORACLE - BEGIN "SF_TJ_ZEZKCZ" (PGRDWBZ => :PGRDWBZ,PZYGHID => :PZYGHID,PMZH000 => :PMZH000,PBRID00 => :PBRID00,PSFMF00 => :PSFMF00,PZKJE00 => :PZKJE00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0); END; 365 15:40:29 SQL Prepare: ORACLE - select nvl(sum(ZJE000),0)+nvl(sum(nvl(FJF000,0)),0) from TJ_YJDJH0 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 366 15:40:29 SQL Execute: ORACLE - select nvl(sum(ZJE000),0)+nvl(sum(nvl(FJF000,0)),0) from TJ_YJDJH0 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 367 15:40:29 SQL Prepare: ORACLE - select nvl(sum(ZJE000),0) from YJ_YW0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 368 15:40:29 SQL Execute: ORACLE - select nvl(sum(ZJE000),0) from YJ_YW0000 where yjdjh0 in (Select b.YJDJH0 from VW_TJ_YJ_YW0000 b where ZYGHID='10352012' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))) 369 15:40:29 SQL Prepare: ORACLE - select nvl(sum(ZJE000),0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' 370 15:40:29 SQL Execute: ORACLE - select nvl(sum(ZJE000),0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT SF_TJ_GETXTCS('222137', VALUE0) FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '10352012' 371 15:40:29 SQL Prepare: ORACLE - rollback 372 15:40:29 SQL Execute: ORACLE - rollback 373 15:40:29 SQL Data In: ORACLE - Rows affected = 0