SELECT A.YGBH00,A.ZWXM00,A.XKH000,A.BMBH00,SF_BM_YGXZMC(nvl(YGXZ00,'wz')) YGXZ00,(select yslbmc from BM_YSLB00 where yslb00=a.yslb00) yslb00,B.BMMC00,A.PYSM00,A.WBSM00,A.XB0000,A.czbz00,c.mc0000 zzztmc FROM BM_YGBM00 A,BM_BMBM00 B,BM_TYZD00 C  WHERE  A.BMBH00=B.BMBH00(+)  and decode(a.zzzt00,0,null,a.zzzt00)=c.nbbh00(+)     and exists (select 1 from pt_zzjgyg zzyg where zzyg.ygbh00 = a.ygbh00      and (  (exists (select 1 from pt_zzjgb0 t where zzyg.ZZJGID = t.zzjgid start with t.zzjgid =12 connect by prior t.zzjgid = t.fzjgid)) )    and  exists (select 1 from pt_zzjgb0 t where zzyg.ZZJGID = t.zzjgid start with t.zzjgid = 12 connect by prior t.zzjgid = t.fzjgid) )  ORDER BY  A.XSXH00,A.XKH000