CREATE OR REPLACE VIEW VW_YK_YPCKD0FR3 AS
select a.YPQLDH,
       a.YKBMBH,
       (select BMMC00 from BM_BMBM00 where BMBH00=YKBMBH and rownum=1) CKKSMC,
       CKQXBH,
       (select CRBMMC from VW_YK_YPCRKDW where CRBMNM=CKQXBH and rownum=1) QLKSMC,
       (SELECT CKLXMC FROM BM_YKCKLX  WHERE CKLXBH=a.CKLXBH) CKLXMC,
       to_date(QRRQ00,'YYYYMMDD') QRRQ00,
       CZYBH0,
       (select ZWXM00 from bm_ygbm00 where ygbh00=a.CZYBH0 and rownum=1) CZYXM0,
       QRRBH0,
       (select ZWXM00 FROM BM_YGBM00 WHERE YGBH00=A.QRRBH0 AND ROWNUM=1) QRRXM0,
       SHRBH0,
       (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=A.SHRBH0 AND ROWNUM=1) SHRXM0,
       LYRBH0,
       (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=A.LYRBH0 AND ROWNUM=1) LYRXM0,
       --(SELECT SUM(ROUND(CKSL00*LSDJ00,2)) FROM YK_YPCKMX WHERE YPQLDH=A.YPQLDH) LSJE00
      (SELECT SUM(round(LSDJ00*(CKSL00+nvl(JLCKSL*JLZHL0/ZHL000,0)),2)) FROM YK_YPCKMX WHERE YPQLDH=A.YPQLDH) LSJE00,
      a.bz0000
from YK_YPQLD0 a
union all
select a.RKDH00 YPQLDH,
       a.YKBMBH,
       (select BMMC00 from BM_BMBM00 where BMBH00=YKBMBH and rownum=1) CKKSMC,
       GHDWNM CKQXBH,
       (select CRBMMC from VW_YK_YPCRKDW where CRBMNM=GHDWNM and rownum=1) QLKSMC,
       (SELECT RKLXMC FROM BM_YKRKLX  WHERE RKLXBH=a.RKLXBH) CKLXMC,
       to_date(QRRQ00,'YYYYMMDD') QRRQ00,
       CZYBH0,
       (select ZWXM00 from bm_ygbm00 where ygbh00=a.CZYBH0 and rownum=1) CZYXM0,
       QRRBH0,
       (select ZWXM00 FROM BM_YGBM00 WHERE YGBH00=A.QRRBH0 AND ROWNUM=1) QRRXM0,
       SHRBH0,
       (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=A.SHRBH0 AND ROWNUM=1) SHRXM0,
       NULL LYRBH0,
       NULL LYRXM0,
       --(SELECT SUM(ROUND(-RKSL00*LSDJ00,2)) FROM YK_YPRKMX WHERE RKDH00=A.RKDH00) LSJE00
       (SELECT -SUM(round(LSDJ00*(RKSL00+nvl(JLRKSL*JLZHL0/ZHL000,0)),2)) FROM YK_YPRKMX WHERE RKDH00=A.RKDH00) LSJE00,
       a.bz0000
from YK_YPRKD0 a
where RKLXBH in ('06','31');