1 16:02:18 SQL Prepare: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=:1 and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=:2 ) order by a.RYCWH0 2 16:02:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 3 16:02:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 4 16:02:18 SQL Execute: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=? and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=? ) order by a.RYCWH0 5 16:02:18 SQL Prepare: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=:1 and c.BQBMBH=:2 and c.YFBMBH=:3 and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=:4 ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 6 16:02:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 705406.000000 7 16:02:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 65.000000 8 16:02:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 9 16:02:18 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 10 16:02:18 SQL Execute: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=? and c.BQBMBH=? and c.YFBMBH=? and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=? ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 11 16:02:18 SQL Prepare: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between :1 and :2 and a.ZYID00=:3 and a.YFBMBH=:4 order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 12 16:02:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130501 13 16:02:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130523 14 16:02:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 705406 15 16:02:18 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 16 16:02:18 SQL Execute: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between ? and ? and a.ZYID00=? and a.YFBMBH=? order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 17 16:02:23 SQL Prepare: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=:1 and c.BQBMBH=:2 and c.YFBMBH=:3 and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=:4 ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 18 16:02:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 697306.000000 19 16:02:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.000000 20 16:02:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 21 16:02:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 22 16:02:23 SQL Execute: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=? and c.BQBMBH=? and c.YFBMBH=? and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=? ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 23 16:02:23 SQL Prepare: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between :1 and :2 and a.ZYID00=:3 and a.YFBMBH=:4 order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 24 16:02:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130501 25 16:02:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130523 26 16:02:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 697306 27 16:02:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 28 16:02:23 SQL Execute: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between ? and ? and a.ZYID00=? and a.YFBMBH=? order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 29 16:02:23 SQL Prepare: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=:1 and c.BQBMBH=:2 and c.YFBMBH=:3 and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=:4 ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 30 16:02:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 701656.000000 31 16:02:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.000000 32 16:02:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 33 16:02:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 34 16:02:23 SQL Execute: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=? and c.BQBMBH=? and c.YFBMBH=? and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=? ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 35 16:02:23 SQL Prepare: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between :1 and :2 and a.ZYID00=:3 and a.YFBMBH=:4 order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 36 16:02:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130501 37 16:02:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130523 38 16:02:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 701656 39 16:02:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 40 16:02:23 SQL Execute: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between ? and ? and a.ZYID00=? and a.YFBMBH=? order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 41 16:02:24 SQL Prepare: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=:1 and c.BQBMBH=:2 and c.YFBMBH=:3 and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=:4 ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 42 16:02:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 697107.000000 43 16:02:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.000000 44 16:02:24 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 45 16:02:24 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 46 16:02:24 SQL Execute: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=? and c.BQBMBH=? and c.YFBMBH=? and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=? ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 47 16:02:24 SQL Prepare: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between :1 and :2 and a.ZYID00=:3 and a.YFBMBH=:4 order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 48 16:02:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130501 49 16:02:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130523 50 16:02:24 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 697107 51 16:02:24 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 52 16:02:24 SQL Execute: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between ? and ? and a.ZYID00=? and a.YFBMBH=? order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 53 16:02:25 SQL Prepare: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=:1 and c.BQBMBH=:2 and c.YFBMBH=:3 and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=:4 ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 54 16:02:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 697306.000000 55 16:02:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.000000 56 16:02:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 57 16:02:25 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 58 16:02:25 SQL Execute: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=? and c.BQBMBH=? and c.YFBMBH=? and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=? ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 59 16:02:25 SQL Prepare: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between :1 and :2 and a.ZYID00=:3 and a.YFBMBH=:4 order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 60 16:02:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130501 61 16:02:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130523 62 16:02:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 697306 63 16:02:25 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 64 16:02:25 SQL Execute: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between ? and ? and a.ZYID00=? and a.YFBMBH=? order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 65 16:02:26 SQL Prepare: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=:1 and c.BQBMBH=:2 and c.YFBMBH=:3 and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=:4 ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 66 16:02:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 705406.000000 67 16:02:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 65.000000 68 16:02:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 69 16:02:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 70 16:02:26 SQL Execute: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=? and c.BQBMBH=? and c.YFBMBH=? and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=? ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 71 16:02:26 SQL Prepare: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between :1 and :2 and a.ZYID00=:3 and a.YFBMBH=:4 order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 72 16:02:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130501 73 16:02:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130523 74 16:02:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 705406 75 16:02:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 76 16:02:26 SQL Execute: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between ? and ? and a.ZYID00=? and a.YFBMBH=? order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 77 16:02:31 SQL Prepare: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=:1 and c.BQBMBH=:2 and c.YFBMBH=:3 and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=:4 ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 78 16:02:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 708306.000000 79 16:02:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 80 16:02:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 81 16:02:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 82 16:02:31 SQL Execute: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=? and c.BQBMBH=? and c.YFBMBH=? and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=? ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 83 16:02:31 SQL Prepare: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between :1 and :2 and a.ZYID00=:3 and a.YFBMBH=:4 order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 84 16:02:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130501 85 16:02:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130523 86 16:02:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 708306 87 16:02:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 88 16:02:31 SQL Execute: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between ? and ? and a.ZYID00=? and a.YFBMBH=? order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 89 16:04:04 SQL Prepare: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=:1 and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=:2 ) order by a.RYCWH0 90 16:04:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 91 16:04:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 92 16:04:04 SQL Execute: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=? and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=? ) order by a.RYCWH0 93 16:04:10 SQL Prepare: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=:1 and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=:2 ) order by a.RYCWH0 94 16:04:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 95 16:04:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 96 16:04:10 SQL Execute: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=? and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=? ) order by a.RYCWH0 97 16:05:26 SQL Prepare: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=:1 and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=:2 ) order by a.RYCWH0 98 16:05:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 99 16:05:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 100 16:05:26 SQL Execute: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=? and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=? ) order by a.RYCWH0 101 16:05:29 SQL Prepare: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=:1 and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=:2 ) order by a.RYCWH0 102 16:05:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 103 16:05:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 104 16:05:29 SQL Execute: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=? and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=? ) order by a.RYCWH0 105 16:05:30 SQL Prepare: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=:1 and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=:2 ) order by a.RYCWH0 106 16:05:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 107 16:05:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 108 16:05:30 SQL Execute: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=? and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=? ) order by a.RYCWH0 109 16:05:30 SQL Prepare: ORACLE - Update YF_YZYPSQ set SHSJ00=null where YFBMBH=:1 and QLZT00 IN('0','1') and CXBZ00='Z' and THBZ00='0' and SHRQ00='20991231' and SHSJ00=:2 110 16:05:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 111 16:05:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 103 112 16:05:30 SQL Execute: ORACLE - Update YF_YZYPSQ set SHSJ00=null where YFBMBH=? and QLZT00 IN('0','1') and CXBZ00='Z' and THBZ00='0' and SHRQ00='20991231' and SHSJ00=? 113 16:05:30 SQL Data In: ORACLE - Rows affected = 0 114 16:05:30 SQL Prepare: ORACLE - commit 115 16:05:30 SQL Execute: ORACLE - commit 116 16:05:30 SQL Data In: ORACLE - Rows affected = 0 117 16:05:30 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 118 16:05:30 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 119 16:05:32 SQL Prepare: ORACLE - select SQ_TEMP_SHSJ00.NextVal TEMPID from dual 120 16:05:32 SQL Execute: ORACLE - select SQ_TEMP_SHSJ00.NextVal TEMPID from dual 121 16:05:32 SQL Prepare: ORACLE - Update YF_YZYPSQ set SHSJ00=:1 where YFBMBH=:2 and QLZT00 IN('0','1') and CXBZ00='Z' and THBZ00='0' and SHRQ00='20991231' 122 16:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 110 123 16:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 124 16:05:32 SQL Execute: ORACLE - Update YF_YZYPSQ set SHSJ00=? where YFBMBH=? and QLZT00 IN('0','1') and CXBZ00='Z' and THBZ00='0' and SHRQ00='20991231' 125 16:05:32 SQL Data In: ORACLE - Rows affected = 346 126 16:05:32 SQL Prepare: ORACLE - commit 127 16:05:32 SQL Execute: ORACLE - commit 128 16:05:32 SQL Data In: ORACLE - Rows affected = 0 129 16:05:32 SQL Prepare: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=:1 and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=:2 ) order by a.RYCWH0 130 16:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 131 16:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 110 132 16:05:32 SQL Execute: ORACLE - select a.*,substr(SF_YF_GETALLZYZD(a.ZYID00),1,120) ALLZD0 from VW_ZY_ZYBRXXForTYTJK a where 1=1 and a.ZYID00 IN (select ZYID00 from YF_YZYPSQ where 1=1 and YFBMBH=? and QLZT00 IN ('0','1') and CXBZ00='Z' and SHRQ00='20991231' and SHSJ00=? ) order by a.RYCWH0 133 16:05:32 SQL Prepare: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=:1 and c.BQBMBH=:2 and c.YFBMBH=:3 and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=:4 ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 134 16:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 708306.000000 135 16:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 136 16:05:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 137 16:05:32 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 110 138 16:05:32 SQL Execute: ORACLE - select A.*,' ' TSYSMC,'0' CHECK0 FROM VW_YF_YZXXForTYTJK A WHERE a.YZID00 IN ( select c.YZID00 from YF_YZYPSQ c where c.ZYID00=? and c.BQBMBH=? and c.YFBMBH=? and c.QLZT00 IN('0','1') and c.CXBZ00='Z' and c.THBZ00='0' and c.SHRQ00='20991231' and c.SHSJ00=? ) ORDER BY a.CLBZ00,a.YZID00,A.YZMXID 139 16:05:32 SQL Prepare: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between :1 and :2 and a.ZYID00=:3 and a.YFBMBH=:4 order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID 140 16:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130523 141 16:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130523 142 16:05:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 708306 143 16:05:32 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 144 16:05:32 SQL Execute: ORACLE - select a.*,' ' TSYSMC from VW_YF_YSHYZYPXX a where a.SHRQ00 between ? and ? and a.ZYID00=? and a.YFBMBH=? order by a.SHRQ00 desc,a.CLBZ00,a.YZID00,a.YZMXID