Below script to find Oracle Application Modules are Licensed or Not.
Script:
SELECT fat.application_name
,fa.application_id
,fpi.patch_level
,decode(fpi.STATUS,’I’,’Licensed’, ‘N’,’Not Licensed’,’S’,’Shared’,’Undetermined’) STATUS
,fpi.*
FROM fnd_product_installations fpi
,fnd_application fa
,fnd_application_tl fat
WHERE fpi.application_id = fa.application_id
AND fat.application_id = fa.application_id
AND fat.LANGUAGE = ‘US’;
Recent Posts