CREATE OR REPLACE VIEW VW_YF_CKSRTJ
(tjxmbh, xylsje, cylsje, zylsje, yxlsje, xygjje, cygjje, zygjje, yxgjje)
AS
SELECT
  RCLXBH,
  SUM(DECODE(D.LBBH00,'0',Z.FCJE00,0)),
  SUM(DECODE(D.LBBH00,'1',Z.FCJE00,0)),
  SUM(DECODE(D.LBBH00,'2',Z.FCJE00,0)),
  SUM(DECODE(D.LBBH00,'3',Z.FCJE00,0)),
  SUM(DECODE(D.LBBH00,'0',Z.GJFCJE,0)),
  SUM(DECODE(D.LBBH00,'1',Z.GJFCJE,0)),
  SUM(DECODE(D.LBBH00,'2',Z.GJFCJE,0)),
  SUM(DECODE(D.LBBH00,'3',Z.GJFCJE,0))
FROM YF_YPMXZ0 Z,XT_GYBBCS B,BM_YD0000 D
    WHERE Z.JZXZ00='C' AND  B.BBDH00='YF_JCCYB' AND Z.YPNM00+0=D.YPNM00
    AND Z.JZRQ00>=B.KSRQ00 AND Z.JZRQ00<=B.JSRQ00
    AND Z.JZRQ00||Z.JZSJ00>=B.KSRQ00||B.KSSJ00
    AND Z.JZRQ00||Z.JZSJ00<=B.JSRQ00||B.JSSJ00
    AND Z.YFBMBH+0=TO_NUMBER(B.BBCS10)
    AND Z.CRBMBH<>TO_NUMBER(B.BBCS20)
    GROUP BY RCLXBH;

CREATE OR REPLACE VIEW VW_YF_RKSRTJ
(tjxmbh, xylsje, cylsje, zylsje, yxlsje, xygjje, cygjje, zygjje, yxgjje)
AS
SELECT 
  RCLXBH,
  SUM(DECODE(D.LBBH00,'0',Z.SLJE00,0)),
  SUM(DECODE(D.LBBH00,'1',Z.SLJE00,0)),
  SUM(DECODE(D.LBBH00,'2',Z.SLJE00,0)),
  SUM(DECODE(D.LBBH00,'3',Z.SLJE00,0)),
  SUM(DECODE(D.LBBH00,'0',Z.GJSLJE,0)),
  SUM(DECODE(D.LBBH00,'1',Z.GJSLJE,0)),
  SUM(DECODE(D.LBBH00,'2',Z.GJSLJE,0)),
  SUM(DECODE(D.LBBH00,'3',Z.GJSLJE,0))
FROM YF_YPMXZ0 Z,XT_GYBBCS B,BM_YD0000 D
    WHERE JZXZ00='R' AND  B.BBDH00='YF_JCCYB' AND Z.YPNM00+0=D.YPNM00
    AND Z.JZRQ00>=B.KSRQ00 AND Z.JZRQ00<=B.JSRQ00
    AND Z.JZRQ00||Z.JZSJ00>=B.KSRQ00||B.KSSJ00
    AND Z.JZRQ00||Z.JZSJ00<=B.JSRQ00||B.JSSJ00
    AND Z.YFBMBH+0=TO_NUMBER(B.BBCS10)
    AND Z.CRBMBH<>TO_NUMBER(B.BBCS20)
    GROUP BY Z.RCLXBH;