select
	YJDJH0,
	zlxmid,
	txm000,
	SF_JY_GET_ZJE000(YJDJH0,ZLXMID) ZJE000,
	ZYHGHH,
	MZZYBZ,
--	(select zlxmjc from bm_zlzd00 where zlxmid=a.zlxmid) zlxmjc,-- 项目名称 
	DECODE(nvl((select trim(value0) from xt_xtcs00 where name00='JY_QDSJQZDZ'),'N'),'Y',sf_jy_union_xmmc00(txm000),(select zlxmjc from bm_zlzd00 where zlxmid=a.zlxmid)) zlxmjc,
	(select sjid00 from JY_QDPZ00 where zlxmid=a.zlxmid) sjid00,
	(select ddid00 from JY_QDPZ00 where zlxmid=a.zlxmid) ddid00,
--	SF_JY_GET_QDSJ00(a.jyywid,a.zlxmid) QDSJ00,
	DECODE(nvl((select trim(value0) from xt_xtcs00 where name00='JY_QDSJQZDZ'),'N'),'Y',SF_JY_GETQDSJ_MAX(txm000),'M',sf_jy_getqdsj_zhxyy(txm000),
    SF_JY_GET_QDSJ00(a.jyywid,a.zlxmid)) qdsj00,
	decode(nvl((select trim(value0) from xt_xtcs00 where name00='JY_JYJBSFXMZY'),'N'),'N',
	(select ddmc00 from JY_QDPZ00 b,JY_QDDD00 c where b.zlxmid=a.zlxmid and b.ddid00=c.ddid00),'Y',
	 (select ddmc00 from JY_QDPZ00 b,JY_QDDD00 c where b.zlxmid=a.zlxmid and b.ddid00=c.ddid00 and a.zlxmid in (5405,4951,5424,3729,5329,5176,5407,5178,5311,5372,4956,4936,5371,5375)
     union
     select ddmc00 from JY_QDPZ00 b,JY_QDDD00 c where b.zlxmid=a.zlxmid and b.ddid00=c.ddid00 and a.zlxmid not in (3729,5329,5176,5407,5178,5424,5177,5175,4934,4935,4936) and a.zlxmid not in (select e.zlxmid from JY_TXMDY0 e,jy_txmlb0 f where e.txmqz0=f.txmqz0 and f.txmmc0='送检') and a.sqks00<>229
     union
     select ddmc00 from JY_QDPZ00 b,JY_QDDD00 c where b.zlxmid=a.zlxmid and b.ddid00=c.ddid00 and a.zlxmid  in (5177,5175,4934,4935,5371,5375) and a.sqks00<>229
     union
     select '导诊台自助取单机' from JY_QDPZ00 b,JY_QDDD00 c where b.zlxmid=a.zlxmid and b.ddid00=c.ddid00 and a.zlxmid not in (5424,3729,5329,5176,5407,5178,5311,5372,4956,4936) and a.zlxmid not in (select e.zlxmid from JY_TXMDY0 e,jy_txmlb0 f where e.txmqz0=f.txmqz0 and f.txmmc0='送检') and a.sqks00=229
     union
    select decode(a.sqks00,'229','三楼妇保科大厅','230','一楼门诊内科','导诊台自助取单机')  from jy_qdpz00 b  where a.zlxmid=b.zlxmid  and b.zlxmid in (select e.zlxmid from JY_TXMDY0 e,jy_txmlb0 f where e.txmqz0=f.txmqz0 and  f.txmmc0='送检') and b.zlxmid not in (5371,5375)
    )
    ) ddmc00,
	(SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(to_date(B.BBCYRQ,'yyyymmdd'),'day') FROM JY_YW0000 B WHERE B.YJDJH0 = A.YJDJH0 AND ROWNUM = 1))
	QZMC00  --取单前缀
from JY_YW0000 a
where mzzybz = '0' and jgzt00 in('0','1');