1 14:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C11476 2 14:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139369.000000 3 14:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000005735.000000 4 14:58:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167768.000000 5 14:58:35 SQL Execute: ORACLE - select T.*,T.PCLYSL QLSL00,T.JLQLSL as JLQLSL, trunc(PCKCSL) as KCSL00,round((PCKCSL-trunc(PCKCSL))*t.ZHL000/A.ZJJL2J) as JLKCSL,A.K2ZJJL FROM YK_YPQLMX_TEMP T,BM_YD0000 A WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? AND T.YPNM00=A.YPNM00 order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 6 14:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C11210 7 14:58:35 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select trim(SCCJZW) from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=59167768) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz,B.K2ZJJL,substr(SF_YF_GETYPKC(A.YPNM00,2275,0,2),1,50) as YKKCSL,A.BZGG00 From YK_YPQLMX A,BM_YD0000 B where A.YPQLDH=? AND A.YPNM00=B.YPNM00 ORDER BY A.YPQLPC 8 14:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C11210 9 14:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139086.000000 10 14:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051356.000000 11 14:58:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167768.000000 12 14:58:35 SQL Execute: ORACLE - select T.*,T.PCLYSL QLSL00,T.JLQLSL as JLQLSL, trunc(PCKCSL) as KCSL00,round((PCKCSL-trunc(PCKCSL))*t.ZHL000/A.ZJJL2J) as JLKCSL,A.K2ZJJL FROM YK_YPQLMX_TEMP T,BM_YD0000 A WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? AND T.YPNM00=A.YPNM00 order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 13 14:58:35 SQL Data In: ORACLE - Param = 1, Name = P_SYSPROCESSID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167768.000000 14 14:58:35 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 15 14:58:35 SQL Data In: ORACLE - Param = 3, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = C11210 16 14:58:35 SQL Data In: ORACLE - Param = 4, Name = P_CKLXBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 04 17 14:58:35 SQL Execute: ORACLE - BEGIN "SP_YF_YPCKLSSJSC" (P_SYSPROCESSID => :P_SYSPROCESSID,P_YFBMBH => :P_YFBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 18 14:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C11210 19 14:58:35 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select trim(SCCJZW) from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=59167768) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz,B.K2ZJJL,substr(SF_YF_GETYPKC(A.YPNM00,2275,0,2),1,50) as YKKCSL,A.BZGG00 From YK_YPQLMX A,BM_YD0000 B where A.YPQLDH=? AND A.YPNM00=B.YPNM00 ORDER BY A.YPQLPC 20 14:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C11210 21 14:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139086.000000 22 14:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051356.000000 23 14:58:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167768.000000 24 14:58:35 SQL Execute: ORACLE - select T.*,T.PCLYSL QLSL00,T.JLQLSL as JLQLSL, trunc(PCKCSL) as KCSL00,round((PCKCSL-trunc(PCKCSL))*t.ZHL000/A.ZJJL2J) as JLKCSL,A.K2ZJJL FROM YK_YPQLMX_TEMP T,BM_YD0000 A WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? AND T.YPNM00=A.YPNM00 order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 25 14:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C11210 26 14:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139086.000000 27 14:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051356.000000 28 14:58:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167768.000000 29 14:58:35 SQL Execute: ORACLE - select T.*,T.PCLYSL QLSL00,T.JLQLSL as JLQLSL, trunc(PCKCSL) as KCSL00,round((PCKCSL-trunc(PCKCSL))*t.ZHL000/A.ZJJL2J) as JLKCSL,A.K2ZJJL FROM YK_YPQLMX_TEMP T,BM_YD0000 A WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? AND T.YPNM00=A.YPNM00 order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 30 14:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C11210 31 14:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139086.000000 32 14:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051356.000000 33 14:58:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167768.000000 34 14:58:35 SQL Execute: ORACLE - select T.*,T.PCLYSL QLSL00,T.JLQLSL as JLQLSL, trunc(PCKCSL) as KCSL00,round((PCKCSL-trunc(PCKCSL))*t.ZHL000/A.ZJJL2J) as JLKCSL,A.K2ZJJL FROM YK_YPQLMX_TEMP T,BM_YD0000 A WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? AND T.YPNM00=A.YPNM00 order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 35 14:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C11210 36 14:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139086.000000 37 14:58:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051356.000000 38 14:58:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167768.000000 39 14:58:35 SQL Execute: ORACLE - select T.*,T.PCLYSL QLSL00,T.JLQLSL as JLQLSL, trunc(PCKCSL) as KCSL00,round((PCKCSL-trunc(PCKCSL))*t.ZHL000/A.ZJJL2J) as JLKCSL,A.K2ZJJL FROM YK_YPQLMX_TEMP T,BM_YD0000 A WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? AND T.YPNM00=A.YPNM00 order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC