CREATE OR REPLACE VIEW SD_HOSPITAL.VW_XK_XYRK00
 (
 RKDH00, XKBMBH, XYLYMC, XYLYDW, XYPZMC, XX0000, RHXX00, XXZXM0, XDBH00, 
CXRQ00, RKSL00, RKDW00, CXZXM0, DJ0000, JE0000, LRYGBH, LRRQ00, LRSJ00, 
RKYGBH, RKRQ00, RKSJ00, RKZT00, CKZT00, CKLXMC, CFWZ00, YXRQ00, BZ0000, 
XYPZID, KSMC00, ZYH000, XM0000, CH0000, CKRQ00, LRYGXM, CXRQ01, YXRQ01, 
RKRQSJ, CKRQSJ, RKPCH0, YXSJ00, CXSJ00, CXRQSJ, YXRQSJ, YSTJ00, WLWG00, 
FBJBZ0, BQTX00, ZYHGHH, FJJE00, FPH000, FPRQ00, FPSJ00, YQMC00

 )
 AS 
select
    A.RKDH00, A.XKBMBH, A.XYLYMC, A.XYLYDW, A.XYPZMC, A.XX0000,
    A.RHXX00, A.XXZXM0, A.XDBH00, A.CXRQ00, A.RKSL00, A.RKDW00,
    A.CXZXM0, A.DJ0000, A.JE0000, A.LRYGBH, A.LRRQ00, A.LRSJ00,
    A.RKYGBH, A.RKRQ00, A.RKSJ00, A.RKZT00, A.CKZT00, A.CKLXMC,
    A.CFWZ00, A.YXRQ00, nvl(A.BZ0000, '合格') BZ0000, A.XYPZID,
    B.KSMC00, B.ZYH000, B.XM0000, B.CH0000, B.CKRQ00,
    (select ZWXM00 from BM_YGBM00 where YGBH00=A.LRYGBH) LRYGXM,
    substr(A.CXRQ00,1,4)||'-'||substr(A.CXRQ00,5,2)||'-'||substr(A.CXRQ00,7,2) CXRQ01,
    substr(A.YXRQ00,1,4)||'-'||substr(A.YXRQ00,5,2)||'-'||substr(A.YXRQ00,7,2) YXRQ01,
    substr(A.RKRQ00,1,4)||'-'||substr(A.RKRQ00,5,2)||'-'||substr(A.RKRQ00,7,2)||' '||A.RKSJ00 RKRQSJ,
    substr(B.CKRQ00,1,4)||'-'||substr(B.CKRQ00,5,2)||'-'||substr(B.CKRQ00,7,2)||' '||B.CKSJ00 CKRQSJ,
    A.RKPCH0, A.YXSJ00, A.CXSJ00,
    substr(A.CXRQ00,1,4)||'-'||substr(A.CXRQ00,5,2)||'-'||substr(A.CXRQ00,7,2)||' '||A.CXSJ00 CXRQSJ,
    substr(A.YXRQ00,1,4)||'-'||substr(A.YXRQ00,5,2)||'-'||substr(A.YXRQ00,7,2)||' '||A.YXSJ00 YXRQSJ,
    A.YSTJ00, A.WLWG00, A.FBJBZ0, A.BQTX00, A.ZYHGHH,
    (select FJJE00 from BM_XYXX00 T, BM_TYZD00 W
      where T.NBBH00 = W.NBBH00 and W.ZDMC00 = '血液品种' and W.MC0000 = A.XYPZMC) as FJJE00,
    A.FPH000,--发票号
    A.FPRQ00,--发票日期
    A.FPSJ00,--发票时间  
    (select YYJC00 from BM_BMBM00 M,XT_YYXX00 Y where BMBH00=A.XKBMBH and M.YYID00=Y.YYID00) YQMC00     
  from XK_XYRK00 A left join VW_XK_XYCKCX B
    on A.XDBH00 = B.XDBH00(+)
      and nvl(B.CXBZ00, 'Z') = 'Z'
/