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 |