CREATE OR REPLACE VIEW VW_YK_YKBSZDYDJ_DSQL AS
select X.YPQLDH,X.YPMC00,X.YPGG00,X.CKDW00,
--X.CKSL00,
  X.CKSL00+round(nvl(X.JLCKSL*X.JLZHL0/X.ZHL000,0),4) CKSL00,

X.GJDJ00,R.PFDJ00,X.LSDJ00,
      R.SCPH00,R.YPSXRQ,R.SCCJZW,
      round(( X.CKSL00+round(nvl(X.JLCKSL*X.JLZHL0/X.ZHL000,0),4))*X.GJDJ00,2) as C_GJJE,
      round(( X.CKSL00+round(nvl(X.JLCKSL*X.JLZHL0/X.ZHL000,0),4))*R.PFDJ00,2) as C_PFJE,
      round(( X.CKSL00+round(nvl(X.JLCKSL*X.JLZHL0/X.ZHL000,0),4))*X.LSDJ00,2) as C_SFJE,
      round(round(( X.CKSL00+round(nvl(X.JLCKSL*X.JLZHL0/X.ZHL000,0),4))*X.LSDJ00,2)-round(( X.CKSL00+round(nvl(X.JLCKSL*X.JLZHL0/X.ZHL000,0),4))*R.PFDJ00,2),2) as C_PLCJ,
      round(round(( X.CKSL00+round(nvl(X.JLCKSL*X.JLZHL0/X.ZHL000,0),4))*X.LSDJ00,2)-round(( X.CKSL00+round(nvl(X.JLCKSL*X.JLZHL0/X.ZHL000,0),4))*X.GJDJ00,2),2) as C_JXCJ,
      --(SELECT distinct BZ0000 from YK_YPQLMX  where YPQLDH=X.YPQLDH and YPNM00=X.YPNM00 ), --报损原因
      decode(X.CXCKPC ,null,(select distinct BZ0000 from YK_YPQLMX  where YPQLDH=X.YPQLDH and YPNM00=X.YPNM00 ),(select BZ0000 from YK_YPCKMX where YPCKPC=X.CXCKPC and rownum=1) ) BZ0000,
      (select distinct QLSL00 from YK_YPQLMX  where YPQLDH=X.YPQLDH and YPNM00=X.YPNM00 ) QLSL00  --请领数量 
    from YK_YPCKMX X,YK_YPRKMX R 
    where X.YPRKPC=R.YPRKPC 
    order by X.YPCKPC;