门诊护士工作站-业务管理-门诊预约（触摸屏）
医生跟踪：
select distinct b.ZWXM00||'('||decode(instr(LBMC00,'号'),0,c.LBMC00,substr(c.LBMC00,1,instr(LBMC00,'号')-1))||')' as GHLBMC,b.ZWXM00,b.XKH000,c.XSXH00,b.YGBH00,a.GHHBID,GHZKMC,CKMC00,a.PXXH00 from VW_YS_KSGHHB a,BM_YGBM00 b,BM_GHLBB0 c 
where a.GHMZSJ=to_char(sysdate,'YYYYMMDD')  
 AND a.GHJSSJ>=to_char((sysdate-2/48),'HH24:mi:ss')
 AND a.GHQSSJ<=to_char((sysdate+2/48),'HH24:mi:ss')
and a.GHYSBH=b.YGBH00  and a.GHLBBH=c.LBBH00 and a.GHKSBH=474 order by a.PXXH00,c.XSXH00,b.XKH000



科室跟踪：
select distinct b.GHKSMC BMMC00,a.BMBH00,a.PXXH00,a.BH0000 from VW_YS_KSGHHB b,BM_BMBM00 a  where b.GHMZSJ=to_char(sysdate,'YYYYMMDD')   and b.PBLX00='0' and b.GHKSBH=a.BMBH00 
 AND b.GHJSSJ>=to_char((sysdate-2/48),'HH24:mi:ss')
 AND b.GHQSSJ<=to_char((sysdate+2/48),'HH24:mi:ss')
order by a.PXXH00,a.BH0000