1       15:15:40  SQL Execute: ORACLE - SELECT trim(Y.YPMC00)||'/'||trim(Y.YPGG00) as YPMC00,
Y.LSDJ00,SUM(Y.YPZSL0)||TRIM(Y.QLDW00) AS LYSL00,TRIM(Y.QLDW00) CKDW00,
SUM(Y.YPZSL0) AS CKSL00,Y.CKDH00,
D.DXSYBZ,D.JXBH00,D.YLBH00,X.GZDJ00,
SF_YF_EXROUND(SUM(Y.YPZSL0)*Y.LSDJ00,0,2) AS C_YPJE,SF_YF_GWGZDJFL(X.GZDJ00,D.GWYPFL) GWYPFL 
 FROM YF_YZYPSQ Y,BM_YD0000 D,YF_YPKCXX X
 WHERE Y.CKDH00='1125236'
   AND Y.YPNM00=D.YPNM00 AND Y.YPNM00=X.YPNM00
   AND Y.YFBMBH=X.YFBMBH
   AND Y.CXBZ00='Z'
 GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,
          Y.YPNM00,Y.YPMC00,Y.YPGG00,Y.CKDH00,
          Y.LSDJ00,Y.QLDW00,Y.BQBMBH,Y.YFBMBH,D.YPBM00,SF_YF_GWGZDJFL(X.GZDJ00,D.GWYPFL)
 ORDER BY D.YPBM00

2       15:15:40  SQL Execute: ORACLE - SELECT trim(Y.YPMC00)||'/'||trim(Y.YPGG00) as YPMC00,
Y.LSDJ00,SUM(Y.YPZSL0)||TRIM(Y.QLDW00) AS LYSL00,TRIM(Y.QLDW00) CKDW00,
SUM(Y.YPZSL0) AS CKSL00,Y.CKDH00,
D.DXSYBZ,D.JXBH00,D.YLBH00,X.GZDJ00,
SF_YF_EXROUND(SUM(Y.YPZSL0)*Y.LSDJ00,0,2) AS C_YPJE,SF_YF_GWGZDJFL(X.GZDJ00,D.GWYPFL) GWYPFL 
 FROM YF_YZYPSQ Y,BM_YD0000 D,YF_YPKCXX X
 WHERE Y.CKDH00='1125236'
   AND Y.YPNM00=D.YPNM00 AND Y.YPNM00=X.YPNM00
   AND Y.YFBMBH=X.YFBMBH
   AND Y.CXBZ00='Z'
 GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,
          Y.YPNM00,Y.YPMC00,Y.YPGG00,Y.CKDH00,
          Y.LSDJ00,Y.QLDW00,Y.BQBMBH,Y.YFBMBH,D.YPBM00,SF_YF_GWGZDJFL(X.GZDJ00,D.GWYPFL)
 ORDER BY D.YPBM00

3       15:15:40  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

4       15:15:40  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

5       15:15:44  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '45')
  AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)