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

TABLE: ONT.OE_SYS_PARAMETER_DEF_TL

Object Details
Object Name: OE_SYS_PARAMETER_DEF_TL
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_SYS_PARAMETER_DEF_TL
Subobject Name:
Status: VALID


This table stores OM parameter name and description. This is a multi-lingual table.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_SYS_PARAMETER_DEF_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnPARAMETER_CODE
ColumnLANGUAGE
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
PARAMETER_CODE VARCHAR2 (80) Yes Parameter Code Identifier.
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
LANGUAGE VARCHAR2 (30) Yes Language
SOURCE_LANG VARCHAR2 (4) Yes Language the text will mirror. If the text is not yet translated into LANGUAGE then any change to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (240) Yes Parameter Name
DESCRIPTION VARCHAR2 (2000)
Parameter Description.
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT PARAMETER_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LANGUAGE
,      SOURCE_LANG
,      NAME
,      DESCRIPTION
,      ZD_EDITION_NAME
FROM ONT.OE_SYS_PARAMETER_DEF_TL;

Dependencies

[top of page]

ONT.OE_SYS_PARAMETER_DEF_TL does not reference any database object

ONT.OE_SYS_PARAMETER_DEF_TL is referenced by following:

SchemaONT
ViewOE_SYS_PARAMETER_DEF_TL#