[Home] [Help] [Dependency Information]
Object Name: | JTF_DSP_OBJ_LGL_CTNT |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_DSP_OBJ_LGL_CTNT |
Subobject Name: | |
Status: | VALID |
Stores the default logical items for selected display context labels and objects. The type of these objects can be ' C' (category), 'I' (item) or 'S' (section). The display context labels can have the type of either 'TEMPLATE' or 'MEDIA'. The type of the default logical items should be matched with the type of the display context labels, and the default logical items need to be applicable to the objects as well.
Display context labels with type 'TEMPLATE' can only be selected by category or item objects, and only the logical templates, which have been pre-assigned to the corresponding category or categories the item belongs to, are qualified to be chosen as the default logical templates.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_DSP_OBJ_LGL_CTNT_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
OBJECT_TYPE
OBJECT_ID CONTEXT_ID |
JTF_DSP_CTG_OBJ_CTNT_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | OBJECT_ID |
JTF_DSP_OBJ_LGL_CTNT_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | ITEM_ID |
JTF_DSP_OBJ_LGL_CTNT_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CONTEXT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ_LGL_CTNT_ID | NUMBER | Yes | Object Logical Content Identifier. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Standard version column |
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). | |
CONTEXT_ID | NUMBER | Yes | Display Context Identifier. | |
OBJECT_TYPE | VARCHAR2 | (1) | Yes | The type of the object. Can be either 'C' (category), 'I' (item) or 'S' (section) |
OBJECT_ID | NUMBER | Yes | Object Identifier. | |
ITEM_ID | NUMBER | Item Identifier. | ||
SECURITY_GROUP_ID | NUMBER | Security Group Identifier. |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ_LGL_CTNT_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CONTEXT_ID
, OBJECT_TYPE
, OBJECT_ID
, ITEM_ID
, SECURITY_GROUP_ID
FROM JTF.JTF_DSP_OBJ_LGL_CTNT;
JTF.JTF_DSP_OBJ_LGL_CTNT does not reference any database object
JTF.JTF_DSP_OBJ_LGL_CTNT is referenced by following:
|
|
|