[Home] [Help] [Dependency Information]
Object Name: | CS_KB_USED_SUM_DEFS_B |
---|---|
Object Type: | TABLE |
Owner: | CS |
FND Design Data: | CS.CS_KB_USED_SUM_DEFS_B |
Subobject Name: | |
Status: | VALID |
Knowledge Base Used Summary Definitions (Base table). This table stores a list of defined Periods of Time, as found under the Setup tab in the 'Frequently Used Definitions' section. This data is used in the Solution Category browsing in Knowledge Management and by the 'Frequently Used Solutions' section in iSupport.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CS_KB_USED_SUM_DEFS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | DEF_ID |
CS_KB_USED_SUM_DEFS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | DEFAULT_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEF_ID | NUMBER | (15) | Yes | Used Summary Definition id. |
DAYS | NUMBER | Number of days. | ||
DEFAULT_FLAG | VARCHAR2 | (1) | Default flag. | |
ACTIVATED_FLAG | VARCHAR2 | (1) | Activated Flag. | |
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 DEF_ID
, DAYS
, DEFAULT_FLAG
, ACTIVATED_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_USED_SUM_DEFS_B;
CS.CS_KB_USED_SUM_DEFS_B does not reference any database object
CS.CS_KB_USED_SUM_DEFS_B is referenced by following:
|
|
|