CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YJ_SYXSKP_TITLE
 (
 YJDJH0, CFLSH0, ZYHGHH, ZXRQ00, XM0000, NL0000, XB0000, RYCWH0, KDRQ00, 
CFID00, ZB0003, BRBLH0, PCMC00

 )
 AS 
select
  b.YJDJH0 YJDJH0,
  b.CFLSH0 CFLSH0,
  b.GHH000 ZYHGHH,
  substr(a.ZBBZ00,1,10) ZXRQ00,
  b.XM0000 XM0000,
  b.NL0000 NL0000,
  b.XB0000 XB0000,
  nvl(trim(b.CH0000),'无') RYCWH0,
  b.KDRQ00 KDRQ00,
  c.CFID00 CFID00,
  b.ZB0003 ZB0003,
  b.BRBLH0 BRBLH0,
  b.PCMC00 PCMC00
from YJ_ZLXMID_TMP a,VW_YJ_SYKP00 b,YS_CFMX00 c
where a.ZLXMID=c.CFID00 and c.CFLSH0=b.CFLSH0
and b.KDRQ00>=to_char(sysdate-30,'yyyymmdd')
/