[Home] [Help] [Dependency Information]
Object Name: | JTF_DSP_MSITE_SCT_SECTS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_DSP_MSITE_SCT_SECTS |
Subobject Name: | |
Status: | VALID |
The table JTF_DSP_MSITE_SCT_SECTS contains the information about what sections are associated with a mini-site and vice versa. A mini-site can have many sections associated with it.
A section can be asscociated to more than one mini-site.
LEVEL NUMBER column specifies the level number of child section ID. This field is applicable for only master mini-site ID. Root section ID will have level number 1, and its children will have level number 2, and so on.
SORT_ORDER column specifies the order of the child section within the parent section. This field is used for displaying child sections under a parent section.
CONCAT_IDS column is applicable only for master mini-site id. It stores the concatenation of the section IDs of its ancestors sections starting from the root section ID. The delimiter used between the section IDs is '.'. The last section ID in the field is the current section's parent section ID.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_DSP_MSITE_SCT_SECTS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | MINI_SITE_SECTION_SECTION_ID |
JTF_DSP_MSITE_SCT_SECTS_U2 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
MINI_SITE_ID
PARENT_SECTION_ID CHILD_SECTION_ID |
JTF_DSP_MSITE_SCT_SECTS_U3 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
CHILD_SECTION_ID
MINI_SITE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MINI_SITE_SECTION_SECTION_ID | NUMBER | Yes | Mini site section section identifier. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object Version Number for Locking |
CREATED_BY | NUMBER | 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 | 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 | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
MINI_SITE_ID | NUMBER | Yes | Mini site identifier | |
PARENT_SECTION_ID | NUMBER | Parent Section identifier | ||
CHILD_SECTION_ID | NUMBER | Yes | Identifier of the child section for the parent section. | |
START_DATE_ACTIVE | DATE | Yes | Start date active. | |
END_DATE_ACTIVE | DATE | End date active. | ||
LEVEL_NUMBER | NUMBER | The level number of child section ID. | ||
SORT_ORDER | NUMBER | Specifies the order of the child section within the parent section. | ||
CONCAT_IDS | VARCHAR2 | (2000) | Stores the concatenation of the section IDs of its ancestors sections starting from the root section. | |
SECURITY_GROUP_ID | NUMBER | Security Group Identifier. |
Cut, paste (and edit) the following text to query this object:
SELECT MINI_SITE_SECTION_SECTION_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MINI_SITE_ID
, PARENT_SECTION_ID
, CHILD_SECTION_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LEVEL_NUMBER
, SORT_ORDER
, CONCAT_IDS
, SECURITY_GROUP_ID
FROM JTF.JTF_DSP_MSITE_SCT_SECTS;
JTF.JTF_DSP_MSITE_SCT_SECTS does not reference any database object
JTF.JTF_DSP_MSITE_SCT_SECTS is referenced by following:
|
|
|