DBA Data[Home] [Help] [Dependency Information]


TABLE: INV.MTL_ITEM_TEMPLATES_TL

Object Details
Object Name: MTL_ITEM_TEMPLATES_TL
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_ITEM_TEMPLATES_TL
Subobject Name:
Status: VALID


MTL_ITEM_TEMPLATES_TL is a table holding translated Template and Description columns for Templates.
Templates now support multilingual description. MLS is implemented with a pair of tables: MTL_ITEM_TEMPLATES_B and MTL_ITEM_TEMPLATES_TL. Translations table (MTL_ITEM_TEMPLATES_TL) holds template name and descriptions in multiple languages.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_ITEM_TEMPLATES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_ID
ColumnLANGUAGE
MTL_ITEM_TEMPLATES_TL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_NAME
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER
Yes Unique identifier for the Template
TEMPLATE_NAME VARCHAR2 (30) Yes This column contains translated Template name
DESCRIPTION VARCHAR2 (240) Yes This column contains translated Template description
LANGUAGE VARCHAR2 (3) Yes Current context language for this row
SOURCE_LANG VARCHAR2 (3) Yes Source language for this row
CREATED_BY NUMBER
Yes User id of Person who created record
CREATION_DATE DATE
Yes Date record was created
LAST_UPDATED_BY NUMBER
Yes User id of last person modifying the record
LAST_UPDATE_DATE DATE
Yes Date record was last modified
LAST_UPDATE_LOGIN NUMBER

Login of last person who updated record
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TEMPLATE_ID
,      TEMPLATE_NAME
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM INV.MTL_ITEM_TEMPLATES_TL;

Dependencies

[top of page]

INV.MTL_ITEM_TEMPLATES_TL does not reference any database object

INV.MTL_ITEM_TEMPLATES_TL is referenced by following:

SchemaAPPS
SynonymMTL_ITEM_TEMPLATES_TL