原视图脚本：
create or replace view vw_ys_brzzsq
(id0000, brid00, brxm00, brxb00, brdh00, kmh000, ickh00, brcsrq, sfzh00, jsysbh, jsysxm, jsksbh, jsksmc, sqrq00, sqsj00, yyrq00, yysj00, sqdh00, lyyy00, yyid00, zt0000, czrq00, czsj00, lb0000, scbz00, msgid0, ghid00, dah000, brdz00, jgid00, jgmc00, jsysdh, zzqzd0, bqzy00, zt00002, lb00002, fzksmc, fzbqmc, fzbz00, fzbzmc, fzksbh, fzbqbh, bqzy01, bz0000, brln00, zt0003, fzysxm, fzrq00, fzsj00, fzczy0, sfygh0)
as
select ID0000,nvl(BRID00,0),BRXM00,BRXB00,BRDH00,KMH000,ICKH00,BRCSRQ,SFZH00,
       DECODE(LB0000,0,SQYSBH,JSYSBH) JSYSBH,DECODE(LB0000,0,SQYSXM,JSYSXM) JSYSXM,DECODE(LB0000,0,SQKSBH,JSKSBH) JSKSBH,DECODE(LB0000,0,SQKSMC,JSKSMC)JSKSMC,
       SQRQ00,SQSJ00,YYRQ00,YYSJ00,SQDH00,LYYY00,YYID00,
       ZT0000,CZRQ00,CZSJ00,LB0000,SCBZ00,MSGID0,GHID00,
       DAH000,BRDZ00,JGID00,JGMC00,JSYSDH,ZZQZD0,BQZY00,
       DECODE(ZT0000,0,'有效',1,'已就诊',2,'撤销','') ZT00002,
       DECODE(LB0000,0,'转出',1,'转入','') LB00002,
       FZKSMC,FZBQMC,FZBZ00,
       DECODE(FZBZ00,0,'门诊',1,'住院','未分诊') FZBZMC,
       FZKSBH,FZBQBH,substr(BQZY00,1,120) BQZY01,BZ0000,
       SF_YS_CSRQTONL(REPLACE(BRCSRQ,'-','')) BRLN00,
       DECODE(ZT0000,0,'申请',1,'接收确认',2,'撤销','') ZT0003,
       FZYSXM,FZRQ00,FZSJ00,b.ZWXM00,SFYGH0
from YS_BRZZSQ a left join (select YGBH00,ZWXM00 from BM_YGBM00) b on a.FZCZY0=b.YGBH00;


--建议修改脚本：
create or replace view vw_ys_brzzsq
(id0000, brid00, brxm00, brxb00, brdh00, kmh000, ickh00, brcsrq, sfzh00, jsysbh, jsysxm, jsksbh, jsksmc, sqrq00, sqsj00, yyrq00, yysj00, sqdh00, lyyy00, yyid00, zt0000, czrq00, czsj00, lb0000, scbz00, msgid0, ghid00, dah000, brdz00, jgid00, jgmc00, jsysdh, zzqzd0, bqzy00, zt00002, lb00002, fzksmc, fzbqmc, fzbz00, fzbzmc, fzksbh, fzbqbh, bqzy01, bz0000, brln00, zt0003, fzysxm, fzrq00, fzsj00, fzczy0, sfygh0)
as
select 
  ID0000,nvl(BRID00,0),BRXM00,BRXB00,BRDH00,KMH000,ICKH00,BRCSRQ,SFZH00,
  --根据转入转出类别判断，如果为转出，则取申请科室名称及申请医生姓名
  DECODE(LB0000,0,SQYSBH,JSYSBH) JSYSBH,DECODE(LB0000,0,SQYSXM,JSYSXM) JSYSXM,
  DECODE(LB0000,0,SQKSBH,JSKSBH) JSKSBH,DECODE(LB0000,0,SQKSMC,JSKSMC) JSKSMC,
  SQRQ00,SQSJ00,YYRQ00,YYSJ00,SQDH00,LYYY00,YYID00,
  ZT0000,CZRQ00,CZSJ00,LB0000,SCBZ00,MSGID0,GHID00,
  DAH000,BRDZ00,JGID00,JGMC00,JSYSDH,ZZQZD0,BQZY00,
  DECODE(ZT0000,0,'有效',1,'已就诊',2,'撤销','') ZT00002,
  DECODE(LB0000,0,'转出',1,'转入','') LB00002,
  FZKSMC,FZBQMC,FZBZ00,
  DECODE(FZBZ00,0,'门诊',1,'住院','未分诊') FZBZMC,
  FZKSBH,FZBQBH,substr(BQZY00,1,120) BQZY01,BZ0000,
  SF_YS_CSRQTONL(REPLACE(BRCSRQ,'-','')) BRLN00,
  --前台状态显示修改，根据ZT0000及FZBZ00两个字段判断前台显示信息
  DECODE(ZT0000,0,DECODE(FZBZ00,2,'申请','接收确认'),1,'已就诊',2,'撤销','') ZT0003,
  FZYSXM,FZRQ00,FZSJ00,b.ZWXM00,SFYGH0
from YS_BRZZSQ a left join (select YGBH00,ZWXM00 from BM_YGBM00) b on a.FZCZY0=b.YGBH00;