Query to Find a Application Shortname

SELECT A.APPLICATION_ID "APPLICATION ID",
  B.APPLICATION_NAME "APPLICATION NAME",
  A.APPLICATION_SHORT_NAME "APPLICATION SHORT NAME",
  A.BASEPATH "BASEPATH"
FROM FND_APPLICATION A,
  FND_APPLICATION_TL B
WHERE A.APPLICATION_ID = B.APPLICATION_ID
AND B.LANGUAGE         = USERENV('LANG')
AND B.APPLICATION_NAME = <'%YOUR APPLICATION NAME%'>
ORDER BY B.APPLICATION_NAME;