CREATE VIEW SD_HOSPITAL.VW_ZY_ZYFYMX_T
 (
 XMBH00, XMSL00, JZDH00, YBFSDH, ZYID00, SFYP00, DJH000, HJJE00, ZFBL00, 
KDKS00, FBBH00, YBLB00, CYRQ00, DQKS00

 )
 AS 
SELECT xmbh00, xmsl00, jzdh00, ybfsdh, b.zyid00, 'N', a.djh000,
       a.hjje00, zfbl00, a.kdks00, e.fbbh00,e.yblb00,e.cyrq00,e.dqks00
  FROM zy_fymx00 a, zy_brfy00 b,zy_brxxb0 e
 WHERE a.djh000 = b.djh000 and b.zyid00=e.zyid00 AND a.xmbh00 < 9999999990
  AND (e.fbbh00,e.yblb00) in  (SELECT fbbh00,yblb00 FROM ic_ybbrlb WHERE ybmc00 LIKE '%ΊΟ%')
union all
SELECT ypnm00, ypzsl0, jzdh00, ybfsdh, e.zyid00, 'Y', c.djh000,
       ROUND (DECODE (sfzby0, 'N', ypzsl0, 0) * lsdj00, 2) hjje00,
       zfbl00, c.dqks00,e.fbbh00,e.yblb00,e.cyrq00,e.dqks00
  FROM zy_brfy00 a, yf_zycfmx b,yf_zycf00 c,zy_brxxb0 e
 WHERE a.djh000 = c.djh000 and a.zyid00=e.zyid00 
   AND c.cflsh0 = b.cflsh0
  AND (e.fbbh00,e.yblb00) in  (SELECT fbbh00,yblb00 FROM ic_ybbrlb WHERE ybmc00 LIKE '%ΊΟ%')
union all
SELECT ypnm00, ypzsl0, jzdh00, ybfsdh, a.zyid00, 'Y', a.djh000,
       ROUND (ypzsl0 * lsdj00, 2) hjje00, zfbl00, b.dqks00,e.fbbh00,e.yblb00,e.cyrq00,e.dqks00
  FROM zy_brfy00 a, yf_yzypsq b,zy_brxxb0  e
 WHERE a.djh000 = b.djh000 and a.zyid00=b.zyid00 and a.zyid00=e.zyid00
  AND (e.fbbh00,e.yblb00) in  (SELECT fbbh00,yblb00 FROM ic_ybbrlb WHERE ybmc00 LIKE '%ΊΟ%')
/