Questions Related to Versions and Instance names of Database and EBS

1).To Get versions
SELECT SUBSTR(product,1,15) product,SUBSTR(version,1,15) version,SUBSTR(status,1,15) status
FROM product_component_version;
2).To Get Version
select * from v$version where banner like 'Oracle%';
3).To Get  Applications/Versions/Patch Levels
select   substr(a.APPLICATION_NAME,1,60) "Application Name"
,  substr(i.PRODUCT_VERSION,1,4)  "Version"
,  i.PATCH_LEVEL    "Patch Level"
,  i.APPLICATION_ID   "Application ID"
,  i.LAST_UPDATE_DATE   "Last Update"
from   APPS.FND_PRODUCT_INSTALLATIONS  i
,  APPS.FND_APPLICATION_ALL_VIEW  a
where   i.APPLICATION_ID   = a.APPLICATION_ID
order by a.APPLICATION_NAME
4). To Get objects under owner APPS (PKG,Views)
select owner,object_name,object_type from dba_objects where owner='APPS';
5).To Get server,instance or machine using ?
SELECT name FROM v$database;
select instance_name from v$instance;
select * from global_name;
SELECT VALUE FROM V$PARAMETER WHERE NAME='db_name';
select to_number(translate(substr(version,1,9),'1.$','1')) from v$instance;
select s.machine from v$session s where s.audsid = userenv('sessionid');
select global_name from global_name;
select sys_context('USERENV','DB_NAME') AS instance from dual;
select substr(release_name,1,7) Version,
    substr(rpad(MULTI_ORG_FLAG,2,' '),1,2) "MO",
    substr(rpad(MULTI_CURRENCY_FLAG,3,' '),1,3) "MRC"
    from apps.fnd_product_groups;
8).To Get Random Numbers
select dbms_random.random from dual;
9).To See wether multi org flag is set or not ?
select multi_org_flag from fnd_product_groups;

10). To get Patches levels
SELECT fa.application_short_name app,
  fpi.patch_level
FROM fnd_product_installations fpi,
  fnd_application fa
WHERE fa.application_id = fpi.application_id;
         (or)
 SELECT * FROM ad_applied_patches;