1       17:30:00  SQL Execute: ORACLE - select x.CPID00,Z.YPNM00,Z.YKBMBH,DECODE(Z.LSJ000,999999,NULL,X.YPBM00) YPBM00,X.YPMLBZ,X.YPJCL0,
Z.YPMC00,Z.YPGG00,DECODE(Z.LSJ000,999999,NULL,X.PYSM00) PYSM00,Z.PDXH00,
DECODE(Z.LSJ000,999999,NULL,X.WBSM00) WBSM00,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.LSJ000)) LSJ000,Z.PCKC00 KCSL00,
ROUND(TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.LSJ000*Z.PCKC00)),2) KCJE00,Z.KCDW00,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.GJDJ00)) GJJ000,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.GJDJ00*Z.PCKC00)) GJJE00,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,X.PFJ000)) PFJ000,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,X.PFJ000*Z.PCKC00)) PFJE00,
DECODE(Z.LSJ000,999999,NULL,X.JLDW00) JLDW00,DECODE(Z.LSJ000,999999,NULL,X.ZYFYDW) ZYFYDW,
DECODE(Z.LSJ000,999999,NULL,X.MZFYDW) MZFYDW,TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,X.Z2J000)) Z2J000,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,X.M2J000)) M2J000,TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.KCSX00)) KCSX00,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,X.K2J000)) K2J000,TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.KCXX00)) KCXX00,
ROUND(TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.LSJ000*Z.PCKC00)),2)-TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.GJDJ00*Z.PCKC00)) CE0000,X.GJJ000 ZXGJDJ,
(SELECT GHDWMC FROM BM_YPGHDW WHERE GHDWNM=X.GHDWNM) GHDWMC,
(SELECT GJBZBM FROM BM_YD0000 WHERE YPNM00=X.YPNM00) GJBZBM,
(SELECT GJBZMC FROM BM_YD0000 WHERE YPNM00=X.YPNM00) GJBZMC,
(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=X.SCCJBH) SCCJZW,X.ZBQMC0,
(select Y.MC0000 from BM_TYZD00 Y where  X.YPXZ00 = Y.BH0000 AND Y.ZDMC00 = 'Ò©Æ·ÐÔÖÊ') MC0000
 from VW_YK_ZJPCKC Z,BM_YD0000 X
 where X.YPNM00=Z.YPNM00
 and X.LBBH00 like '%'
 and X.YLBH00 like '%'
 and X.JXBH00 like '%'
 AND Z.PCKC00>0
 and Z.YKBMBH=518
 order by X.YPBM00,Z.JHRQ00 DESC, DECODE(Z.LSJ000,999999,'99999999',X.YPBM00) 

2       17:30:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11606.000000
3       17:30:00  SQL Execute: ORACLE - select (select BMMC00 from BM_BMBM00 M where X.YFBMBH=M.BMBH00 ) YFBMMC,
X.KCSX00,X.KCXX00,round(X.YKKCSL/D.K2J000,3) YKKCSL,
round(X.SJKCSL/D.K2J000,3) SJKCSL,X.PDXH00,D.KCDW00
from YF_YPKCXX X,BM_YD0000 D,BM_BMBM00 A
where X.YPNM00=D.YPNM00 and  X.YFBMBH=A.bmbh00 and  A.czbz00<>'2' and X.YPNM00=?

4       17:30:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11606.000000
5       17:30:00  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 518.000000
6       17:30:00  SQL Execute: ORACLE - SELECT * FROM VW_YK_YPPCKC 
WHERE YPNM00=? AND YKBMBH=? 
AND PCKC00>0
 ORDER BY JHRQ00 DESC,QRRQ00

7       17:30:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11606.000000
8       17:30:00  SQL Execute: ORACLE - select (select BMMC00 from BM_BMBM00 M where X.YFBMBH=M.BMBH00 ) YFBMMC,
X.KCSX00,X.KCXX00,round(X.YKKCSL/D.K2J000,3) YKKCSL,
round(X.SJKCSL/D.K2J000,3) SJKCSL,X.PDXH00,D.KCDW00
from YF_YPKCXX X,BM_YD0000 D,BM_BMBM00 A
where X.YPNM00=D.YPNM00 and  X.YFBMBH=A.bmbh00 and  A.czbz00<>'2' and X.YPNM00=?

9       17:30:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11606.000000
10      17:30:00  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 518.000000
11      17:30:00  SQL Execute: ORACLE - SELECT * FROM VW_YK_YPPCKC 
WHERE YPNM00=? AND YKBMBH=? 
AND PCKC00>0
 ORDER BY JHRQ00 DESC,QRRQ00

12      17:30:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11606.000000
13      17:30:00  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 518.000000
14      17:30:00  SQL Execute: ORACLE - SELECT * FROM VW_YK_YPPCKC 
WHERE YPNM00=? AND YKBMBH=? 
AND PCKC00>0
 ORDER BY JHRQ00 DESC,QRRQ00

15      17:30:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11606.000000
16      17:30:00  SQL Execute: ORACLE - select (select BMMC00 from BM_BMBM00 M where X.YFBMBH=M.BMBH00 ) YFBMMC,
X.KCSX00,X.KCXX00,round(X.YKKCSL/D.K2J000,3) YKKCSL,
round(X.SJKCSL/D.K2J000,3) SJKCSL,X.PDXH00,D.KCDW00
from YF_YPKCXX X,BM_YD0000 D,BM_BMBM00 A
where X.YPNM00=D.YPNM00 and  X.YFBMBH=A.bmbh00 and  A.czbz00<>'2' and X.YPNM00=?

17      17:30:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11606.000000
18      17:30:00  SQL Execute: ORACLE - select (select BMMC00 from BM_BMBM00 M where X.YFBMBH=M.BMBH00 ) YFBMMC,
X.KCSX00,X.KCXX00,round(X.YKKCSL/D.K2J000,3) YKKCSL,
round(X.SJKCSL/D.K2J000,3) SJKCSL,X.PDXH00,D.KCDW00
from YF_YPKCXX X,BM_YD0000 D,BM_BMBM00 A
where X.YPNM00=D.YPNM00 and  X.YFBMBH=A.bmbh00 and  A.czbz00<>'2' and X.YPNM00=?

19      17:30:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11606.000000
20      17:30:00  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 518.000000
21      17:30:00  SQL Execute: ORACLE - SELECT * FROM VW_YK_YPPCKC 
WHERE YPNM00=? AND YKBMBH=? 
AND PCKC00>0
 ORDER BY JHRQ00 DESC,QRRQ00