--药品分类明细账出现负数，改视图
CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YK_YPZMCX
 (
 YKBMBH, YPNM00, YPBM00, YPMC00, YPGG00, KCDW00, K2J000, GJJ000, LSJ000, 
ZBJ000, YPJCL0, KCSL00, KCJE00, KCGJJE, KCSX00, KCXX00, LBBH00, YLBH00, 
JXBH00, PYSM00, WBSM00, JLDW00, ZYFYDW, MZFYDW, Z2J000, M2J000, TZRQ00, 
PDXH00, ZTBZ00, ZYJCSL, ZYJCJE, ZYGJJE, SCCJZW, CJYLBH, BZ0000, PFJ000, 
CGBZ00, YPMLBZ, MRCGSL, ZBQMC0

 )
 AS 
SELECT
  X.YKBMBH,
  A.YPNM00,
  A.YPBM00,
  A.YPMC00,
  A.YPGG00,
  A.KCDW00,
  A.K2J000,
  A.GJJ000,
  A.LSJ000,
  A.ZBJ000,
  A.YPJCL0,        --加成率
  ROUND(DECODE((SELECT TRIM(VALUE0) FROM XT_XTCS00 WHERE NAME00='YK_SFQYLSYP'),'Y',
  X.KCSL00,A.KCSL00)/K2J000,3),
  DECODE((SELECT TRIM(VALUE0) FROM XT_XTCS00 WHERE NAME00='YK_SFQYLSYP'),'Y',
  X.KCJE00,A.KCJE00),
  DECODE((SELECT TRIM(VALUE0) FROM XT_XTCS00 WHERE NAME00='YK_SFQYLSYP'),'Y',
  X.KCGJJE,A.KCGJJE),
  X.KCSX00,
  X.KCXX00,
  A.LBBH00,
  A.YLBH00,
  A.JXBH00,
  A.PYSM00,
  A.WBSM00,
  A.JLDW00,
  A.ZYFYDW,
  A.MZFYDW,
  A.Z2J000,
  A.M2J000,
  A.TZRQ00,
  X.PDXH00,
  X.ZTBZ00, 
  ROUND(DECODE((SELECT TRIM(VALUE0) FROM XT_XTCS00 WHERE NAME00='YK_SFQYLSYP'),'Y',
  X.ZYJCSL,a.kcsl00)/K2J000,3),
  DECODE((SELECT TRIM(VALUE0) FROM XT_XTCS00 WHERE NAME00='YK_SFQYLSYP'),'Y',
  X.ZYJCJE,A.ZYJCJE),
  DECODE((SELECT TRIM(VALUE0) FROM XT_XTCS00 WHERE NAME00='YK_SFQYLSYP'),'Y',
  X.ZYGJJE,A.ZYGJJE),
  (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH),
  (select CJYLBH from BM_CJYLBM where LSH000=A.CYLLSH),
  X.BZ0000,
  A.PFJ000,
  X.CGBZ00,
  A.YPMLBZ,
  X.MRCGSL,
  A.ZBQMC0   
FROM BM_YD0000 A,YK_YPKCXX X
WHERE A.YPNM00=X.YPNM00 /*AND A.YKBMBH=X.YKBMBH*/