/* 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;
No comments:
Post a Comment