Oracle EBS is shipped with its own data dictionary on top of standard Oracle database system catalog. It is accessible through tables in FND schema. EBS has 20k+ table across mutliple schema , which is not easy to remember or search.
Below are the Tables which will provide information of schema objects:
FND_TABLES - tables
FND_VIEWS - views
FND_COLUMNS - table and column views
FND_FOREIGN_KEYS - foreign keys
FND_FOREIGN_KEY_COLUMNS - foreign key columns
FND_INDEXES - unique and non-unique indexes
FND_INDEX_COLUMNS - index columns
FND Tables for Labels/Description:
FND_FLEX_VALUES
FND_FLEX_VALUES_TL
FND_ID_FLEX_SEGMENTS