[Home] [Help] [Dependency Information]
Object Name: | IBE_DSP_MSITE_SCT_SECTS |
---|---|
Object Type: | TABLE |
Owner: | IBE |
FND Design Data: | IBE.IBE_DSP_MSITE_SCT_SECTS |
Subobject Name: | |
Status: | VALID |
The table IBE_DSP_MSITE_SCT_SECTS contains the information about what sections are associated with a Specialty Store and vice versa. A Specialty Store can have many sections associated with it. A section can be associated to more than one Specialty Store.
LEVEL NUMBER column specifies the level number of child section ID. This field is applicable for only master Specialty Store. 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 Specialty Store. 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_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBE_DSP_MSITE_SCT_SECTS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | MINI_SITE_SECTION_SECTION_ID |
IBE_DSP_MSITE_SCT_SECTS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
MINI_SITE_ID
PARENT_SECTION_ID CHILD_SECTION_ID |
IBE_DSP_MSITE_SCT_SECTS_U3 | NORMAL | UNIQUE | APPS_TS_SEED |
CHILD_SECTION_ID
MINI_SITE_ID |
IBE_DSP_MSITE_SCT_SECTS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | LEVEL_NUMBER |
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 | |
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. | ||
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. |
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
, SECURITY_GROUP_ID
, MINI_SITE_ID
, PARENT_SECTION_ID
, CHILD_SECTION_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LEVEL_NUMBER
, SORT_ORDER
, CONCAT_IDS
FROM IBE.IBE_DSP_MSITE_SCT_SECTS;
IBE.IBE_DSP_MSITE_SCT_SECTS does not reference any database object
IBE.IBE_DSP_MSITE_SCT_SECTS is referenced by following:
|
|
|