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: JTF.JTF_DSP_SECTIONS_B

Object Details

Object Name:	JTF_DSP_SECTIONS_B
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_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_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_DSP_SECTIONS_B_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	SECTION_ID
JTF_DSP_SECTIONS_B_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ACCESS_NAME

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 - 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).
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.
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 in version 11.5.1
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 definition 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
SECURITY_GROUP_ID	NUMBER			Security Group Identifier.
STATUS_CODE	VARCHAR2	(30)		The status of section. Section status can be PUBLISHED or UNPUBLISHED. UNPUBLISHED sections are not displayed to the store users.

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
,      ACCESS_NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SECTION_TYPE_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
,      SECURITY_GROUP_ID
,      STATUS_CODE
FROM JTF.JTF_DSP_SECTIONS_B;

Dependencies

[top of page]

JTF.JTF_DSP_SECTIONS_B does not reference any database object

JTF.JTF_DSP_SECTIONS_B is referenced by following:

APPS: JTF_DSP_SECTIONS_B