[Home] [Help] [Dependency Information]
Object Name: | JTF_DSP_CONTEXT_B |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_DSP_CONTEXT_B |
Subobject Name: | |
Status: | VALID |
JTF_DSP_CONTEXT_B stores the display context labels. A display context label can be uniquely identified by its access_name. The type of the display context labels can be 'TEMPLATE' or' MEDIA', representing display styles and multimedia components respectively. Users are not allowed to change the types of any existing display context labels.
Each display context lable can also be assigned one default logical item with the same type.
The default logical item is defined in table JTF_AMV_ITEMS_B, containing information about the
logical display template or media file.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_DSP_CONTEXT_B_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | CONTEXT_ID |
JTF_DSP_CONTEXT_B_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | ITEM_ID |
JTF_DSP_CONTEXT_B_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CONTEXT_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTEXT_ID | NUMBER | Yes | Display Context Identifier. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version Number for Locking. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ACCESS_NAME | VARCHAR2 | (40) | Yes | Unique non translated name for display contexts for media and templates. |
CONTEXT_TYPE_CODE | VARCHAR2 | (30) | Yes | The type of the display context label, can be TEMPLATE, MEDIA or user defined. |
ITEM_ID | NUMBER | Item Identifier. | ||
SECURITY_GROUP_ID | NUMBER | Security Group Identifier. |
Cut, paste (and edit) the following text to query this object:
SELECT CONTEXT_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACCESS_NAME
, CONTEXT_TYPE_CODE
, ITEM_ID
, SECURITY_GROUP_ID
FROM JTF.JTF_DSP_CONTEXT_B;
JTF.JTF_DSP_CONTEXT_B does not reference any database object
JTF.JTF_DSP_CONTEXT_B is referenced by following:
|
|
|