[Home] [Help] [Dependency Information]
Object Name: | IBE_MSITES_TL |
---|---|
Object Type: | TABLE |
Owner: | IBE |
FND Design Data: | IBE.IBE_MSITES_TL |
Subobject Name: | |
Status: | VALID |
IBE_MSITES_TL stores translated information about the Specialty Store (mini site)
in IBE_MSITES_B. Each row includes the language the row is translated to, the
translated attributes of the Specialty Store, and theSpecialty Store identifier which uniquely
identifies theSpecialty Store.. You need one row for eachSpecialty Store in each of the installed
languages. Each row includes a language and SOURCE_LANG column which can
be used to determine if a value has been translated or defaulted.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBE_MSITES_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
MSITE_ID
LANGUAGE ZD_EDITION_NAME |
IBE_MSITES_TL_N999 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_SEED | NLS_UPPER("MSITE_NAME") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSITE_ID | NUMBER | Yes | Mini Site Identifier. | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language to which the Row is translated. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version number for Locking. |
CREATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Security Group Identifier. | ||
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language from which the row is translated. |
MSITE_NAME | VARCHAR2 | (120) | Name of the mini site. | |
MSITE_DESCRIPTION | VARCHAR2 | (4000) | Description for the store | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT MSITE_ID
, LANGUAGE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, SOURCE_LANG
, MSITE_NAME
, MSITE_DESCRIPTION
, ZD_EDITION_NAME
FROM IBE.IBE_MSITES_TL;
IBE.IBE_MSITES_TL does not reference any database object
IBE.IBE_MSITES_TL is referenced by following:
|
|
|