create or replace view vw_yk_zsmrkmx as

select
  A.RKDH00,
  A.YPRKPC,
  A.YPNM00,
  B.YPBM00,
  B.YPMC00,
  A.YPGG00,
  A.FPGJDJ,
  A.RKSL00,
  A.PCKCSL,
  A.RKDW00,
  substrb((select to_char(wm_concat(PZBSM0)) from  YK_YPZSM0 where YPNM00=A.YPNM00),1,200) PZBSM0,               --药品标识码
  --(nvl(A.RKSL00,0)*A.ZHL000+nvl(A.JLRKSL,0)*A.JLZHL0)/B.K2J000 ZSMSL0,
  (nvl(A.RKSL00,0)*A.ZHL000+nvl(A.JLRKSL,0)*A.JLZHL0)/NVL(B.ZSMZHL,B.K2J000) ZSMSL0,
  (select count(1) from YK_RKZSM0 k where k.YPNM00 = A.YPNM00 and k.YKRKPC = A.YPRKPC and ZSMLY0 in ('0','1','3','4')) YSMSL0,
  (select to_char(count(1)) from YK_RKZSM0 k where k.YPNM00 = A.YPNM00 and k.YKRKPC = A.YPRKPC and ZSMLY0 in ('0','1','3','4'))||'/'||TO_CHAR((nvl(A.RKSL00,0)*A.ZHL000+nvl(A.JLRKSL,0)*A.JLZHL0)/NVL(B.ZSMZHL,B.K2J000) ) SMSLMC,
  A.SCPH00,
  A.SCRQ00,
  A.YPSXRQ  YXQ000
from YK_YPRKMX A,BM_YD0000 B
where A.YPNM00 = B.YPNM00