Wednesday, June 11, 2008

Types of Apps Tables

There are following tables :

_ALL Conatains multi org data before using this table you need to set client_into to
specific org , Org_id is common column.

_V view created on base table

_VL view created on multi language tables.
always use the condition LANGUAGE = USERENV(’LANG’).

_TL Tables support multi language.

_B These Main base tables

_F these date tracked tables for only in HRMS and these table contain 2 common
columns effective_start_date and effective_end_date .

_S sequence related tables .

_AVN Audit view shadow tables contains data track information .

No comments: