How to check Oracle Applications products installed in R12

Query to find out license products installed.

SQL> select fa.APPLICATION_SHORT_NAME, fpi.PATCH_LEVEL, DECODE(fpi.STATUS, 'I','Installed',
'S','Shared', 'N', 'Inactive', fpi.STATUS) Status , fpi.DB_STATUS
from fnd_product_installations fpi,FND_APPLICATION fa
where fpi.APPLICATION_ID in (
select APPLICATION_ID from FND_APPLICATION)
and fa.APPLICATION_ID=fpi.APPLICATION_ID;

 OR Other way from Front-hand.

1) From OAM: Oracle Applications Manager > Site Map > License Manager > Reports 

> License Products/Shared Products

2) Use $AD_TOP/sql/adutconf.sql