Applications

select
a.application_id,
a.application_short_name,
t.application_name

from
fnd_application a,
fnd_application_tl t

where
a.application_id=t.application_id
and t.language='US'

order by
t.application_name