CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YF_YPCKMX_FR3
 (
 CKDH00, YPBM00, YPMC00, YPGG00, CKDW00, LSDJ00, CKSL00, BZ0000, YPSXRQ, 
GJDJ00, GJJE00, SCPH00

 )
 AS 
select 
a.CKDH00,--出库单号
(select YPBM00 from BM_YD0000 where a.YPNM00=YPNM00 and rownum=1) YPBM00,--编码
a.YPMC00,--名称
a.YPGG00,--规格
a.CKDW00,--出库单位
a.LSDJ00,--零售单价
a.CKSL00,--出库数量
a.BZ0000, --备注
C.YPSXRQ,
a.GJDJ00,
round(a.GJDJ00*a.CKSL00*a.ZHL000/b.K2J000,2) GJJE00,
C.SCPH00
from  YF_YPCKMX a,BM_YD0000 b, YK_YPRKMX C
where a.ypnm00=b.ypnm00 AND   A.YKRKPC = C.YPRKPC(+)
/