Script for finding Oracle Applications 11i and R12 Modules and their Short Names

sql> Set Markup html on;
SQL> spool on
SQL> SELECT  FND.APPLICATION_ID,  APPLICATION_SHORT_NAME, PRODUCT_CODE, APPLICATION_NAME, FNDPI.STATUS
FROM FND_APPLICATION FND , FND_APPLICATION_TL FNDTL, FND_PRODUCT_INSTALLATIONS FNDPI WHERE FND.APPLICATION_ID=FNDTL.APPLICATION_ID
AND FNDPI.APPLICATION_ID=FND.APPLICATION_ID;

SQL>spool off