create or replace view vw_yj_esbpacs as
select A.BRID00,'01' BRZJLX,A.BRZJBH,A.BRXM00,A.BRCSRQ,decode(A.BRXB00,'ÄÐ','1','Å®','2','0') BRXB00,A.BRMZ00,A.BRLXDZ,A.BRXZSF,A.BRXZS0,A.BRXZZ0,A.BRXZC0,A.BRYB00,A.BRLXDH,A.BRDH00,
A.BRHYZK,B.FBMC00,C.YBMC00,A.YBBRLB,A.BRZTQK,decode(A.YBKH00,'0','',A.YBKH00) as YBKH00,A.YBID00,A.BRGJ00,A.BRXX00,A.TYDWMC,A.BRZY00,
F.YJDJH0,F.ZYGHID,F.ZYHGHH,F.CH0000,F.KDBQ00,F.KDKSBH,F.YJKSBH,F.KDYS00,F.KDYSXM,SF_YJ_ESBGETBH(F.KDKSBH,1) as KDKSBM,SF_YJ_ESBGETBH(F.YJKSBH,1) as YJKSBM,
SF_YJ_ESBGETBH(F.ZLXMID,3) JCZLMC,F.ZLXMID,F.ZLXMJC,F.KDRQ00,F.KDSJ00,F.MZZYBZ,F.SL0000,F.ZJE000,F.ZXR000,F.ZXRXM0,D.JCLBID,F.CXDJH0,F.LRXM00,A.BRID00 as BRID02,'' as JG0000,
F.TXM000,F.BBID00,(select BBMC00 from BM_BBZD00 where BBID00=F.BBID00 and rownum=1) BBMC00
,F.YEXM00,F.JZBZ00,F.YZCFID,(select JCLBMC from BM_JCLB00 where JCLBID=D.JCLBID) JCLBMC
,F.BWMC00,F.BZ0000, F.SFDJH0
from BM_BRXXB0 A,BM_BRFBB0 B,IC_YBBRLB C,VW_YJ_YW0000_JCPT F,BM_ZLZD00 D
where A.FBBH00 = B.FBBH00 and A.YBLB00 = C.YBLB00 AND A.FBBH00=C.FBBH00 and A.BRID00 = F.BRID00
  and F.ZLXMID = D.ZLXMID;