--药品对应跟踪
select YPBM00,YPMC00,YPGG00,PYSM00,WBSM00,KCDW00,LSJ000,CFJB00,GZDJ00,MZDJ00,SJDJ00,DPDJ00,YPFLDM,
decode(TZRQ00,null,'在用','停用') ZT0000,XZTS00,YPSLSX,MZFYDW,
(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW,
(select ylmc00 FROM bm_ypyl00 where lbbh00=A.lbbh00 and ylbh00=A.ylbh00) YLMC00,YPMLBZ,YPTYM0,TYPE00,XMBH00,BH0000,YBZXLB,YPNM00
from bm_yd0000 a,BM_XMBZ00 b
where a.ypnm00=b.xmbh00 and b.type00='0'
and b.ybzxlb='1'
and b.bh0000='M03900'
order by a.YPBM00;


--项目对应跟踪
select ZLXMBH,ZLXMJC,DW0000,A.WBSM00,A.PYSM00,LBMC00,ZLXMID 
from BM_ZLZD00 a,BM_ZLXMLB b,BM_XMBZ00 c
where  a.lbbh00=b.lbbh00 and a.zlxmid=c.xmbh00 and c.type00='1' 
and c.ybzxlb='1'
and c.bh0000='M01600'
order by a.ZLXMBH