Naming convention of oracle apps DB objects


Following is the naming convention that oracle apps uses on its Database objects:

Object name ending with
Description of the Object
_B
The Main base tables
_ALL
Contains multi-org data
_V
View created on base table
_TL
Table that supports multi language
_VL
View created on multi language tables
_F
Data tracking tables. Used in HRMS
_S
Sequence related table
_DFV / _KFV
The DFF/KFF table created on the base table