CREATE OR REPLACE VIEW VW_YF_YPRKCX
(rkdh00, yfbmbh, rkbmbh, rkbmmc, rklxbh, rklxmc, ypqldh, rkzt00, lyr000, lyrxm0, qrr000, qrrxm0, rkrq00, rksj00, qrrq00, qrsj00, yprkpc, ypnm00, ypbm00, ypmc00, ypgg00, rksl00, rkdw00, zhl000, gjdj00, lsdj00, pfdj00, cxbz00, cxrkpc, scph00, ypsxrq, pysm00, wbsm00, bz0000, ypmlbz, lsje00, gjje00, rkslxx, rkdbz0, rkdw01, rksl02)
AS
SELECT
  R.RKDH00,
  R.YFBMBH,
  R.RKBMBH,
  DECODE(R.RKBMBH,99999,'盘盈入库',M.BMMC00),
  R.RKLXBH,
  L.RKLXMC,
  R.YPQLDH,
  R.RKZT00,
  R.LYR000,
  G1.ZWXM00,
  R.QRR000,
  G2.ZWXM00,
  R.RKRQ00,
  R.RKSJ00,
  R.QRRQ00,
  R.QRSJ00,
  X.YPRKPC,
  X.YPNM00,
  K.YPBM00,
  X.YPMC00,
  X.YPGG00,
  X.RKSL00,
  X.RKDW00,
  X.ZHL000,
  X.GJDJ00,
  X.LSDJ00,
  X.PFDJ00,
  X.CXBZ00,
  X.CXRKPC,
  X.SCPH00,
  X.YPSXRQ,
  K.PYSM00,
  K.WBSM00,
  X.BZ0000,
  K.YPMLBZ,
  --round(X.LSDJ00*X.RKSL00*DECODE(R.RKBMBH,99999,X.ZHL000/K.K2J000,1),2) LSJE00,
  --round(X.GJDJ00*X.RKSL00*DECODE(R.RKBMBH,99999,X.ZHL000/K.K2J000,1),2) GJJE00,
  round(X.LSDJ00*X.RKSL00*X.ZHL000/K.K2J000,2) LSJE00,
  round(X.GJDJ00*X.RKSL00*X.ZHL000/K.K2J000,2) GJJE00,
  substr(sf_yf_ypslzh(X.RKSL00*X.ZHL000,X.YPNM00,3),1,50) as RKSLXX,
  decode(nvl(R.BZ0000,''),'',decode(R.RKLXBH,'05','来自请领单: '||R.YPQLDH,'08','来自调拨单: '||R.YPQLDH,R.YPQLDH),R.BZ0000) RKDBZ0,
      k.kcdw00 , --库存单位
    (k.k2j000*x.rksl00)/x.zhl000  --出库数量(库存单位)
  FROM YF_YPRKD0 R,YF_YPRKMX X,BM_YD0000 K,BM_YFRKLX L,BM_BMBM00 M,BM_YGBM00 G1,BM_YGBM00 G2
 WHERE R.RKDH00=X.RKDH00  --AND X.CXBZ00='Z'
   AND R.RKLXBH=L.RKLXBH AND R.RKBMBH=M.BMBH00(+)
   AND R.LYR000=G1.YGBH00(+) AND R.QRR000=G2.YGBH00(+)
   AND X.YPNM00=K.YPNM00
;