CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YK_YPQLDCX
 (
 YPQLDH, YKBMBH, CKQXBH, CKQXMC, CKLXBH, CKLXMC, QLRQ00, QLSJ00, CZYBH0, 
CZYXM0, QRRBH0, QRRXM0, LYRBH0, LYRXM0, QLZT00, QLZTMC, QRRQ00, QRSJ00, 
SHRQ00, ZKJE00, YPQLPC, YPNM00, YPBM00, LBBH00, YLBH00, JXBH00, YPMC00, 
YPGG00, QLDW00, GJDJ00, PFDJ00, QLDJ00, ZHL000, QLSL00, SFSL00, BZ0000, 
FPH000, KL0000, PYSM00

 )
 AS 
SELECT
  Q.YPQLDH,
  Q.YKBMBH,
  Q.CKQXBH,
  DECODE(Q.CKQXBH,99999,'盘亏出库',88888,'报损出库',(SELECT F.CRBMMC FROM VW_YK_YPCRKDW F WHERE Q.CKQXBH=F.CRBMNM)),  --出库去向部门名称
  Q.CKLXBH,
  (SELECT L.CKLXMC FROM BM_YKCKLX L WHERE Q.CKLXBH=L.CKLXBH),
  Q.QLRQ00,
  Q.QLSJ00,
  Q.CZYBH0,
  (SELECT Y1.ZWXM00 FROM BM_YGBM00 Y1 WHERE Q.CZYBH0=Y1.YGBH00),
  Q.QRRBH0,
  (SELECT Y2.ZWXM00 FROM BM_YGBM00 Y2 WHERE Q.QRRBH0=Y2.YGBH00),
  Q.LYRBH0,
  (SELECT Y3.ZWXM00 FROM BM_YGBM00 Y3 WHERE Q.LYRBH0=Y3.YGBH00),
  Q.QLZT00,
  DECODE(QLZT00,'3','已生成申领单，但未发送','0','药房已发送，药库未出库','1','药库已出库,药房未入库','2','药房已入库','其它'),
  Q.QRRQ00,
  Q.QRSJ00,
  Q.SHRQ00,
  Q.ZKJE00,
  X.YPQLPC,
  X.YPNM00,
  D.YPBM00,
  D.LBBH00,
  D.YLBH00,
  D.JXBH00,
  X.YPMC00,
  X.YPGG00,
  X.QLDW00,
  X.GJDJ00,
  X.PFDJ00,
  X.QLDJ00,
  X.ZHL000,
  X.QLSL00,
  DECODE(Q.QLZT00,'0',0,X.SFSL00),
  X.BZ0000,
  X.FPH000,
  X.KL0000,
  d.pysm00
FROM YK_YPQLD0 Q,YK_YPQLMX X,BM_YD0000 D
WHERE  Q.YPQLDH=X.YPQLDH
   AND X.YPNM00=D.YPNM00
/