[Home] [Help] [Dependency Information]
Object Name: | AMS_ACT_CATEGORIES |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_ACT_CATEGORIES |
Subobject Name: | |
Status: | VALID |
AMS_ACT_CATEGORIES is a generic intersection table, used to specify what categories an activity belongs to. This is used to allow for categorizing activities for reporting and search capability. For example, an Event could be classified as belonging to a 'technical' category as well as 'consulting' category.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_ACT_CATEGORIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ACTIVITY_CATEGORY_ID |
AMS_ACT_CATEGORIES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ACT_CATEGORY_USED_BY_ID
ARC_ACT_CATEGORY_USED_BY CATEGORY_ID |
AMS_ACT_CATEGORIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CATEGORY_ID |
AMS_ACT_CATEGORIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ARC_ACT_CATEGORY_USED_BY
ACT_CATEGORY_USED_BY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_CATEGORY_ID | NUMBER | Yes | Unique identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes | |
ACT_CATEGORY_USED_BY_ID | NUMBER | Yes | Unique activity category code used across systems. | |
ARC_ACT_CATEGORY_USED_BY | VARCHAR2 | (30) | Yes | activity category code used by information |
CATEGORY_ID | NUMBER | Yes | Unique category identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfiled 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 ACTIVITY_CATEGORY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ACT_CATEGORY_USED_BY_ID
, ARC_ACT_CATEGORY_USED_BY
, CATEGORY_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
FROM AMS.AMS_ACT_CATEGORIES;
AMS.AMS_ACT_CATEGORIES does not reference any database object
AMS.AMS_ACT_CATEGORIES is referenced by following:
|
|
|