现门诊部位展示跟踪：selECT *FROM ( select zdmsmc,zdmsh0,pysm00,wbsm00 from BM_ZDMS00 where 1=1  and  (PYSM00  like '%%') ) WHERE ROWNUM<=900
现住院部位展示跟踪：select BWBH00,BWMC00,XZBZ00,JCLBID,WBSM00,PYSM00,BWLB00 from VW_YS_BWMC00 a where 1=1 and exists(select 1 from bm_jcmlbw where instr(',38,30,0,',','||JCMLID||',')>0 and BWBH00=a.BWBH00) order by BWBH00

工程查询门诊查询语句 调整为此查询可满足需求：select zdmsmc,zdmsh0,pysm00,wbsm00 from BM_ZDMS00 a where 1=1 and exists(select 1 from bm_jcmlbw 
where instr((select ','||trim(a.flid00)||',' from BM_JCMLMX a ,bm_zlzd00 b where a.jcmlid=b.jcmlid and  b.zlxmid=31568),','||jcmlid||',')>0 and BWBH00=a.zdmsh0)   order by zdmsh0