CREATE OR REPLACE VIEW VW_YF_YPCKCX
(ckdh00, yfbmbh, ckbmbh, ckbmmc, cklxbh, cklxmc, czy000, czyxm0, qrr000, qrrxm0, srrq00, srsj00, qrrq00, qrsj00, ckzt00, ypckpc, ypnm00, ypbm00, ypmc00, ypgg00, gjdj00, lsdj00, pfdj00, cksl00, ckdw00, cksl01, gjje00, ckje00, ykrkpc, zhl000, cxbz00, cxckpc, pysm00, wbsm00, bz0000, ypmlbz, tkrkdh, lyrxm0, ckdbz0, scph00, ypsxrq, sccjbh, sccjzw, ckdw01, cksl02)
AS
SELECT 
    C.CKDH00, 
    C.YFBMBH, 
    C.CKBMBH, 
    DECODE(C.CKBMBH,99999,'盘亏出库',88888,'报损出库',M.BMMC00), 
    C.CKLXBH, 
    L.CKLXMC, 
    C.CZY000, 
    Y1.ZWXM00,
    C.QRR000, 
    Y2.ZWXM00,
    C.SRRQ00, 
    C.SRSJ00, 
    C.QRRQ00, 
    C.QRSJ00, 
    C.CKZT00,  
    X.YPCKPC,  
    X.YPNM00,
    K.YPBM00,  
    X.YPMC00,  
    X.YPGG00,  
    --round(X.GJDJ00*X.ZHL000/K.K2J000,4),  
    --round(X.LSDJ00*X.ZHL000/K.K2J000,4),  
    --round(X.PFDJ00*X.ZHL000/K.K2J000,4),  
    X.GJDJ00,
    X.LSDJ00,
    X.PFDJ00,
    X.CKSL00,  
    X.CKDW00,  
    substr(SF_YF_GETYPKCZLXX(X.CKSL00*X.ZHL000,2,K.K2J000,K.ZJJL2J,K.KCDW00,K.ZJJLDW,K.JLDW00),1,50) CKSL01,  --出库数量(大小单位组合显示)
    round(X.GJDJ00*X.CKSL00*X.ZHL000/K.K2J000,2)               GJJE00,  --购进金额
    nvl(X.CKJE00,round(X.LSDJ00*X.CKSL00*X.ZHL000/K.K2J000,2)) CKJE00,  --出库金额
    X.YKRKPC,  --对应的药库入库批次    
    X.ZHL000,  
    X.CXBZ00,  
    X.CXCKPC, 
    K.PYSM00,      
    K.WBSM00, 
    X.BZ0000,
    K.YPMLBZ,
    C.BZ0000 TKRKDH,
    (select ZWXM00 from BM_YGBM00 where ygbh00=C.LYR000) LYRXM0,
    C.BZ0000 CKDBZ0,
    z.SCPH00,
    z.YPSXRQ,
    z.SCCJBH,
    z.SCCJZW,
    k.kcdw00  ckdw01, --库存单位
    round((x.zhl000*x.cksl00)/k.k2j000,3)  cksl02  --出库数量(库存单位)
FROM YF_YPCKD0 C,YF_YPCKMX X,BM_YD0000 K,BM_YFCKLX L,
     BM_BMBM00 M,BM_YGBM00 Y1,BM_YGBM00 Y2,YK_YPRKMX Z
WHERE  C.CKDH00=X.CKDH00    -- AND X.CXBZ00='Z'
   AND C.CKBMBH=M.BMBH00(+)  AND C.CKLXBH=L.CKLXBH(+)
   AND C.CZY000=Y1.YGBH00(+) AND C.QRR000=Y2.YGBH00(+)
   --AND C.CKLXBH<>'08'
   AND X.YPNM00=K.YPNM00
   and X.YKRKPC = Z.YPRKPC(+)