How to get product code and application short name

Run below query to get product code and application short name for General Ledger. Replace "General Ledger" with your application module name.

SELECT A.product_code, A.application_short_name, T.DESCRIPTION
FROM FND_APPLICATION A,
FND_APPLICATION_TL T
WHERE A.APPLICATION_ID = T.APPLICATION_ID
AND T.APPLICATION_NAME = 'General Ledger';

Navigation:

Sysadmin (or Implementation Analyst) --> Application: Register