Search This Blog

Monday, 26 October 2015

Query to find Oracle EBS Application Short Name of a module


/* Find out Oracle EBS application short name with id */

SELECT FA.APPLICATION_ID           "Application ID",
       FAT.APPLICATION_NAME        "Application Name",
       FA.APPLICATION_SHORT_NAME   "Application Short Name",
       FA.BASEPATH                 "Basepath"

  FROM FND_APPLICATION     FA,
       FND_APPLICATION_TL  FAT

 WHERE FA.APPLICATION_ID = FAT.APPLICATION_ID
   AND FAT.LANGUAGE      = USERENV('LANG')
    AND UPPER(FAT.APPLICATION_NAME) LIKE '%PURCH%'  -- <change it>
 ORDER BY FAT.APPLICATION_NAME;