How to get Application Short Name, Base Path, Application Name in Oracle application

Find all Application Short Name, Application Name and Product base path

select fa.APPLICATION_ID
, fa.APPLICATION_SHORT_NAME
, fat.APPLICATION_NAME
, fa.PRODUCT_CODE
, fa.BASEPATH
from fnd_application fa,
fnd_application_tl fat
where fa.APPLICATION_ID = fat.APPLICATION_ID
order by APPLICATION_SHORT_NAME,
APPLICATION_SHORT_NAME;
Find single application short name

SELECT fa.application_short_name, fat.application_id, fa.basepath,
fa.product_code
FROM fnd_application_tl fat, fnd_application fa
WHERE fat.application_id = fa.application_id
AND fat.application_name = 'Purchasing'