View Suresh Vaishya's profile
In oracle applications there are tables that ends with similar suffixes. Here I am trying to list the meaning of those, please provide your suggestion and help me if I have missed anything.
| _B | The Main base tables |
| _ALL | Contains multi org data. There will be similar table without _ALL. Before querying this data the environment variable needs to be set. Dbms_application_info.set_client_info('org_id'), or apps_initialize can be used to set the environment variable.common column. |
| _V | View created on base table. Mostly forms are created based on this views |
| _TL | Tables that support multi language. |
| _VL | View created on multi language tables. The view generally uses the base table and _tl table |
| _F | This indicates that these are the date tracking tables. These tables are generally seen for HRMS and contain 2 common columns effective_start_date and effective_end_date |
| _S | sequence related tables |
| _DFV /_KFV | The DFF/KFF table created on the base table. This is the best way to get the concatenated value of DFF/KFF. Also using this table the values can be queried based on the DFF/KFF name and not attributes column. |
2 Comments:
Suresh,
Great Work!Keep it up....
and please have a glance on the following things.
1)Suffix should be used instead of prefix since suffix is to be placed at the end of the word while prefix is present at the beginning.
2)_KFV is the view which contains all the information about Key Flex Fields while _DFV is the view which contains the information about DFF.
Thanks,
Rama Krishna Mateti
Thanks Rama for your review and comment. Appreciate that.
Post a Comment