Concurrent Manager Key Tables

Module: Concurrent Manager key Tables

FND_CONCURRENT_QUEUES
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_QUEUE_SIZE

Module: FND key Tables

FND_APPL_TOPS
FND_LOGINS
FND_USER
FND_DM_NODES
FND_TNS_ALIASES
FND_NODES
FND_RESPONSIBILITY
FND_DATABASES
FND_UNSUCCESSFUL_LOGINS
FND_LANGUAGES
FND_PROFILE_OPTION_VALUES
FND_APPLICATIONS

Module: FND key Tables

AD_APPLIED_PATCHES
AD_PATCH_DRIVERS
AD_BUGS
AD_INSTALL_PROCESSES
AD_SESSIONS
AD_APPL_TOPS

Useful Queries for DataBase Instance

-- Database Details  SELECT * FROM v$database
-- Instance Details  SELECT * FROM v$instance
-- License Details   SELECT * FROM v$license
-- Version Details   SELECT * FROM v$version
--Release Details    SELECT * FROM apps.fnd_product_groups
-- Patch Details     SELECT * FROM ad_applied_patchesSELECT * FROM ad_bugs