Useful Queries

--Finding Invaled Objects
select count(*) from dba_objects where status ='INVALID'

--To Check which node is running what service
select * from fnd_nodes

--Information about the bugs fixed in Installation
select * from ad_bugs

--Information about the applied patches
select * from ad_applied_patches

--Stores values for various profile options
select * from fnd_profile_option_values

--Information about various profile options
select * from fnd_profile_options

--To Find database version
select * from v$version

--To Determine Oracle Apps 11i Version ?
select release_name from fnd_product_groups;