SELECT substr(trim(C.YPMC00)||'/'||trim(C.YPGG00),1,120) as YPMC00,
    C.LSDJ00,sum(C.CKSL00)||TRIM(C.CKDW00) as LYSL00, sum(C.CKSL00)  as CKSL00,
    D.DXSYBZ,D.JXBH00,D.YLBH00,
    nvl((select X.GZDJ00 from YF_YPKCXX X where C.YPNM00=X.YPNM00
      AND  X.YFBMBH=22),D.GZDJ00) GZDJ00 ,
    C.CKDH00,C.YPNM00,D.YPBM00,
    (select sum(Q.SFZSL0) from YF_YZYPSQ Q where Q.CKDH00=C.CKDH00 and Q.YPNM00=C.YPNM00) SFZSL0,
    (select sum(Q.DKSL00) from YF_YZYPSQ Q where Q.CKDH00=C.CKDH00 and Q.YPNM00=C.YPNM00) DKSL00 
    ,substr(SF_YF_GETYPGWFL(C.YPNM00),1,20) GWFLMC
FROM YF_YPCKMX C,BM_YD0000 D
WHERE C.CKDH00=1821211
      AND  C.YPNM00=D.YPNM00 
group by C.YPMC00,C.YPGG00,C.CKDW00,C.LSDJ00,D.DXSYBZ,D.JXBH00,D.YLBH00,c.YPNM00,C.CKDH00,D.YPBM00,d.GZDJ00
ORDER BY GZDJ00,D.DXSYBZ,D.YPBM00