1 10:44:27 SQL Execute: ORACLE - select * from VW_ZY_RQD000 A ,ZY_BRXXB0 B WHERE A.ZYID00=B.ZYID00 and A.ZYH000 = '118104' and (A.CYRQ00 is null) and A.CZRQ00 >= '20111105' and A.CZRQ00 <= '20111105' order by A.RYCWH0,A.QDH000,A.RYBQBH 2 10:44:27 SQL Execute: ORACLE - select SF_ZY_GET_QDYJJE(871792,'20111107','','0','1') JE0000 from dual 3 10:44:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 871792.000000 4 10:44:27 SQL Execute: ORACLE - select NVL(A.ZYE000,0) ZYE000,decode(b.FBBH00,3,YBYZF0,0)YBYZF0,decode(b.FBBH00,3,YBYJS0,0)YBYJS0 from ZY_BRZHXX A,ZY_BRXXB0 B where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.ZYID00 =? 5 10:44:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6 10:44:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 7 10:44:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20111105 8 10:44:27 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 871792.000000 9 10:44:27 SQL Execute: ORACLE - select A.*,B.*, (SELECT YBZFBL FROM VW_ZY_BRZFBL WHERE SFXMID=A.SFXMID AND YPBZ00=A.SFYP00 AND YBZXLB=? and FBBH00=? and rownum=1) AS YBZFBL from VW_ZY_RQDMX1 A ,ZY_BRXXB0 B where A.ZYID00=B.ZYID00 and A.QDH000 =? AND A.ZYID00=? order by GJBM00,BH0000,XMMC00 10 10:44:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 11 10:44:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 12 10:44:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20111105 13 10:44:27 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 871792.000000 14 10:44:27 SQL Execute: ORACLE - select A.*,B.*, (SELECT YBZFBL FROM VW_ZY_BRZFBL WHERE SFXMID=A.SFXMID AND YPBZ00=A.SFYP00 AND YBZXLB=? and FBBH00=? and rownum=1) AS YBZFBL from VW_ZY_RQDMX1 A ,ZY_BRXXB0 B where A.ZYID00=B.ZYID00 and A.QDH000 =? AND A.ZYID00=? order by GJBM00,BH0000,XMMC00 15 10:44:27 SQL Execute: ORACLE - select SF_ZY_GET_QDYJJE(871792,'20111105','','2','1') JE0000 from dual 16 10:44:28 SQL Execute: ORACLE - select SF_ZY_GET_QDZFY(871792,'20111105','','2','0') HJJE00 from dual 17 10:44:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 18 10:44:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 19 10:44:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20111105 20 10:44:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 871792.000000 21 10:44:28 SQL Execute: ORACLE - select A.*,B.*, (SELECT YBZFBL FROM VW_ZY_BRZFBL WHERE SFXMID=A.SFXMID AND YPBZ00=A.SFYP00 AND YBZXLB=? and FBBH00=? and rownum=1) AS YBZFBL from VW_ZY_RQDMX1 A ,ZY_BRXXB0 B where A.ZYID00=B.ZYID00 and A.QDH000 =? AND A.ZYID00=? order by GJBM00,BH0000,XMMC00 22 10:44:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 23 10:44:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 24 10:44:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20111105 25 10:44:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 871792.000000 26 10:44:28 SQL Execute: ORACLE - select A.*,B.*, (SELECT YBZFBL FROM VW_ZY_BRZFBL WHERE SFXMID=A.SFXMID AND YPBZ00=A.SFYP00 AND YBZXLB=? and FBBH00=? and rownum=1) AS YBZFBL from VW_ZY_RQDMX1 A ,ZY_BRXXB0 B where A.ZYID00=B.ZYID00 and A.QDH000 =? AND A.ZYID00=? order by GJBM00,BH0000,XMMC00 27 10:44:28 SQL Execute: ORACLE - select SF_ZY_GET_QDYJJE(871792,'20111105','','2','1') JE0000 from dual 28 10:44:28 SQL Execute: ORACLE - select SF_ZY_GET_QDZFY(871792,'20111105','','2','0') HJJE00 from dual 29 10:44:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 30 10:44:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 31 10:44:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20111105 32 10:44:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 871792.000000 33 10:44:28 SQL Execute: ORACLE - select A.*,B.*, (SELECT YBZFBL FROM VW_ZY_BRZFBL WHERE SFXMID=A.SFXMID AND YPBZ00=A.SFYP00 AND YBZXLB=? and FBBH00=? and rownum=1) AS YBZFBL from VW_ZY_RQDMX1 A ,ZY_BRXXB0 B where A.ZYID00=B.ZYID00 and A.QDH000 =? AND A.ZYID00=? order by GJBM00,BH0000,XMMC00 34 10:55:39 Log started for: Sickberth 35 10:56:32 Log started for: SQL Navigator for Oracle 36 10:56:39 Log started for: Sickberth