Looking at buying a prelude 1997 vti-r auto edition.

Are the failures or problems with the auto transmission that bad, like needing complete rebuilds etc?

And also if i am buying a car thats done about 120-140,000km what service will i be looking at doing?