[Home] [Help] [Dependency Information]
Object Name: | AMS_IBA_PL_SITES_TL |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_IBA_PL_SITES_TL |
Subobject Name: | |
Status: | VALID |
Stores the translation details of sites.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_IBA_PL_SITES_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SITE_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_ID | NUMBER | Yes | Unique Identifier | |
NAME | VARCHAR2 | (240) | Yes | Name of the site |
DESCRIPTION | VARCHAR2 | (4000) | Description of the site | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language of the current row |
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. |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in the hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Used for locking purpose |
Cut, paste (and edit) the following text to query this object:
SELECT SITE_ID
, NAME
, DESCRIPTION
, LANGUAGE
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM AMS.AMS_IBA_PL_SITES_TL;
AMS.AMS_IBA_PL_SITES_TL does not reference any database object
AMS.AMS_IBA_PL_SITES_TL is referenced by following:
|
|
|