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

VIEW: APPS.CS_KB_SET_ELEMENTS_V

Object Details
Object Name: CS_KB_SET_ELEMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_KB_SET_ELEMENTS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_ID NUMBER (15) Yes Set id.
SET_TYPE_ID NUMBER (15) Yes Set type id.
SET_TYPE_NAME VARCHAR2 (100) Yes Set type name.
SET_STATUS VARCHAR2 (30) Yes Set status.
SET_NAME VARCHAR2 (500) Yes Set name.
SET_DESCRIPTION VARCHAR2 (30)
Set description.
SET_COMPOSITE_ASSOC_INDEX VARCHAR2 (30)
Dummy column, use to create the intermedia index for all statements within solutions.
SET_POSITIVE_ASSOC_INDEX VARCHAR2 (30)
Dummy column, use to create the intermedia index for all positive statements within solutions.
SET_NEGATIVE_ASSOC_INDEX VARCHAR2 (30)
Dummy column, use to create the intermedia index for all negative statements within solutions.
SET_CREATION_DATE DATE
Yes Standard Who column
SET_CREATED_BY NUMBER (15) Yes Standard Who column
SET_LAST_UPDATE_DATE DATE
Yes Standard Who column
SET_LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
SETS_LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SET_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
SET_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
SET_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ORDER NUMBER (4) Yes Element order for a given set.
ASSOC_DEGREE NUMBER (4)
Element association degree with a given set, either positive or negative.
ELEMENT_ID NUMBER (15) Yes Element id.
ELEMENT_TYPE_ID NUMBER (15) Yes Element type id.
ELEMENT_TYPE_NAME VARCHAR2 (100) Yes Element type name.
ELEMENT_NAME VARCHAR2 (2000) Yes Element name or summary.
ELEMENT_DESCRIPTION CLOB (4000)
Element description or detail.
ELEMENT_CREATION_DATE DATE
Yes Standard Who column
ELEMENT_CREATED_BY NUMBER (15) Yes Standard Who column
ELEMENT_LAST_UPDATE_DATE DATE
Yes Standard Who column
ELEMENT_LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
ELEMENT_LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ELEMENT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ELEMENT_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ELEMENT_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
Query Text

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


SELECT SET_ID
,      SET_TYPE_ID
,      SET_TYPE_NAME
,      SET_STATUS
,      SET_NAME
,      SET_DESCRIPTION
,      SET_COMPOSITE_ASSOC_INDEX
,      SET_POSITIVE_ASSOC_INDEX
,      SET_NEGATIVE_ASSOC_INDEX
,      SET_CREATION_DATE
,      SET_CREATED_BY
,      SET_LAST_UPDATE_DATE
,      SET_LAST_UPDATED_BY
,      SETS_LAST_UPDATE_LOGIN
,      SET_ATTRIBUTE_CATEGORY
,      SET_ATTRIBUTE1
,      SET_ATTRIBUTE2
,      SET_ATTRIBUTE3
,      SET_ATTRIBUTE4
,      SET_ATTRIBUTE5
,      SET_ATTRIBUTE6
,      SET_ATTRIBUTE7
,      SET_ATTRIBUTE8
,      SET_ATTRIBUTE9
,      SET_ATTRIBUTE10
,      SET_ATTRIBUTE11
,      SET_ATTRIBUTE12
,      SET_ATTRIBUTE13
,      SET_ATTRIBUTE14
,      SET_ATTRIBUTE15
,      ELEMENT_ORDER
,      ASSOC_DEGREE
,      ELEMENT_ID
,      ELEMENT_TYPE_ID
,      ELEMENT_TYPE_NAME
,      ELEMENT_NAME
,      ELEMENT_DESCRIPTION
,      ELEMENT_CREATION_DATE
,      ELEMENT_CREATED_BY
,      ELEMENT_LAST_UPDATE_DATE
,      ELEMENT_LAST_UPDATED_BY
,      ELEMENT_LAST_UPDATE_LOGIN
,      ELEMENT_ATTRIBUTE_CATEGORY
,      ELEMENT_ATTRIBUTE1
,      ELEMENT_ATTRIBUTE2
,      ELEMENT_ATTRIBUTE3
,      ELEMENT_ATTRIBUTE4
,      ELEMENT_ATTRIBUTE5
,      ELEMENT_ATTRIBUTE6
,      ELEMENT_ATTRIBUTE7
,      ELEMENT_ATTRIBUTE8
,      ELEMENT_ATTRIBUTE9
,      ELEMENT_ATTRIBUTE10
,      ELEMENT_ATTRIBUTE11
,      ELEMENT_ATTRIBUTE12
,      ELEMENT_ATTRIBUTE13
,      ELEMENT_ATTRIBUTE14
,      ELEMENT_ATTRIBUTE15
FROM APPS.CS_KB_SET_ELEMENTS_V;

Dependencies

[top of page]

APPS.CS_KB_SET_ELEMENTS_V references the following:

SchemaAPPS
ViewCS_KB_ELEMENTS_V
ViewCS_KB_SETS_V
SynonymCS_KB_SET_ELES

APPS.CS_KB_SET_ELEMENTS_V is not referenced by any database object