Query to Find Oracle Apps Module's Short Names

The following query can be used to find Application Short Name for any modules like Inventory, Order Management, Manufacturing, etc which are commonly used for uploading/downloading .ldt files, submitting a concurrent program from back end and many other purposes.

*********************************************************************************
SELECT fa.application_id    AS "Application ID",
  fat.application_name           AS "Application Name",
  fa.application_short_name  AS "Application Short Name",
  fa.basepath                          AS "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) = UPPER('&Application_Name') /* Pass your Application Name as Parameter here */
ORDER BY fat.application_name;
/
*********************************************************************************

HAPPY LEARNING...!!!