[Home] [Help] [Dependency Information]
Object Name: | CS_KB_SET_ELE_TYPES |
---|---|
Object Type: | TABLE |
Owner: | CS |
FND Design Data: | CS.CS_KB_SET_ELE_TYPES |
Subobject Name: | |
Status: | VALID |
Knowledge Base Set Element Types. This table implements the many to many relationship between Set types and Element types. This table therefore stores which Statement Types are associated to each Solution Type. For each Solution Type this table stores whether the Statements are optional or not.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CS_KB_SET_ELE_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
SET_TYPE_ID
ELEMENT_TYPE_ID |
CS_KB_SET_ELE_TYPES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | ELEMENT_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_TYPE_ID | NUMBER | (15) | Yes | Set type id. |
ELEMENT_TYPE_ID | NUMBER | (15) | Yes | Element type id. |
ELEMENT_TYPE_ORDER | NUMBER | (4) | Yes | Element type order. |
OPTIONAL_FLAG | VARCHAR2 | (1) | Element type optional flag for a given set type. | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
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 | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT SET_TYPE_ID
, ELEMENT_TYPE_ID
, ELEMENT_TYPE_ORDER
, OPTIONAL_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
FROM CS.CS_KB_SET_ELE_TYPES;
CS.CS_KB_SET_ELE_TYPES does not reference any database object
CS.CS_KB_SET_ELE_TYPES is referenced by following:
|
|
|