1       09:05:45  SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
2       09:05:45  SQL Data In: ORACLE - Param = 2, Name = PZSM000, Type = fldZSTRING, Precision = 13, Scale = 0, Data = 8362992111111
3       09:05:45  SQL Data In: ORACLE - Param = 3, Name = PPYCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
4       09:05:45  SQL Data In: ORACLE - Param = 4, Name = PYFRKPC, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
5       09:05:45  SQL Data In: ORACLE - Param = 5, Name = PKCLSH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
6       09:05:45  SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
7       09:05:45  SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 242.000000
8       09:05:45  SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
9       09:05:45  SQL Data In: ORACLE - Param = 9, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
10      09:05:45  SQL Data In: ORACLE - Param = 10, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
11      09:05:45  SQL Execute: ORACLE - BEGIN "SP_YF_RKZSM0_EDIT" (POPFLAG => :POPFLAG,PZSM000 => :PZSM000,PPYCKBH => :PPYCKBH,PYFRKPC => :PYFRKPC,PKCLSH0 => :PKCLSH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00); END;
12      09:05:45  SQL Execute: ORACLE -  select c.YPBM00,c.YPNM00,c.YPMC00,c.YPGG00,substrb((select to_char(wm_concat(PZBSM0)) from  YK_YPZSM0 where YPNM00=c.YPNM00),1,200) PZBSM0, (select sf_yf_ypslzh(nvl(sum(r.SYJLSL),0),c.ypnm00,3) from YF_RKZSM0 r where r.YFBMBH = 242 and r.YPNM00=c.YPNM00) SYKCSL,  ( select QWM000 from YF_YPKCXX K where K.YFBMBH = 242 and K.YPNM00 = C.YPNM00 ) QWM000  ,(select SCCJZW from BM_YPSCCJ where SCCJBH=C.SCCJBH) SCCJZW  ,SF_YF_GETYPKC(c.ypnm00,242,0,2) YPKCXX  from BM_YD0000 c  where exists (select 1 from YF_RKZSM0 r where r.YPNM00=c.YPNM00 and r.YFBMBH =242)

13      09:05:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 242.000000
14      09:05:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000042704.000000
15      09:05:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250423
16      09:05:47  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250523
17      09:05:47  SQL Execute: ORACLE -  select A.ZSM000,substr(sf_yf_ypslzh(A.JLZSL0,A.YPNM00,3),1,50) JLZSL0,substr(sf_yf_ypslzh(A.SYJLSL,A.YPNM00,3),1,50) SYJLSL,A.CZRQ00||' '||A.CZSJ00 CZRQSJ from YF_RKZSM0 A,BM_YD0000 B where A.YPNM00 = B.YPNM00 AND A.YFBMBH = ? and A.YPNM00 = ? and A.CZRQ00 between ? and ?  and A.SYJLSL > 0  order by a.CLLSH0 

18      09:05:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 242.000000
19      09:05:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000042704.000000
20      09:05:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250423
21      09:05:47  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250523
22      09:05:47  SQL Execute: ORACLE -  select A.ZSM000,substr(sf_yf_ypslzh(A.JLZSL0,A.YPNM00,3),1,50) JLZSL0,substr(sf_yf_ypslzh(A.SYJLSL,A.YPNM00,3),1,50) SYJLSL,A.CZRQ00||' '||A.CZSJ00 CZRQSJ from YF_RKZSM0 A,BM_YD0000 B where A.YPNM00 = B.YPNM00 AND A.YFBMBH = ? and A.YPNM00 = ? and A.CZRQ00 between ? and ?  and A.SYJLSL > 0  order by a.CLLSH0 

23      09:05:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 242.000000
24      09:05:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000042732.000000
25      09:05:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250423
26      09:05:47  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250523
27      09:05:47  SQL Execute: ORACLE -  select A.ZSM000,substr(sf_yf_ypslzh(A.JLZSL0,A.YPNM00,3),1,50) JLZSL0,substr(sf_yf_ypslzh(A.SYJLSL,A.YPNM00,3),1,50) SYJLSL,A.CZRQ00||' '||A.CZSJ00 CZRQSJ from YF_RKZSM0 A,BM_YD0000 B where A.YPNM00 = B.YPNM00 AND A.YFBMBH = ? and A.YPNM00 = ? and A.CZRQ00 between ? and ?  and A.SYJLSL > 0  order by a.CLLSH0 

28      09:05:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 242.000000
29      09:05:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000042732.000000
30      09:05:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250423
31      09:05:47  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250523
32      09:05:47  SQL Execute: ORACLE -  select A.ZSM000,substr(sf_yf_ypslzh(A.JLZSL0,A.YPNM00,3),1,50) JLZSL0,substr(sf_yf_ypslzh(A.SYJLSL,A.YPNM00,3),1,50) SYJLSL,A.CZRQ00||' '||A.CZSJ00 CZRQSJ from YF_RKZSM0 A,BM_YD0000 B where A.YPNM00 = B.YPNM00 AND A.YFBMBH = ? and A.YPNM00 = ? and A.CZRQ00 between ? and ?  and A.SYJLSL > 0  order by a.CLLSH0