Know license applications

Know license applications:-
-------------------------------

Lot many times we would not be known if the client has the specific application license or not.

We can ask the client is one way. If you have access to the back-end for the production Instance. Then you could know with following query. This is the Other way.

All the applications which are Installed status are license one.

SELECT application_name
, application_short_name
,DECODE (status, 'I', 'Installed', 'S', 'Shared', 'Not Installed') status
, a.application_id
,i.patch_level
FROM fnd_application_all_view a
, fnd_product_installations i
WHERE a.application_id = i.application_id
ORDER BY 1;