---收治界面主治医生取值跟踪-------
SELECT *FROM ( select ysxm00,xkh000,pysm00,wbsm00,ygbh00 from VW_BQ_YSZYS_YDHL where 1=1  and yszid0='2' and yszt00!=3  and czbz00!=2 and yslb00 in (select yslb00 from bm_yslb00 where yslbmc like '%主治医%') and  (pysm00  like '%%') ) WHERE ROWNUM<=999

---入科信息修改界面，主治医生的取值---
SELECT *FROM ( select ysxm00,xkh000,pysm00,wbsm00,ygbh00 from VW_BQ_YSZYS_YDHL where 1=1  and yszid0='3' and yszt00!=3 and czbz00!=2 and yslb00 in (select yslb00 from bm_yslb00 where yslbmc like '%主治医%') and  (pysm00  like '%%') ) WHERE ROWNUM<=999