1 11:26:03 SQL Execute: ORACLE - select distinct v.bmbh00,v.bmmc00 from YK_YPQLD0 q,VW_YK_YPCKFX v where q.CKQXBH=v.BMBH00 and q.QLZT00='0' and q.QLRQ00>='20210701' and q.QLRQ00<='20241118' and q.YKBMBH=2275 and Q.CKLXBH in (select CKLXBH from BM_YKCKLX where CKDLX0='Y') order by v.BMMC00 2 11:26:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 3 11:26:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 4 11:26:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 5 11:26:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 6 11:26:03 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 7 11:26:03 SQL Execute: ORACLE - select Q.YPQLDH,Q.YPQLDH DJH000,B.ZWXM00,Q.QLRQ00,Q.QLSJ00,Q.CKQXBH,B.XKH000,A.BMMC00 CKQXMC,Q.CKLXBH,C.CKLXMC,Q.SFYJD0,Q.BZ0000 from YK_YPQLD0 Q,BM_YGBM00 B,VW_YK_YPCKFX A,BM_YKCKLX C where Q.QLZT00='0' and Q.YKBMBH=2275 and (Q.CKQXBH=88888 or -1=88888) and Q.LYRBH0=B.YGBH00(+) and Q.CKLXBH=C.CKLXBH and C.CKDLX0='Y' and Q.SFSH00='N' and Q.QLRQ00>='20210701' and Q.QLRQ00<='20241118' and Q.CKQXBH=A.BMBH00 order by A.BMMC00,Q.QLRQ00,B.ZWXM00,Q.YPQLDH 8 11:26:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 9 11:26:03 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=59167226) 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 10 11:26:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 11 11:26:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 12 11:26:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 13 11:26:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 14 11:26:03 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 15 11:26:03 SQL Data In: ORACLE - Param = 1, Name = P_SYSPROCESSID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 16 11:26:03 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 17 11:26:03 SQL Data In: ORACLE - Param = 3, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 18 11:26:03 SQL Data In: ORACLE - Param = 4, Name = P_CKLXBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 06 19 11:26:03 SQL Execute: ORACLE - BEGIN "SP_YF_YPCKLSSJSC" (P_SYSPROCESSID => :P_SYSPROCESSID,P_YFBMBH => :P_YFBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 20 11:26:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 21 11:26:03 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=59167226) 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 22 11:26:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 23 11:26:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 24 11:26:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 25 11:26:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 26 11:26:03 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 27 11:26:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 28 11:26:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 29 11:26:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 30 11:26:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 31 11:26:03 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 32 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 33 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 34 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 35 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 36 11:26:04 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 37 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 38 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 39 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 40 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 41 11:26:04 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 42 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 43 11:26:04 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=59167226) 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 44 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 45 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 46 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 47 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 48 11:26:04 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 49 11:26:04 SQL Data In: ORACLE - Param = 1, Name = P_SYSPROCESSID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 50 11:26:04 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 51 11:26:04 SQL Data In: ORACLE - Param = 3, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 52 11:26:04 SQL Data In: ORACLE - Param = 4, Name = P_CKLXBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 06 53 11:26:04 SQL Execute: ORACLE - BEGIN "SP_YF_YPCKLSSJSC" (P_SYSPROCESSID => :P_SYSPROCESSID,P_YFBMBH => :P_YFBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 54 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 55 11:26:04 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=59167226) 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 56 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 57 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 58 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 59 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 60 11:26:04 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 61 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 62 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 63 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 64 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 65 11:26:04 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 66 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 67 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 68 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 69 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 70 11:26:04 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 71 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 72 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 73 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 74 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 75 11:26:04 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 76 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 77 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 78 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 79 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 80 11:26:04 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 81 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 82 11:26:04 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=59167226) 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 83 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 84 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 85 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 86 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 87 11:26:04 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 88 11:26:04 SQL Data In: ORACLE - Param = 1, Name = P_SYSPROCESSID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 89 11:26:04 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 90 11:26:04 SQL Data In: ORACLE - Param = 3, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 91 11:26:04 SQL Data In: ORACLE - Param = 4, Name = P_CKLXBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 06 92 11:26:04 SQL Execute: ORACLE - BEGIN "SP_YF_YPCKLSSJSC" (P_SYSPROCESSID => :P_SYSPROCESSID,P_YFBMBH => :P_YFBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 93 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 94 11:26:04 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=59167226) 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 95 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 96 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 97 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 98 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 99 11:26:04 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 100 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 101 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 102 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 103 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 104 11:26:04 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 105 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 106 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 107 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 108 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 109 11:26:04 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 110 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 111 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 112 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 113 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 114 11:26:04 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 115 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 116 11:26:04 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=59167226) 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 117 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 118 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 119 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 120 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 121 11:26:04 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 122 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 123 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 124 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 125 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 126 11:26:04 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 127 11:26:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = C12067 128 11:26:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142615.000000 129 11:26:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000051153.000000 130 11:26:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59167226.000000 131 11:26:04 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