Get all installed products in E-Business Suite:
set linesize 130
col application_name format a50
col meaning format a15
select b.application_name, c.meaning From applsys.FND_PRODUCT_INSTALLATIONS a, applsys.fnd_application_tl b,APPLSYS.fnd_lookup_values c
where a.application_id = b.application_id
and a.status = c.lookup_code
and c.lookup_Type = 'FND_PRODUCT_STATUS';
set linesize 130
col application_name format a50
col meaning format a15
select b.application_name, c.meaning From applsys.FND_PRODUCT_INSTALLATIONS a, applsys.fnd_application_tl b,APPLSYS.fnd_lookup_values c
where a.application_id = b.application_id
and a.status = c.lookup_code
and c.lookup_Type = 'FND_PRODUCT_STATUS';
Comments