1       11:27:11  SQL Execute: ORACLE - select CFLSH0,SRRQ00,SRSJ00,ZWXM00 from YS_CFXXB0 a,BM_YGBM00 b where a.YSGZH0=b.YGBH00(+) and a.BRID00=826303
 and ghh000<>'2149260' 
 and YPDLBH='0' and CFXZ00='0' and to_number(CFLSH0)<to_number('2230129') order by to_number(CFLSH0) desc

2       11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2227407         
3       11:27:11  SQL Execute: ORACLE - select YPNM00,YPZSL0,ypmc00,csl000 from YS_CFMX00 a where CFLSH0=? order by a.ZB0000,a.CFID00

4       11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8341
5       11:27:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 479
6       11:27:11  SQL Execute: ORACLE - select * from yf_ypkcxx where ypnm00=? and yfbmbh=? 

7       11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8341
8       11:27:11  SQL Execute: ORACLE - SELECT NDJCTS,zdxl00 FROM BM_YD0000 WHERE YPNM00=?  

9       11:27:11  SQL Execute: ORACLE - select SF_YS_GETBRLSYPYYL(8341,826303) VTS000 from dual 

10      11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6905
11      11:27:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 479
12      11:27:11  SQL Execute: ORACLE - select * from yf_ypkcxx where ypnm00=? and yfbmbh=? 

13      11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6905
14      11:27:11  SQL Execute: ORACLE - SELECT NDJCTS,zdxl00 FROM BM_YD0000 WHERE YPNM00=?  

15      11:27:11  SQL Execute: ORACLE - select SF_YS_GETBRLSYPYYL(6905,826303) VTS000 from dual 

16      11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8602
17      11:27:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 479
18      11:27:11  SQL Execute: ORACLE - select * from yf_ypkcxx where ypnm00=? and yfbmbh=? 

19      11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8602
20      11:27:11  SQL Execute: ORACLE - SELECT NDJCTS,zdxl00 FROM BM_YD0000 WHERE YPNM00=?  

21      11:27:11  SQL Execute: ORACLE - select SF_YS_GETBRLSYPYYL(8602,826303) VTS000 from dual 

22      11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 7928
23      11:27:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 479
24      11:27:11  SQL Execute: ORACLE - select * from yf_ypkcxx where ypnm00=? and yfbmbh=? 

25      11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 7928
26      11:27:11  SQL Execute: ORACLE - SELECT NDJCTS,zdxl00 FROM BM_YD0000 WHERE YPNM00=?  

27      11:27:11  SQL Execute: ORACLE - select SF_YS_GETBRLSYPYYL(7928,826303) VTS000 from dual 

28      11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8328
29      11:27:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 479
30      11:27:11  SQL Execute: ORACLE - select * from yf_ypkcxx where ypnm00=? and yfbmbh=? 

31      11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8328
32      11:27:11  SQL Execute: ORACLE - SELECT NDJCTS,zdxl00 FROM BM_YD0000 WHERE YPNM00=?  

33      11:27:11  SQL Execute: ORACLE - select SF_YS_GETBRLSYPYYL(8328,826303) VTS000 from dual 

34      11:27:11  SQL Execute: ORACLE - select CFZT00 from YF_MZCF00 where CFLSH0='2227407'

35      11:27:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2227407         
36      11:27:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 479
37      11:27:11  SQL Execute: ORACLE - select a.cfid00,a.cflsh0,a.ypnm00,a.YPZSL0,a.ypgg00,
Round(((c.LSDJ00/b.NSBL00)/b.K2J000)*DECODE('N','Y',c.F2J000,b.M2J000), 4) LSDJ00,
a.yfid00,a.pcid00,round(a.csl000*a.f2j000/b.f2j000,4) csl000,nvl(trim(b.mzkfdw),b.jldw00) jldw00,a.yysj00,a.yysjdw,a.zb0000,a.pslbid,a.sfzby0,a.zjyfid, a.ypzsl0,a.cfdw00,a.zhl000,a.sfxs00,a.zfbl00,a.yblb00,a.cxbz00,a.thbz00, a.yyzf00,a.xmyfmc,a.zxcs00,a.zqcs00,b.YPMC00,b.YPGG00,b.LSJ000,b.JLDW00,DECODE('N','Y',c.FYDW00,b.MZFYDW) AS MZFYDW, b.K2J000,DECODE('N','Y', c.F2J000, b.M2J000) as M2J000, b.F2J000 ,b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00  from YS_CFMX00 a, BM_YD0000 b
,YF_YPKCXX c 
 where a.CFLSH0=? and a.ypnm00+0=b.ypnm00  
 and a.ypnm00+0=c.ypnm00 and c.yfbmbh=? 
 order by a.ZB0000

