1 16:14:14 Log started for: Sickberth 2 16:14:35 SQL Prepare: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',61,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',888,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =888 AND b.JSKSBH = '61') AND (INSTR (',' || a.jsksbh || ',',',61,') > 0 or a.jsksbh is null) 3 16:14:35 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',61,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',888,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =888 AND b.JSKSBH = '61') AND (INSTR (',' || a.jsksbh || ',',',61,') > 0 or a.jsksbh is null) 4 16:14:37 SQL Prepare: ORACLE - INSERT INTO XT_YHXXRZ(ID0000,XH0000,XTDM00,JSKSBH,JSYGBH,JSRQ00,JSSJ00) VALUES(SQ_XT_YHXXRZ_ID0000.NEXTVAL,'95058','-1','61','888',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 5 16:14:37 SQL Execute: ORACLE - INSERT INTO XT_YHXXRZ(ID0000,XH0000,XTDM00,JSKSBH,JSYGBH,JSRQ00,JSSJ00) VALUES(SQ_XT_YHXXRZ_ID0000.NEXTVAL,'95058','-1','61','888',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 6 16:14:37 SQL Data In: ORACLE - Rows affected = 1 7 16:14:37 SQL Prepare: ORACLE - Commit 8 16:14:37 SQL Execute: ORACLE - Commit 9 16:14:37 SQL Data In: ORACLE - Rows affected = 0 10 16:14:37 SQL Prepare: ORACLE - INSERT INTO XT_YHXXRZ(ID0000,XH0000,XTDM00,JSKSBH,JSYGBH,JSRQ00,JSSJ00) VALUES(SQ_XT_YHXXRZ_ID0000.NEXTVAL,'95081','-1','61','888',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 11 16:14:37 SQL Execute: ORACLE - INSERT INTO XT_YHXXRZ(ID0000,XH0000,XTDM00,JSKSBH,JSYGBH,JSRQ00,JSSJ00) VALUES(SQ_XT_YHXXRZ_ID0000.NEXTVAL,'95081','-1','61','888',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 12 16:14:37 SQL Data In: ORACLE - Rows affected = 1 13 16:14:37 SQL Prepare: ORACLE - Commit 14 16:14:37 SQL Execute: ORACLE - Commit 15 16:14:37 SQL Data In: ORACLE - Rows affected = 0 16 16:14:37 SQL Prepare: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,a.XM0001 XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00,DQLJID,YJJZE0,YBZFJE,DBZBM0,DBZMC0,A.COLOR0, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00,a.BRZJBH,a.BRNL00,a.BRDH00 , (select SF_BQ_GETBRXMXSYS(A.ZYID00) from dual) BRXMYS,XJYE00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = :1 and a.rycwh0=b.ch0000(+) order by b.cwxh00,RYCWH0 17 16:14:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 18 16:14:37 SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,a.XM0001 XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00,DQLJID,YJJZE0,YBZFJE,DBZBM0,DBZMC0,A.COLOR0, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00,a.BRZJBH,a.BRNL00,a.BRDH00 , (select SF_BQ_GETBRXMXSYS(A.ZYID00) from dual) BRXMYS,XJYE00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000(+) order by b.cwxh00,RYCWH0 19 16:14:38 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 20 16:14:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619164.000000 21 16:14:38 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 22 16:14:38 SQL Prepare: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 23 16:14:38 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 24 16:14:38 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 25 16:14:38 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619164.000000 26 16:14:38 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 27 16:14:38 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 28 16:14:38 SQL Execute: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 29 16:14:38 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19840210) AS NL FROM DUAL 30 16:14:38 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19840210) AS NL FROM DUAL 31 16:14:38 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 32 16:14:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619164.000000 33 16:14:38 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 34 16:14:38 SQL Prepare: ORACLE - select SF_ZY_GETDBZXX(1619164,3) DBZDE0 from dual 35 16:14:38 SQL Execute: ORACLE - select SF_ZY_GETDBZXX(1619164,3) DBZDE0 from dual 36 16:14:38 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 37 16:14:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619164.000000 38 16:14:38 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 39 16:14:39 SQL Prepare: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 40 16:14:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 41 16:14:41 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('BQ_SZYS_SFSYSZFZ') 42 16:14:41 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('BQ_SZYS_SFSYSZFZ') 43 16:14:41 SQL Prepare: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00,RYZD00,BMMC00,DQKS00, ZYTS00,ZZYS00,ZZYSXM,ZYYS00,ZYYSXM,ZRYS00,ZRYSXM FROM VW_BQ_ZYBRXX WHERE DQBQ00=:1 order by rycwh0 44 16:14:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 45 16:14:41 SQL Execute: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00,RYZD00,BMMC00,DQKS00, ZYTS00,ZZYS00,ZZYSXM,ZYYS00,ZYYSXM,ZRYS00,ZRYSXM FROM VW_BQ_ZYBRXX WHERE DQBQ00=? order by rycwh0 46 16:14:41 SQL Prepare: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 47 16:14:41 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 16:14:41 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 40568101 49 16:14:41 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 50 16:14:41 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 51 16:14:41 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 52 16:14:41 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 53 16:14:41 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 54 16:14:41 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 55 16:14:41 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 56 16:14:41 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 57 16:14:41 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 58 16:14:41 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 59 16:14:41 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 60 16:14:41 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 61 16:14:41 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 62 16:14:41 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 63 16:14:41 SQL Prepare: ORACLE - select a.yszid0,a.yszmc0 from zs_ysz000 a,zy_brxxb0 b where b.zyid00='1619164' and a.yszid0=b.yszid0 64 16:14:41 SQL Execute: ORACLE - select a.yszid0,a.yszmc0 from zs_ysz000 a,zy_brxxb0 b where b.zyid00='1619164' and a.yszid0=b.yszid0 65 16:14:41 SQL Prepare: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 66 16:14:41 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 67 16:14:41 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 40568101 68 16:14:41 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 69 16:14:41 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 70 16:14:41 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 71 16:14:41 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 72 16:14:41 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 73 16:14:41 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 74 16:14:41 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 75 16:14:41 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 76 16:14:41 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 77 16:14:41 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 78 16:14:41 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 79 16:14:41 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 80 16:14:41 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 81 16:14:41 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 82 16:14:41 SQL Prepare: ORACLE - select a.yszid0,a.yszmc0 from zs_ysz000 a,zy_brxxb0 b where b.zyid00='1619164' and a.yszid0=b.yszid0 83 16:14:41 SQL Execute: ORACLE - select a.yszid0,a.yszmc0 from zs_ysz000 a,zy_brxxb0 b where b.zyid00='1619164' and a.yszid0=b.yszid0 84 16:14:41 SQL Prepare: ORACLE - Select KSH000,KSMC00 FROM VW_BQ_BQKS00 WHERE BQH000=61 85 16:14:41 SQL Execute: ORACLE - Select KSH000,KSMC00 FROM VW_BQ_BQKS00 WHERE BQH000=61 86 16:14:41 SQL Prepare: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 87 16:14:41 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 88 16:14:41 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 40568101 89 16:14:41 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 90 16:14:41 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 91 16:14:41 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 92 16:14:41 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 93 16:14:41 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 94 16:14:41 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 95 16:14:41 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 96 16:14:41 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 97 16:14:41 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 98 16:14:41 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 99 16:14:41 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 100 16:14:41 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 101 16:14:41 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 102 16:14:41 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 103 16:14:41 SQL Prepare: ORACLE - select yszid0,yszmc0 from zs_ysz000 where ssksbh=22 and yszzt0<>'3' order by xsxh00 104 16:14:41 SQL Execute: ORACLE - select yszid0,yszmc0 from zs_ysz000 where ssksbh=22 and yszzt0<>'3' order by xsxh00 105 16:14:41 SQL Prepare: ORACLE - select a.yszid0,a.yszmc0 from zs_ysz000 a,zy_brxxb0 b where b.zyid00='1619164' and a.yszid0=b.yszid0 106 16:14:41 SQL Execute: ORACLE - select a.yszid0,a.yszmc0 from zs_ysz000 a,zy_brxxb0 b where b.zyid00='1619164' and a.yszid0=b.yszid0 107 16:14:45 SQL Prepare: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',61,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',888,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =888 AND b.JSKSBH = '61') AND (INSTR (',' || a.jsksbh || ',',',61,') > 0 or a.jsksbh is null) 108 16:14:45 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',61,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',888,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =888 AND b.JSKSBH = '61') AND (INSTR (',' || a.jsksbh || ',',',61,') > 0 or a.jsksbh is null) 109 16:14:49 SQL Prepare: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 110 16:14:49 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 111 16:14:55 SQL Prepare: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',61,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',888,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =888 AND b.JSKSBH = '61') AND (INSTR (',' || a.jsksbh || ',',',61,') > 0 or a.jsksbh is null) 112 16:14:55 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',61,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',888,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =888 AND b.JSKSBH = '61') AND (INSTR (',' || a.jsksbh || ',',',61,') > 0 or a.jsksbh is null) 113 16:14:59 SQL Prepare: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00 114 16:14:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=61 or DQKS00=61) order by XXID00