create or replace view vw_jppccx_zyydhl as
select c.YZID00, c.YZMXID, c.YPNM00, c.SFDZGG, c.YPMC00, c.YPGG00,
       c.QZFSID, c.PSID00, c.PSMC00, c.MCSL00, c.JLDW00, c.LYL000,
       c.ZYFYDW, c.Z2J000, c.XMYFMC, c.TQFS00, c.YZCLLB, c.TQRQ00,
       c.TQSJ00, c.ZFBL00, c.YBLB00, c.TQYPNM, c.YZNR00, c.YZNR01,
       c.PSTGBZ, c.PSBGR0, c.PSXGID, c.DMBZ00, c.SYYL00, c.YPLBBH,
       c.YZNRCD, c.LJID00, c.MBRCID, c.BRZXJD, c.JHMXID, c.BYYY00,
       c.YJYYLB, c.YJYYLY, a.MXBQID, a.ZXH000, a.PZPCID, d.PSPC00,
       '99'||a.TXM000 txm000, a.EWM000, a.CZLX00, a.CJR000, a.CJRQ00, a.CJSJ00,
       a.BZ0000, a.BQBMBH, a.CH0000, a.BRXM00, a.KSBMBH, a.ZYID00,
       a.ZHXGR0, a.ZHXGRQ, a.ZHXGSJ, b.LSH000, b.YPQLPC, d.YYRQ00,
       b.QLDW00, b.SYZSL0, b.ZHL000, b.TYBZ00, b.TYQLPC
from YF_JPMXBQ a, YF_JPMXYZ b, BQ_YPYZMX c,YF_JPPZD0 d
where a.MXBQID = b.MXBQID and c.YZMXID = b.YZMXID and a.PZPCID=d.PZPCID;