[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_SCORES_ALL_TL |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_DM_SCORES_ALL_TL |
Subobject Name: | |
Status: | VALID |
AMS_DM_MODEL_SCORES_ALL_TL provides the facility for descriptive columns to be saved in different languages.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_DM_SCORES_ALL_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
SCORE_ID |
AMS_DM_SCORES_ALL_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SCORE_NAME
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCORE_ID | NUMBER | Yes | Unique 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 | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
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. |
SCORE_NAME | VARCHAR2 | (120) | Yes | Name of the model scoring instance. |
DESCRIPTION | VARCHAR2 | (4000) | Description of the model scoring instance. |
Cut, paste (and edit) the following text to query this object:
SELECT SCORE_ID
, LANGUAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, SOURCE_LANG
, SCORE_NAME
, DESCRIPTION
FROM AMS.AMS_DM_SCORES_ALL_TL;
AMS.AMS_DM_SCORES_ALL_TL does not reference any database object
AMS.AMS_DM_SCORES_ALL_TL is referenced by following:
|
|
|