CREATE OR REPLACE VIEW SD_HOSPITAL.VW_XK_JCPXMX
 (
 SQDH00, XXZXM0, XX0000, XDBH00, XYPZMC, RKSL00, CXRQ00, FJXDXX, FJXDRH, 
FJXX00, JCPXJG, SXCF00, RHXX00, XX0001

 )
 AS 
SELECT b.sqdh00,xxzxm0, xx0000, a.xdbh00, a.XYPZMC, rksl00 || rkdw00 rksl00, cxrq00,c.zdxx00 as fjxdxx,c.rhxx00 as fjxdrh,
       decode(trim(fjxdxx),',','血型:' || fjxdxx) ||decode(trim(fjxdrh),',', '  RH:' || fjxdrh) fjxx00,
       '主管:'||ZCJG00||';次管:'||CCJG00 JCPXJG,
       (select mc0000 from bm_tyzd00 where zdmc00='输血成分' and instr(a.xypzmc,mc0000)>0 and rownum=1) sxcf00,
       a.RHXX00,'血型:'||a.xx0000||chr(10)||'RH(D):'||a.RHXX00 xx0001
  FROM xk_xyrk00 a, xk_jcpxbg b,xk_brxx00 c,XK_SXSQ00 d
 WHERE a.xdbh00 = b.xdbh00 and d.brid00=c.brid00 and b.sqdh00 =d.sqdh00
/