EBS表后缀的意义

zhtv

Object NameFunction of the objectE.g._ALLUnderlying table with all the valuesPO_DISTRIBUTIONS_ALL_BBase of underlying table, same as _ALLMTL_SYSTEM_ITEMS_B_TLLanguage translation table with translation of descriptive fields in different languagesFND_RESPONSIBILITY_TL_VLView based on translation table,are views for multi language tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USERENV('LANG'). _Vtables are the views created on base tablesPJM_PROJECTS_ALL_V_BASIC_VView on top of the Basic table _DFVDescriptive Flex Field related view, it will have the defined values as Column names instead of generic attribute 1, ..2 _KFVKey Flex Field views contain the concatenated fields as it would be displayed to the user. For e.g. A field may consist of Division, Department and Account fields and the KFV will have the concatenated values.eg.GL_CODE_COMBINATIONS_KFV_Sare sequences, used for finding new values for the primary key of a table. _Aare Audit Shadow Tables _AVNand _ACN are Audit Shadow Views (when data was changed, and with what values SELECT * FROM dba_objects WHERE object_name LIKE 'MTL%_KFV' AND object_type = 'VIEW'可以见MTL下的KFV主要包括Item,SO,Locator,Categories..
　　
　　

MTL_SYSTEM_ITEMS_B_KFV

MTL_SYSTEM_ITEMS_B1_KFV

MTL_SALES_ORDERS_KFV

MTL_ITEM_LOCATIONS_KFV

MTL_ITEM_CATALOG_GROUPS_B_KFV

MTL_GENERIC_DISPOSITIONS_KFV

MTL_CATEGORIES_B_KFV