abc

col NAME for a10
col HOST for a30
col RELEASE for a20
col VERSION for a20
set lines 200
select i.instance_name NAME, i.host_name HOST, f.release_name RELEASE, i.version VERSION from v$instance i,apps.fnd_product_groups f;

 

col ABBREVIATION for a20
col CODELEVEL for a20
set lines 200
select abbreviation, codelevel FROM apps.AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad','atg_pf','fnd');