[Home] [Help] [Dependency Information]
Object Name: | IEM_KB_CATEGORIES |
---|---|
Object Type: | TABLE |
Owner: | IEM |
FND Design Data: | IEM.IEM_KB_CATEGORIES |
Subobject Name: | |
Status: | VALID |
This table supports the generic category structure of most repositories. It is recommended that only top level categories be stored, as it will be difficult to keep track of changes in the remote KBS. APIs that populate these tables can enforce the above-mentioned recommendation.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_KB_CATEGORIES_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | KB_CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
KB_CATEGORY_ID | NUMBER | (15) | Yes | Sequence generated identifier. |
KB_PARENT_CATEGORY_ID | NUMBER | (15) | Foreign key IEM_KB_CATEGORIES. | |
DISPLAY_NAME | VARCHAR2 | (50) | Yes | Display Name. |
CATEGORY_CODE | VARCHAR2 | (50) | Yes | Value that is used to identify this category in queries. |
IS_REPOSITORY | VARCHAR2 | (1) | Y or N. Y if the specified category is also a repository. N if not. | |
CATEGORY_ORDER | NUMBER | (5) | Yes | Display order on the eMC Client. |
CATEGORY_DESC | VARCHAR2 | (400) | User defined text, 5 lines of additional information. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT KB_CATEGORY_ID
, KB_PARENT_CATEGORY_ID
, DISPLAY_NAME
, CATEGORY_CODE
, IS_REPOSITORY
, CATEGORY_ORDER
, CATEGORY_DESC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
FROM IEM.IEM_KB_CATEGORIES;
IEM.IEM_KB_CATEGORIES does not reference any database object
IEM.IEM_KB_CATEGORIES is referenced by following:
|
|
|