[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_TARGETS_TL |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_DM_TARGETS_TL |
Subobject Name: | |
Status: | VALID |
Multi-lingual support table for data mining targets.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_DM_TARGETS_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
TARGET_ID
LANGUAGE |
AMS_DM_TARGETS_TL_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
TARGET_NAME
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TARGET_ID | NUMBER | Yes | Unique identifier. | |
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 | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
SOURCE_LANG | VARCHAR2 | (4) | 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. | |
TARGET_NAME | VARCHAR2 | (240) | Yes | Name of the target. |
DESCRIPTION | VARCHAR2 | (4000) | Description of the target. |
Cut, paste (and edit) the following text to query this object:
SELECT TARGET_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, LANGUAGE
, SOURCE_LANG
, TARGET_NAME
, DESCRIPTION
FROM AMS.AMS_DM_TARGETS_TL;
AMS.AMS_DM_TARGETS_TL does not reference any database object
AMS.AMS_DM_TARGETS_TL is referenced by following:
|
|
|