CREATE VIEW SD_HOSPITAL.VW_YK_YFYPSYL
 (
 YFBMBH, YPNM00, JZRQ00, FCSL00, ZHL000, K2J000

 )
 AS 
SELECT YFBMBH,YPNM00+0,JZRQ00,FCSL00,ZHL000,
(SELECT K2J000 FROM BM_YD0000 WHERE YPNM00=A.YPNM00)
FROM YF_YPMXZ0 A
WHERE A.JZXZ00='C' AND (
(A.RCLXBH IN ('03','09','10') and (select trim(VALUE0) from xt_xtcs00 where name00='YK_SFXSGYFSYL')<>'M') 
or (A.RCLXBH IN ('01','03','05','06','07','08','09','10') and (select trim(VALUE0) from xt_xtcs00 where name00='YK_SFXSGYFSYL')='M')
)
/