[Home] [Help] [Dependency Information]
Object Name: | AMV_C_CHANNELS_TL |
---|---|
Object Type: | TABLE |
Owner: | AMV |
FND Design Data: | AMV.AMV_C_CHANNELS_TL |
Subobject Name: | |
Status: | VALID |
AMV_C_CHANNELS_TL stores all translated attributes for a channel.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMV_C_CHANNELS_TL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
CHANNEL_NAME ZD_EDITION_NAME |
CH_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CHANNEL_ID
LANGUAGE ZD_EDITION_NAME |
AMV_C_CHANNELS_DESC_CTX | DOMAIN | NONUNIQUE | DESCRIPTION | |
AMV_C_CHANNELS_NAME_CTX | DOMAIN | NONUNIQUE | CHANNEL_NAME | |
AMV_C_CTL_CTX_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DESCRIPTION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANNEL_ID | NUMBER | Yes | Channel Identifier | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language of the current record |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The language the text will mirror. If Text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
CHANNEL_NAME | VARCHAR2 | (80) | Yes | Channel Name |
DESCRIPTION | VARCHAR2 | (2000) | Channel Description | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT CHANNEL_ID
, LANGUAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_LANG
, CHANNEL_NAME
, DESCRIPTION
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM AMV.AMV_C_CHANNELS_TL;
AMV.AMV_C_CHANNELS_TL does not reference any database object
AMV.AMV_C_CHANNELS_TL is referenced by following:
|
|
|