1       17:03:40  SQL Execute: ORACLE - SELECT R.FPH000 YFPH00,D.QLRQ00,D.QRSJ00,D.YPQLDH,D.QRRQ00,D.ZKJE00,X.BZ0000,R.SCPH00,
(SELECT Q.FPH000 FROM YK_YPQLMX Q WHERE Q.YPQLDH=D.YPQLDH AND Q.YPNM00=X.YPNM00 and rownum=1 ) FPH000,
X.YPMC00,X.YPGG00,X.CKDW00,X.CKSL00,R.SCPH00,R.YPSXRQ,R.KL0000,
(SELECT G1.ZWXM00 FROM BM_YGBM00 G1 WHERE D.QRRBH0=G1.YGBH00) QRR000,
X.GJDJ00,X.LSDJ00,H.GHDWMC,
X.PFDJ00,ROUND(X.CKSL00*X.LSDJ00,2) AS C_SFJE,
ROUND(X.CKSL00*X.PFDJ00,2) AS PFJE00,
ROUND(X.CKSL00*X.PFDJ00*Q.KL0000,2)-ROUND(X.CKSL00*X.GJDJ00*Q.KL0000,2) AS CJ0000,
X.GJDJ00,ROUND(X.CKSL00*X.GJDJ00*Q.KL0000,2) AS C_GJJE,
ROUND(ROUND(X.CKSL00*X.LSDJ00,2)-ROUND(X.CKSL00*X.GJDJ00,2),2) AS C_JXCJ
 FROM YK_YPQLMX Q,YK_YPCKMX X,YK_YPQLD0 D,BM_YPGHDW H,YK_YPRKMX R
 WHERE X.YPQLDH=D.YPQLDH AND Q.YPQLDH=D.YPQLDH AND D.CKQXBH=H.GHDWNM(+)
 AND X.YPRKPC=R.YPRKPC AND Q.YPNM00=X.YPNM00 and X.YPQLPC=Q.YPQLPC and (Q.rkpc00 is null or Q.RKPC00=X.YPRKPC)
 AND X.YPQLDH='020957'
 ORDER BY X.YPCKPC

2       17:03:40  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL