1       14:24:42  SQL Execute: ORACLE - select A.*,
LSJ000 LSJ000_KCDW,YKKCSL YKKCSL_KCDW,SJKCSL SJKCSL_KCDW,GJJ000 GJJ000_KCDW 
 from VW_YF_YPKCXX A
 where LBBH00 like '%'
 and YLBH00 like '%'
 and JXBH00 like '%'
 and YFBMBH=479
 and A.TZRQ00 IS NULL 
 order by YPBM00 

2       14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 479.000000
3       14:24:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3455.000000
4       14:24:42  SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW,
  A.LSDJ00 LSDJ00,ROUND(A.YKKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 
  FROM YF_PCKCMX A,BM_YD0000 B 
 WHERE A.YFBMBH=? 
 and A.YPNM00=? 
 AND A.YPNM00=B.YPNM00 
 ORDER BY TO_NUMBER(KCLSH0) 

5       14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 479.000000
6       14:24:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5946.000000
7       14:24:42  SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW,
  A.LSDJ00 LSDJ00,ROUND(A.YKKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 
  FROM YF_PCKCMX A,BM_YD0000 B 
 WHERE A.YFBMBH=? 
 and A.YPNM00=? 
 AND A.YPNM00=B.YPNM00 
 ORDER BY TO_NUMBER(KCLSH0) 

8       14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 479.000000
9       14:24:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5946.000000
10      14:24:42  SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW,
  A.LSDJ00 LSDJ00,ROUND(A.YKKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 
  FROM YF_PCKCMX A,BM_YD0000 B 
 WHERE A.YFBMBH=? 
 and A.YPNM00=? 
 AND A.YPNM00=B.YPNM00 
 ORDER BY TO_NUMBER(KCLSH0) 

11      14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 479.000000
12      14:24:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5946.000000
13      14:24:42  SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW,
  A.LSDJ00 LSDJ00,ROUND(A.YKKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 
  FROM YF_PCKCMX A,BM_YD0000 B 
 WHERE A.YFBMBH=? 
 and A.YPNM00=? 
 AND A.YPNM00=B.YPNM00 
 ORDER BY TO_NUMBER(KCLSH0) 

14      14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
15      14:24:42  SQL Execute: ORACLE - select * from BM_YPJX00
where lbbh00=?

16      14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
17      14:24:42  SQL Execute: ORACLE - select * from BM_YPYL00
where lbbh00=?

18      14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 479.000000
19      14:24:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5946.000000
20      14:24:42  SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW,
  A.LSDJ00 LSDJ00,ROUND(A.YKKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 
  FROM YF_PCKCMX A,BM_YD0000 B 
 WHERE A.YFBMBH=? 
 and A.YPNM00=? 
 AND A.YPNM00=B.YPNM00 
 ORDER BY TO_NUMBER(KCLSH0) 

21      14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 479.000000
22      14:24:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5946.000000
23      14:24:42  SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW,
  A.LSDJ00 LSDJ00,ROUND(A.YKKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 
  FROM YF_PCKCMX A,BM_YD0000 B 
 WHERE A.YFBMBH=? 
 and A.YPNM00=? 
 AND A.YPNM00=B.YPNM00 
 ORDER BY TO_NUMBER(KCLSH0) 

24      14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 479.000000
25      14:24:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5946.000000
26      14:24:42  SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW,
  A.LSDJ00 LSDJ00,ROUND(A.YKKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 
  FROM YF_PCKCMX A,BM_YD0000 B 
 WHERE A.YFBMBH=? 
 and A.YPNM00=? 
 AND A.YPNM00=B.YPNM00 
 ORDER BY TO_NUMBER(KCLSH0) 

27      14:24:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 479.000000
28      14:24:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3455.000000
29      14:24:42  SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW,
  A.LSDJ00 LSDJ00,ROUND(A.YKKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 
  FROM YF_PCKCMX A,BM_YD0000 B 
 WHERE A.YFBMBH=? 
 and A.YPNM00=? 
 AND A.YPNM00=B.YPNM00 
 ORDER BY TO_NUMBER(KCLSH0)