Types of Table Extensions with Definitions in Oracle Apps

Types of Table Extensions with Definitions in Oracle Apps

Would like to share few table extensions with definitions which are used in oracle apps:

S no	Table Extension	Definition	Ex - Table names
1	_ALL	This Table holds all the information about different operating units in Multi-Org environment. client_info can also be set to a specific operating unit to see the data specific to that operating unit only.	OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL PO_DISTRIBUTIONS_ALL PO_HEADERS_ALL PO_LINES_ALL PO_LINE_LOCATIONS_ALL
2	_TL	Tables corresponding to another table with the same name minus the _TL. These tables provide multiple language support. For each item in the table without _TL there can be many rows in the _TL table, but all with different values in the LANGUAGE column.	PO_DISTRIBUTIONS_ALL_EXT_TL OE_TRANSACTION_TYPES_TL  MTL_ITEM_TEMPLATES_TL MTL_UNITS_OF_MEASURE_TL MTL_CATEGORIES_TL
3	_B	BASE tables - These Tables are very important and the data is stored with all validations. It is supposed that these table will always contain the perfect format data. If anything happens to the BASE table data, then it is a data corruption issue.	MTL_SYSTEM_ITEMS_B BOM_COMPONENTS_B BOM_STRUCTURES_B QP_LIST_HEADERS_B
4	_F	These are date tracked tables, which occur in HR and Payroll. For these there are two date columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together with the PK identifies a row uniquely. The date intervals cannot overlap.	BEN_BENEFICIARIES_F HR_ALL_POSITIONS_F PAY_ALL_PAYROLLS_F
5	_V	View Tables created on base tables	OE_ORDER_LINES_HIST_V OE_PRICE_ADJUSTMENTS_V OE_ORDER_HEADERS_HIST_V OE_ORDER_TYPES_V PO_VENDOR_SITES_ALL_V PO_ACTION_HISTORY_V
6	_VL	Multi Language View Tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USERENV(’LANG’).	FND_DESCRIPTIVE_FLEXS_VL FND_DESCR_FLEX_COL_USAGE_VL HR_FORM_WINDOWS_VL HR_FORM_ITEMS_VL
7	_S	These tables are sequences, used for finding new values for the primary key of a table.	AQ$_AR_REV_REC_QT_S IGS_PS_COO_AD_UNIT_S AQ$_FND_CP_GSM_OPP_AQTBL_S