CREATE OR REPLACE VIEW vw_sf_jsddy (
   qyxx00,
   jzrq00,
   brxm00,
   ybkh00,
   ybid00,
   ghh000,
   brzje0,
   grzhzf,
   tcjjzf,
   zfje00,
   ybzhye,
   zye000,
   zwxm00,
   tsbzmc,
   fbbh00,
   jzdh00,
   ybdjh0,
   pjh000,
   xjfkje,
   zzfkje )
AS
select
     b.QYXX00,
     b.JZRQ00,
     a.BRXM00,
     a.YBKH00,
     a.YBID00,
     b.GHH000,
     b.BRZJE0,
     b.GRZHZF,
     b.TCJJZF,
     decode(substr(b.ZFJE00,1,1),'.',0||b.ZFJE00,b.ZFJE00),
     b.YBZHYE,
     d.ZYE000,
     c.ZWXM00,
     b.TSBZMC,
     a.FBBH00,
     b.JZDH00,
     e.YBDJH0,
     b.PJH000,
     b.XJFKJE,
     b.ZZFKJE
 from BM_BRXXB0 a,vw_sf_fp0000 b,bm_ygbm00 c,SF_BRZHXX d,SF_JZB000 e
 where b.JZY000=c.YGBH00 and a.brid00=d.brid00(+) and a.brid00=b.brid00 and e.JZDH00=b.JZDH00
/