Multi Language Support Setup

 Hi All,

               We have currently upgraded from 11i to R12.1.2 and we have decided to USE MLS & NLS(Multi Language Support) for the very 1st time.We have 4 Languages (American,Spanish,French,Porteguse) so when we query for data in _tl tables(ap_terms_tl,ra_terms_tl,fnd_responsibility_tl) we get four records for a single term_id becasue we are using 4 languages so we need to keep a language join. What I am doing is

   Select * from ap_terms_tl where agent_id = 5 and langauge = USERENV('LANG'); which retruns only one row with US as the language. Here is a sceneario where I am struck I want to see data in a different language like spanish or french or porteguse  so how can i acheive that. what i am trying to do is