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

TABLE: ONT.OE_TRANSACTION_TYPES_TL

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


This is a mult-lingual table for OE_TRANSACTION_TYPES_ALL table.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_TRANSACTION_TYPES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTRANSACTION_TYPE_ID
ColumnLANGUAGE
OE_TRANSACTION_TYPES_TL_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnNAME
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_TYPE_ID NUMBER
Yes Primary Key in translated table
LANGUAGE VARCHAR2 (4) Yes Primary Key together with Type id
SOURCE_LANG VARCHAR2 (4) Yes Language in which the name is created or updated
NAME VARCHAR2 (30) Yes Name in translated language
DESCRIPTION VARCHAR2 (2000)
User given description in translated language
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Application of concurrent program that last updated row.
PROGRAM_ID NUMBER

Concurrent program that last updated row.
REQUEST_ID NUMBER

Concurrent request that last changed row
Query Text

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


SELECT TRANSACTION_TYPE_ID
,      LANGUAGE
,      SOURCE_LANG
,      NAME
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
FROM ONT.OE_TRANSACTION_TYPES_TL;

Dependencies

[top of page]

ONT.OE_TRANSACTION_TYPES_TL does not reference any database object

ONT.OE_TRANSACTION_TYPES_TL is referenced by following:

SchemaAPPS
SynonymOE_TRANSACTION_TYPES_TL