CREATE OR REPLACE VIEW VW_YK_YPRKDZDYDJ_DSQL
(rkdh00, fph000, fprq00, ypbm00, ypmc00, yptym0, ypgg00, rkdw00, rksl00, fpgjdj, gjdj00, pfdj00, jhrq00, kl0000, gjje00, lsdj00, bz0000, sccjzw, scph00, ypsxrq, sfzbyp, fpgjje, mxzkje, lsje00, fpje00, jxcj00, cj0000, plcj00, cjl000, zlqk00, ysjl00, yprkpc)
AS
SELECT X.RKDH00,X.FPH000,X.FPRQ00,D.YPBM00,D.YPMC00,D.YPTYM0,X.YPGG00,X.RKDW00,
     (X.RKSL00+nvl(round(X.JLRKSL/D.K2ZJJL,3),0)) RKSL00,--计价数量+剂量数量
     X.FPGJDJ,X.GJDJ00,X.PFDJ00,X.JHRQ00,
     X.KL0000,X.GJJE00,X.LSDJ00,X.BZ0000,X.SCCJZW,X.SCPH00,X.YPSXRQ,X.SFZBYP,
     ROUND(X.RKSL00*X.FPGJDJ,2) AS FPGJJE,X.ZKJE00 MXZKJE,
     ROUND(X.RKSL00*X.LSDJ00,2) AS LSJE00,ROUND(X.RKSL00*X.PFDJ00,2) AS PFJE00,
     ROUND(ROUND(X.RKSL00*X.LSDJ00,2)-X.GJJE00,2) AS JXCJ00,
     ROUND(ROUND(X.RKSL00*X.PFDJ00,2)-X.GJJE00,2) AS CJ0000,
     ROUND(X.RKSL00*X.LSDJ00,2)-ROUND(X.RKSL00*X.PFDJ00,2) AS PLCJ00,
     DECODE(X.PFDJ00,0,1,ROUND(((X.LSDJ00-X.PFDJ00)/X.PFDJ00),2)) AS CJL000,
     '合格','合格',X.YPRKPC
   FROM YK_YPRKMX X,BM_YD0000 D
   WHERE X.YPNM00=D.YPNM00
   ORDER BY X.YPRKPC
;