38      11:27:11  SQL Data In: ORACLE - Param = 2, Name = p_ypnm00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8341
39      11:27:11  SQL Data In: ORACLE - Param = 3, Name = p_mcsl00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000
40      11:27:11  SQL Data In: ORACLE - Param = 4, Name = p_z2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 100.000000
41      11:27:11  SQL Data In: ORACLE - Param = 5, Name = p_pcid00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
42      11:27:11  SQL Data In: ORACLE - Param = 6, Name = p_zqs000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
43      11:27:11  SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
44      11:27:11  SQL Data In: ORACLE - Param = 7, Name = p_brid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 826303.000000
45      11:27:11  SQL Data In: ORACLE - Param = 8, Name = p_sftsbz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
46      11:27:11  SQL Data In: ORACLE - Param = 9, Name = p_f2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
47      11:27:11  SQL Data In: ORACLE - Param = 10, Name = p_ghid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4832468.000000
48      11:27:11  SQL Execute: ORACLE - BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00); END;
49      11:27:11  SQL Data In: ORACLE - Param = 2, Name = p_ypnm00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6905
50      11:27:11  SQL Data In: ORACLE - Param = 3, Name = p_mcsl00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
51      11:27:11  SQL Data In: ORACLE - Param = 4, Name = p_z2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000
52      11:27:11  SQL Data In: ORACLE - Param = 5, Name = p_pcid00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
53      11:27:11  SQL Data In: ORACLE - Param = 6, Name = p_zqs000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
54      11:27:11  SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
55      11:27:11  SQL Data In: ORACLE - Param = 7, Name = p_brid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 826303.000000
56      11:27:11  SQL Data In: ORACLE - Param = 8, Name = p_sftsbz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
57      11:27:11  SQL Data In: ORACLE - Param = 9, Name = p_f2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
58      11:27:11  SQL Data In: ORACLE - Param = 10, Name = p_ghid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4832468.000000
59      11:27:11  SQL Execute: ORACLE - BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00); END;
60      11:27:11  SQL Data In: ORACLE - Param = 2, Name = p_ypnm00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8328
61      11:27:11  SQL Data In: ORACLE - Param = 3, Name = p_mcsl00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 100.000000
62      11:27:11  SQL Data In: ORACLE - Param = 4, Name = p_z2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 100.000000
63      11:27:11  SQL Data In: ORACLE - Param = 5, Name = p_pcid00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
64      11:27:11  SQL Data In: ORACLE - Param = 6, Name = p_zqs000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
65      11:27:11  SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
66      11:27:11  SQL Data In: ORACLE - Param = 7, Name = p_brid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 826303.000000
67      11:27:11  SQL Data In: ORACLE - Param = 8, Name = p_sftsbz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
68      11:27:11  SQL Data In: ORACLE - Param = 9, Name = p_f2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
69      11:27:11  SQL Data In: ORACLE - Param = 10, Name = p_ghid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4832468.000000
70      11:27:11  SQL Execute: ORACLE - BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00); END;
71      11:27:11  SQL Data In: ORACLE - Param = 2, Name = p_ypnm00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 7928
72      11:27:11  SQL Data In: ORACLE - Param = 3, Name = p_mcsl00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.250000
73      11:27:11  SQL Data In: ORACLE - Param = 4, Name = p_z2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.250000
74      11:27:11  SQL Data In: ORACLE - Param = 5, Name = p_pcid00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
75      11:27:11  SQL Data In: ORACLE - Param = 6, Name = p_zqs000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
76      11:27:11  SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
77      11:27:11  SQL Data In: ORACLE - Param = 7, Name = p_brid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 826303.000000
78      11:27:11  SQL Data In: ORACLE - Param = 8, Name = p_sftsbz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
79      11:27:11  SQL Data In: ORACLE - Param = 9, Name = p_f2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
80      11:27:11  SQL Data In: ORACLE - Param = 10, Name = p_ghid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4832468.000000
81      11:27:11  SQL Execute: ORACLE - BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00); END;
82      11:27:11  SQL Data In: ORACLE - Param = 2, Name = p_ypnm00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8602
83      11:27:11  SQL Data In: ORACLE - Param = 3, Name = p_mcsl00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
84      11:27:11  SQL Data In: ORACLE - Param = 4, Name = p_z2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
85      11:27:11  SQL Data In: ORACLE - Param = 5, Name = p_pcid00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
86      11:27:11  SQL Data In: ORACLE - Param = 6, Name = p_zqs000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
87      11:27:11  SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
88      11:27:11  SQL Data In: ORACLE - Param = 7, Name = p_brid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 826303.000000
89      11:27:11  SQL Data In: ORACLE - Param = 8, Name = p_sftsbz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
90      11:27:11  SQL Data In: ORACLE - Param = 9, Name = p_f2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
91      11:27:11  SQL Data In: ORACLE - Param = 10, Name = p_ghid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4832468.000000
92      11:27:11  SQL Execute: ORACLE - BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00); END;