what kind of transmission could i put in my 02 Cadillac STS?

I need to replace the transmission and was hoping to find one at pick a part. What other cars have the same kind of tranny? If any more info is needed, olease let me know. I'm not very auto tech savvy.