Oracle Applications/Versions/Patch Levels and machine, server or instance Queries

--> What Applications/Versions/Patch Levels are loaded on my machine ?

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

--  not all applications update the next field correctly

--  and i.PATCH_LEVEL   like '11i%'

--  these are the applications that concern me most

--  and i.APPLICATION_ID in   ('0','140','260','101','200','275','201','222','185')

order by a.APPLICATION_NAME

;

--> What patches are loaded on my machine ?

select patch_name,

       patch_type,

       applied_patch_id,

       rapid_installed_flag,

       maint_pack_level

from   ad_applied_patches

where  patch_name like '%'

order by 1

;

          OR

select * from ad_bugs;

--> Question: What machine, server or instance am I using ??

SQL>   Select name from v$database;

SQL>   select instance_name from v$instance;

SQL>   select * from global_name;

SQL>   SELECT VALUE FROM V$PARAMETER WHERE NAME='db_name';

SQL>   select to_number(translate(substr(version,1,9),'1.$','1')) from v$instance;

SQL>   select s.machine from v$session s where s.audsid = userenv('sessionid');

SQL>   select global_name from global_name;