[Home] [Help] [Dependency Information]
Object Name: | AMV_C_CATEGORIES_TL |
---|---|
Object Type: | TABLE |
Owner: | AMV |
FND Design Data: | AMV.AMV_C_CATEGORIES_TL |
Subobject Name: | |
Status: | VALID |
AMV_C_CATEGORIES_TL stores all the translated attributes for a category.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMV_C_CATEGORIES_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
CHANNEL_CATEGORY_ID
LANGUAGE |
AMV_C_CATEGORIES_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
CHANNEL_CATEGORY_NAME
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANNEL_CATEGORY_ID | NUMBER | Yes | Category 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_CATEGORY_NAME | VARCHAR2 | (80) | Yes | Category Name |
DESCRIPTION | VARCHAR2 | (2000) | Category Description | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT CHANNEL_CATEGORY_ID
, LANGUAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_LANG
, CHANNEL_CATEGORY_NAME
, DESCRIPTION
, SECURITY_GROUP_ID
FROM AMV.AMV_C_CATEGORIES_TL;
AMV.AMV_C_CATEGORIES_TL does not reference any database object
AMV.AMV_C_CATEGORIES_TL is referenced by following:
|
|
|