1       09:01:47  SQL Prepare: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00,
C.LSDJ00,sum(C.CKSL00)||TRIM(C.CKDW00) as LYSL00,sum(C.CKSL00) CKSL00,TRIM(C.CKDW00) CKDW00,
K.BZ0000,D.DXSYBZ,D.JXBH00,D.YLBH00,K.QRRQ00,D.YPBM00,
C.CKDH00,K.QRSJ00,
X.GZDJ00,
SF_YF_EXROUND(sum(C.CKSL00)*C.LSDJ00,0,2) AS C_YPJE
 FROM YF_YPCKMX C,YF_YPCKD0 K,BM_YD0000 D,YF_YPKCXX X
 WHERE C.CKDH00 ='929482'
 AND  C.YPNM00=D.YPNM00 AND C.CKDH00=K.CKDH00
 AND  C.YPNM00=X.YPNM00 AND X.YFBMBH=20
 GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,
          C.YPNM00,C.YPMC00,C.YPGG00,K.BZ0000,
          C.LSDJ00,C.CKDW00,X.YFBMBH,K.QRRQ00,D.YPBM00
,C.CKDH00,K.QRSJ00
 ORDER BY X.GZDJ00,D.DXSYBZ,D.JXBH00,D.YLBH00,D.YPBM00

2       09:01:47  SQL Execute: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00,
C.LSDJ00,sum(C.CKSL00)||TRIM(C.CKDW00) as LYSL00,sum(C.CKSL00) CKSL00,TRIM(C.CKDW00) CKDW00,
K.BZ0000,D.DXSYBZ,D.JXBH00,D.YLBH00,K.QRRQ00,D.YPBM00,
C.CKDH00,K.QRSJ00,
X.GZDJ00,
SF_YF_EXROUND(sum(C.CKSL00)*C.LSDJ00,0,2) AS C_YPJE
 FROM YF_YPCKMX C,YF_YPCKD0 K,BM_YD0000 D,YF_YPKCXX X
 WHERE C.CKDH00 ='929482'
 AND  C.YPNM00=D.YPNM00 AND C.CKDH00=K.CKDH00
 AND  C.YPNM00=X.YPNM00 AND X.YFBMBH=20
 GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,
          C.YPNM00,C.YPMC00,C.YPGG00,K.BZ0000,
          C.LSDJ00,C.CKDW00,X.YFBMBH,K.QRRQ00,D.YPBM00
,C.CKDH00,K.QRSJ00
 ORDER BY X.GZDJ00,D.DXSYBZ,D.JXBH00,D.YLBH00,D.YPBM00

3       09:01:47  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

4       09:01:47  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

5       09:01:47  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

6       09:01:47  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

7       09:01:47  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

8       09:01:47  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

9       09:01:47  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

10      09:01:47  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

11      09:01:47  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

12      09:01:47  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

13      09:01:47  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

14      09:01:47  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL