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

TABLE: OTA.OTA_ACTIVITY_DEFINITIONS_TL

Object Details
Object Name: OTA_ACTIVITY_DEFINITIONS_TL
Object Type: TABLE
Owner: OTA
FND Design Data: TableOTA.OTA_ACTIVITY_DEFINITIONS_TL
Subobject Name:
Status: VALID


This table only contains a subset of the columns from the base table.
Contains translated Name and description of Activity Definition.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: OTA_ACTIVITY_DEFINITIONS_TL_PK
  1. ColumnACTIVITY_ID
  2. ColumnLANGUAGE
Indexes
Index Type Uniqueness Tablespace Column
OTA_ACTIVITY_DEFINITIONS_TL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVITY_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ID NUMBER (9) Yes The system generated surrogate key for this module.
LANGUAGE VARCHAR2 (4) Yes Language
NAME VARCHAR2 (240) Yes The user name for the module.
DESCRIPTION VARCHAR2 (4000)
Free text comments further describing this module.
SOURCE_LANG VARCHAR2 (4) Yes Source of Language
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT ACTIVITY_ID
,      LANGUAGE
,      NAME
,      DESCRIPTION
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OTA.OTA_ACTIVITY_DEFINITIONS_TL;

Dependencies

[top of page]

OTA.OTA_ACTIVITY_DEFINITIONS_TL does not reference any database object

OTA.OTA_ACTIVITY_DEFINITIONS_TL is referenced by following:

SchemaAPPS
TriggerOTA_ACTIVITY_DEFINIT041313_WHO
SynonymOTA_ACTIVITY_DEFINITIONS_TL