eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IBE.IBE_DSP_SECTIONS_B

Object Details

Object Name:	IBE_DSP_SECTIONS_B
Object Type:	TABLE
Owner:	IBE
FND Design Data:	IBE.IBE_DSP_SECTIONS_B
Subobject Name:
Status:	VALID

This table contains information about the sections, which are nodes in a hierarchy.
DISPLAY_CONTEXT_ID column is used to specify the display context to be used by the leaf product items under this section. This field would be relevant for only leaf sections.
AVAILABLE_IN_ALL_SITES_FLAG determines if a section is included or excluded by default in all mini-sites. If this flag is 'Y', this section will be included in all mini-sites by default. If merchant want to exclude this section from a particular mini-site it can be excluded from that particular mini-site.
If this flag is set to 'N', this section will not be included in any mini-site by default. If merchant want to include this section in a particular mini-site, it can be include in that particular mini-site.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBE_DSP_SECTIONS_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	SECTION_ID
IBE_DSP_SECTIONS_B_U2	NORMAL	UNIQUE	APPS_TS_SEED	ACCESS_NAME
IBE_DSP_SECTIONS_B_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	SECTION_TYPE_CODE
IBE_DSP_SECTIONS_B_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
SECTION_ID	NUMBER		Yes	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.
ACCESS_NAME	VARCHAR2	(240)		Internal or access name or section code for the section. This field is used to uniquely identify a section.
START_DATE_ACTIVE	DATE		Yes	Start date active
END_DATE_ACTIVE	DATE			End date active.
SECTION_TYPE_CODE	VARCHAR2	(30)	Yes	The type of section. It will be used to differentiate between normal section nodes and featured section nodes which are non-navigational.
STATUS_CODE	VARCHAR2	(30)	Yes	The status of section. Section status can be PUBLISHED or UNPUBLISHED. UNPUBLISHED sections are not displayed to the store users.
DISPLAY_CONTEXT_ID	NUMBER			Display Context Identifier.
DELIVERABLE_ID	NUMBER			Logical template (or deliverable) Identifier.
AVAILABLE_IN_ALL_SITES_FLAG	VARCHAR2	(3)		Flag to determine inclusion (Y) or exclusion (N) of a section in all mini-sites by default.
AUTO_PLACEMENT_RULE	VARCHAR2	(512)		For Future Releases. Not Currently used.
ORDER_BY_CLAUSE	VARCHAR2	(512)		This field will be used to order the product items under a leaf section.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SECTION_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      ACCESS_NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SECTION_TYPE_CODE
,      STATUS_CODE
,      DISPLAY_CONTEXT_ID
,      DELIVERABLE_ID
,      AVAILABLE_IN_ALL_SITES_FLAG
,      AUTO_PLACEMENT_RULE
,      ORDER_BY_CLAUSE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM IBE.IBE_DSP_SECTIONS_B;

Dependencies

[top of page]

IBE.IBE_DSP_SECTIONS_B does not reference any database object

IBE.IBE_DSP_SECTIONS_B is referenced by following:

APPS: IBE_DSP_SECTIONS_B