1 17:14:43 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '6')) or XXXZ00='0') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',15,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 0 AND b.JSKSBH = '15') AND (INSTR (',' || a.jsksbh || ',',',15,') > 0 or a.jsksbh is null) 2 17:14:50 Log started for: Sickberth 3 17:14:53 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||',', ',73,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',942,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =942 AND b.JSKSBH = '73') AND (INSTR (',' || a.jsksbh || ',',',73,') > 0 or a.jsksbh is null) 4 17:14:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1617180.000000 5 17:14:55 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 6 17:14:55 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 7 17:14:55 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 40489501 8 17:14:55 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 17:14:55 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 17:14:55 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 17:14:55 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 12 17:14:55 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 13 17:14:55 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 14 17:14:55 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 15 17:14:55 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 17:14:55 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 17 17:14:55 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 18 17:14:55 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 19 17:14:55 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 20 17:14:55 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 21 17:14:55 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; 22 17:14:55 SQL Execute: ORACLE - select D.BRLBJC from BM_BRXXB0 A, IC_YBBRLB C, BM_YBBRLB D, ZY_BRXXB0 Z where Z.BRID00 = A.BRID00 and A.YBLB00 = C.YBLB00 and A.FBBH00 = C.FBBH00 and A.YBBRLB = D.YBBRLB and A.YBBRLB = D.YBBRLB and C.YBZXLB = D.YBZXLB and C.FBBH00 = D.FBBH00 and Z.ZYID00 =(select max(ZYID00) from ZY_BRXXB0 where ZYH000 ='40489501') 23 17:14:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1617180.000000 24 17:14:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 25 17:14:55 SQL Execute: ORACLE - select ID0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, LRRQ00||' '||LRSJ00 "LRRQSJ",JZJE00,DW0000,LRRXM0,BZ0000, ZFJE00,GFJE00, DECODE(SFYBXM,'Y','تا','·ٌ')"YBSFXM",ZYID00,xmlb00,sfxmid, GJBM00,JSXM00,LSCL00,SFMS00,yexm00,PCID00,PCMC00,MCSL00,ZQCS00, TXM000,SCPH00,YZID00 FROM VW_BQ_BRJZXM where zyid00=? and Tzrq00 is null and gzrq00 is null AND XMLB00='0' and Clbz00 like '%'||? order by clbz00,qsrq00 26 17:14:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1617180.000000 27 17:14:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 28 17:14:55 SQL Execute: ORACLE - select distinct XMZT00,XH0000,ZYID00,SFXMID,XMMC00,XMDJ00,BH0000,GJBM00,JSXM00,LSCL00,PYSM00,WBSM00,CLBZ00 from VW_BQ_SFXMYJYZ where zyid00=? and xh0000 like ? order by xh0000,gjbm00 29 17:14:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1618613.000000 30 17:14:55 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 31 17:14:55 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 32 17:14:55 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 40554201 33 17:14:55 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 34 17:14:55 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 35 17:14:55 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 36 17:14:55 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 37 17:14:55 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 38 17:14:55 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 39 17:14:55 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 40 17:14:55 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 17:14:55 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 17:14:55 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 43 17:14:55 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 44 17:14:55 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 45 17:14:55 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 46 17:14:55 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; 47 17:14:55 SQL Execute: ORACLE - select D.BRLBJC from BM_BRXXB0 A, IC_YBBRLB C, BM_YBBRLB D, ZY_BRXXB0 Z where Z.BRID00 = A.BRID00 and A.YBLB00 = C.YBLB00 and A.FBBH00 = C.FBBH00 and A.YBBRLB = D.YBBRLB and A.YBBRLB = D.YBBRLB and C.YBZXLB = D.YBZXLB and C.FBBH00 = D.FBBH00 and Z.ZYID00 =(select max(ZYID00) from ZY_BRXXB0 where ZYH000 ='40554201') 48 17:14:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1618613.000000 49 17:14:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 50 17:14:55 SQL Execute: ORACLE - select ID0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, LRRQ00||' '||LRSJ00 "LRRQSJ",JZJE00,DW0000,LRRXM0,BZ0000, ZFJE00,GFJE00, DECODE(SFYBXM,'Y','تا','·ٌ')"YBSFXM",ZYID00,xmlb00,sfxmid, GJBM00,JSXM00,LSCL00,SFMS00,yexm00,PCID00,PCMC00,MCSL00,ZQCS00, TXM000,SCPH00,YZID00 FROM VW_BQ_BRJZXM where zyid00=? and Tzrq00 is null and gzrq00 is null AND XMLB00='0' and Clbz00 like '%'||? order by clbz00,qsrq00 51 17:14:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1618613.000000 52 17:14:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 53 17:14:55 SQL Execute: ORACLE - select distinct XMZT00,XH0000,ZYID00,SFXMID,XMMC00,XMDJ00,BH0000,GJBM00,JSXM00,LSCL00,PYSM00,WBSM00,CLBZ00 from VW_BQ_SFXMYJYZ where zyid00=? and xh0000 like ? order by xh0000,gjbm00 54 17:14:56 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||',', ',73,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',942,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =942 AND b.JSKSBH = '73') AND (INSTR (',' || a.jsksbh || ',',',73,') > 0 or a.jsksbh is null) 55 17:14:57 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||',', ',73,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',942,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =942 AND b.JSKSBH = '73') AND (INSTR (',' || a.jsksbh || ',',',73,') > 0 or a.jsksbh is null) 56 17:14:57 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=73 or DQKS00=73) order by XXID00