Oracle Sql Script To Find The Installed Modules & Data Base Version

Version :

 SELECT * FROM V$VERSION;

Installed Modules :

select * from (select   substr(a.APPLICATION_NAME,1,60) "AN"
,  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)
--where AN like  ('%CPC%').


Ur's
AmarAlam