-- Start of DDL Script for View SD_HOSPITAL.VW_YK_YKBSZDYDJ_DSQL
-- Generated 2019-01-03 17:14:35 from SD_HOSPITAL@ZHXYYGL

CREATE OR REPLACE VIEW vw_yk_ykbszdydj_dsql (
   ypqldh,
   ypmc00,
   ypgg00,
   ckdw00,
   cksl00,
   gjdj00,
   pfdj00,
   lsdj00,
   scph00,
   ypsxrq,
   sccjzw,
   c_gjje,
   c_pfje,
   c_sfje,
   c_plcj,
   c_jxcj,
   bz0000,
   qlsl00 )
AS
SELECT X.YPQLDH,X.YPMC00,X.YPGG00,X.CKDW00,X.CKSL00,X.GJDJ00,R.PFDJ00,X.LSDJ00,
      R.SCPH00,R.YPSXRQ,R.SCCJZW,ROUND(X.CKSL00*X.GJDJ00,2) AS C_GJJE,
      ROUND(X.CKSL00*R.PFDJ00,2) AS C_PFJE,
      ROUND(X.CKSL00*X.LSDJ00,2) AS C_SFJE,
      ROUND(ROUND(X.CKSL00*X.LSDJ00,2)-ROUND(X.CKSL00*R.PFDJ00,2),2) AS C_PLCJ,
      ROUND(ROUND(X.CKSL00*X.LSDJ00,2)-ROUND(X.CKSL00*X.GJDJ00,2),2) AS C_JXCJ,
      (SELECT DISTINCT BZ0000 FROM YK_YPQLMX  WHERE YPQLDH=X.YPQLDH AND YPNM00=X.YPNM00 ), --报损原因
      (SELECT DISTINCT QLSL00 FROM YK_YPQLMX  WHERE YPQLDH=X.YPQLDH AND YPNM00=X.YPNM00 )  --请领数量 
    FROM YK_YPCKMX X,YK_YPRKMX R 
    WHERE X.YPRKPC=R.YPRKPC 
    ORDER BY X.YPCKPC
/


-- End of DDL Script for View SD_HOSPITAL.VW_YK_YKBSZDYDJ_DSQL