CREATE OR REPLACE VIEW vw_yf_zycfdy (
   zyid00,
   ckdh00,
   brxm00,
   bq0000,
   ch0000,
   fyff00,
   fyrq00,
   fyrqxq,
   jyrq00 )
AS
select 
    A.ZYID00, A.CKDH00, A.BRXM00||a.zyh000, 
    (select D.BMMC00 from BM_BMBM00 D where D.BMBH00 = A.BQBMBH) BQ0000, 
    A.CH0000,
    rtrim(A.YFSMMC)||trim(A.YPYFMC)||rtrim(A.ZJYFMC)||trim(A.XMYFMC) FYFF00,
    (select nvl(B.YYRQ00,B.qyrq00) from BQ_YPYZ00 B where B.YZID00 = A.YZID00 and B.ZYID00 = A.ZYID00) FYRQ00,
    decode((select to_char(to_date(trim(nvl(C.YYRQ00,C.qyrq00)),'yyyymmdd') - 1,'d') from BQ_YPYZ00 C where C.YZID00 = A.YZID00 and C.ZYID00 = A.ZYID00),'1','一','2','二','3','三','4','四','5','五','6','六','7','七') FYRQXQ,    
    A.FYRQ00 JYRQ00
    from YF_YZYPSQ A
/