[Home] [Help] [Dependency Information]
Object Name: | CS_KB_SET_USED_SUMS |
---|---|
Object Type: | TABLE |
Owner: | CS |
FND Design Data: | CS.CS_KB_SET_USED_SUMS |
Subobject Name: | |
Status: | VALID |
Knowledge Base Set Used Summaries. This table keep track of the Useage Count for a Solution over a period of time. The Used Count is related to whether the Solution has been viewed and Solved the issue. The data stored in this table is used only in iSupport in the 'Frequently Used Solutions' section. The content of this table is populated by a Concurrent Program "Knowledge Management Update Solution Used Count"
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CS_KB_SET_USED_SUMS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_ID
DEF_ID |
CS_KB_SET_USED_SUMS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DEF_ID
USED_COUNT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_ID | NUMBER | (15) | Yes | Set id. |
DEF_ID | NUMBER | (15) | Yes | Definition id. |
USED_COUNT | NUMBER | Yes | Usage count for a given set and definition. | |
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 | |
REQUEST_ID | NUMBER | (15) | Standard Concurrent Program Column. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Concurrent Program Column. | |
PROGRAM_ID | NUMBER | (15) | Standard Concurrent Program Column. | |
PROGRAM_UPDATE_DATE | DATE | Standard Concurrent Program 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_ID
, DEF_ID
, USED_COUNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, 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_USED_SUMS;
CS.CS_KB_SET_USED_SUMS does not reference any database object
CS.CS_KB_SET_USED_SUMS is referenced by following:
|
|
|