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
|
No comments:
Post a Comment