[Home] [Help] [Dependency Information]
Object Name: | AMV_I_PERSPECTIVES_TL |
---|---|
Object Type: | TABLE |
Owner: | AMV |
FND Design Data: | AMV.AMV_I_PERSPECTIVES_TL |
Subobject Name: | |
Status: | VALID |
Store the translatable portion of perspectives.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMV_I_PERSPECTIVES_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
PERSPECTIVE_ID
LANGUAGE ZD_EDITION_NAME |
AMV_I_PERSPECTIVES_TL_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
PERSPECTIVE_NAME
LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSPECTIVE_ID | NUMBER | Yes | Perspective 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. |
PERSPECTIVE_NAME | VARCHAR2 | (80) | Yes | Perspective Name |
DESCRIPTION | VARCHAR2 | (2000) | Perspective 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 PERSPECTIVE_ID
, LANGUAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_LANG
, PERSPECTIVE_NAME
, DESCRIPTION
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM AMV.AMV_I_PERSPECTIVES_TL;
AMV.AMV_I_PERSPECTIVES_TL does not reference any database object
AMV.AMV_I_PERSPECTIVES_TL is referenced by following:
|
|
|