CREATE OR REPLACE VIEW SD_HOSPITAL.VW_GG_YSHS00
 (
 KHXM00, ZWXM00, XKH000, YGBH00, BMBH00, PYSM00, WBSM00

 )
 AS 
SELECT  XKH000||'-'||ZWXM00 KHXM00,
	ZWXM00,
	XKH000,
	A.YGBH00,
	B.BMBH00,
	PYSM00,
	WBSM00
FROM    BM_YGBM00 A,XT_YHBMQX B
WHERE   A.YGBH00<>0 AND (A.CZBZ00='1'OR A.CZBZ00='0') AND A.BMBH00>0
 AND A.YGBH00=B.YGBH00
 AND UPPER(substr(xkh000,1,1)) not in ('Z','M')
/