1 10:11:29 SQL Execute: ORACLE - select Count(*) from YK_YPQLD0 where QLZT00='0' and YKBMBH=229 and CKLXBH='05' 2 10:11:29 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.YKBMBH=229 and q.CKLXBH='05' 3 10:11:29 SQL Execute: ORACLE - select Q.YPQLDH,B.ZWXM00,Q.QLRQ00,Q.QLSJ00,Q.CKQXBH,Q.YPQLDH DJH000, B.XKH000 from YK_YPQLD0 Q,BM_YGBM00 B where Q.LYRBH0=B.YGBH00(+) order by Q.QLRQ00 4 10:11:30 SQL Data In: ORACLE - Param = 1, Name = P_SYSPROCESSID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 5 10:11:30 SQL Data In: ORACLE - Param = 2, Name = P_YKBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 229.000000 6 10:11:30 SQL Data In: ORACLE - Param = 3, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 7 10:11:30 SQL Data In: ORACLE - Param = 4, Name = P_CKLXBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 05 8 10:11:30 SQL Execute: ORACLE - BEGIN "SP_YK_YPCKLSSJSC" (P_SYSPROCESSID => :P_SYSPROCESSID,P_YKBMBH => :P_YKBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 9 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 10 10:11:30 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=6638603) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz, (select round(D.SJKCSL/B.K2J000,3) from YF_YPKCXX D where A.YPNM00=D.YPNM00 and D.YFBMBH=C.CKQXBH) YFKC00 From YK_YPQLMX A,BM_YD0000 B,YK_YPQLD0 C where A.YPQLDH=? AND A.YPNM00=B.YPNM00 AND A.YPQLDH=C.YPQLDH ORDER BY A.YPQLPC 11 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 12 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 13 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 14 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 15 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 16 10:11:30 SQL Data In: ORACLE - Param = 1, Name = P_SYSPROCESSID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 17 10:11:30 SQL Data In: ORACLE - Param = 2, Name = P_YKBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 229.000000 18 10:11:30 SQL Data In: ORACLE - Param = 3, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 19 10:11:30 SQL Data In: ORACLE - Param = 4, Name = P_CKLXBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 05 20 10:11:30 SQL Execute: ORACLE - BEGIN "SP_YK_YPCKLSSJSC" (P_SYSPROCESSID => :P_SYSPROCESSID,P_YKBMBH => :P_YKBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 21 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 22 10:11:30 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=6638603) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz, (select round(D.SJKCSL/B.K2J000,3) from YF_YPKCXX D where A.YPNM00=D.YPNM00 and D.YFBMBH=C.CKQXBH) YFKC00 From YK_YPQLMX A,BM_YD0000 B,YK_YPQLD0 C where A.YPQLDH=? AND A.YPNM00=B.YPNM00 AND A.YPQLDH=C.YPQLDH ORDER BY A.YPQLPC 23 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 24 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 25 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 26 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 27 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 28 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 29 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 30 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 31 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 32 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 33 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 34 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 35 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 36 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 37 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 38 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 39 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 40 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 41 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 42 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 43 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 44 10:11:30 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=6638603) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz, (select round(D.SJKCSL/B.K2J000,3) from YF_YPKCXX D where A.YPNM00=D.YPNM00 and D.YFBMBH=C.CKQXBH) YFKC00 From YK_YPQLMX A,BM_YD0000 B,YK_YPQLD0 C where A.YPQLDH=? AND A.YPNM00=B.YPNM00 AND A.YPQLDH=C.YPQLDH ORDER BY A.YPQLPC 45 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 46 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 47 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 48 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 49 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 50 10:11:30 SQL Data In: ORACLE - Param = 1, Name = P_SYSPROCESSID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 51 10:11:30 SQL Data In: ORACLE - Param = 2, Name = P_YKBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 229.000000 52 10:11:30 SQL Data In: ORACLE - Param = 3, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 53 10:11:30 SQL Data In: ORACLE - Param = 4, Name = P_CKLXBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 05 54 10:11:30 SQL Execute: ORACLE - BEGIN "SP_YK_YPCKLSSJSC" (P_SYSPROCESSID => :P_SYSPROCESSID,P_YKBMBH => :P_YKBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 55 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 56 10:11:30 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=6638603) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz, (select round(D.SJKCSL/B.K2J000,3) from YF_YPKCXX D where A.YPNM00=D.YPNM00 and D.YFBMBH=C.CKQXBH) YFKC00 From YK_YPQLMX A,BM_YD0000 B,YK_YPQLD0 C where A.YPQLDH=? AND A.YPNM00=B.YPNM00 AND A.YPQLDH=C.YPQLDH ORDER BY A.YPQLPC 57 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 58 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 59 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 60 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 61 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 62 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 63 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 64 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 65 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 66 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 67 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 68 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 69 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 70 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 71 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 72 10:11:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 147275 73 10:11:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1804688.000000 74 10:11:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22041.000000 75 10:11:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6638603.000000 76 10:11:30 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC