Oracle EBS R12 - How to get Application ID and Application Short name

SELECT APPLICATION_NAME,
               APPLICATION_SHORT_NAME,
               FA.APPLICATION_ID
   FROM FND_APPLICATION FA, FND_APPLICATION_TL FAT
 WHERE APPLICATION_SHORT_NAME LIKE '%AP%'
      AND FA.APPLICATION_ID = FAT.APPLICATION_ID
  ORDER BY FA.APPLICATION_ID;