[Home] [Help]
[Dependency Information]
Object Name: | IEU_SH_ACTIVITIES |
---|---|
Object Type: | TABLE |
Owner: | IEU |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEU_SH_ACTIVITIES_U1 | NORMAL | UNIQUE |
![]() |
![]() |
IEU_SH_ACTIVITIES_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() |
IEU_SH_ACTIVITIES_N2 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
IEU_SH_ACTIVITIES_N3 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
IEU_SH_ACTIVITIES_N4 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_ID | NUMBER | (15) | Yes | Uniquely identifies the row. |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard column used by HTML utilities. | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO columns. |
CREATION_DATE | DATE | Yes | Standard WHO columns. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO columns. |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO columns. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO columns. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
SESSION_ID | NUMBER | (15) | Yes | Uniquely identifies the row. |
ACTIVITY_TYPE_ID | NUMBER | (15) | Yes | References activity type base table. |
ACTIVITY_TYPE_CODE | VARCHAR2 | (32) | Yes | Used programmatically to identify activity types. |
BEGIN_DATE_TIME | DATE | Yes | Time the session began. | |
END_DATE_TIME | DATE | Time the session ended. | ||
MEDIA_TYPE_ID | NUMBER | (15) | References media type involved in activity, if any. | |
MEDIA_ID | NUMBER | (15) | References JTF_IH media involved in activity, if any. | |
ACTIVE_FLAG | VARCHAR2 | (1) | Indicates if record is still active, or completed. | |
COMPLETION_CODE | VARCHAR2 | (30) | For activity types that can end for multiple reasons, indicates the type of completion. References the FND_LOOKUP_TYPE IEU_SH_COMPL_CODE. | |
DELIVER_DATE_TIME | DATE | Time the item was delivered. Does not apply to all activity types. | ||
REASON_CODE | VARCHAR2 | (30) | Contains the reason for the activity, if applicable. References the FND_LOOKUP_TYPE IEU_CTRL_BREAK_REASON. | |
REQUEST_METHOD | VARCHAR2 | (30) | For non-media activities, specifies the request type. References the FND_LOOKUP_TYPE IEU_SH_REQ_METHOD. | |
REQUESTED_MEDIA_TYPE_ID | NUMBER | (15) | References the media type requested as part of the activity, if any. Foreign key to IEU_UWQ_MEDIA_TYPES_B. | |
STATE_CODE | VARCHAR2 | (30) | Contains the current state of the activity. This is specific to each activity. | |
WORK_ITEM_TYPE_CODE | VARCHAR2 | (30) | Contains the object code of the non-media work item, if any. Foreign key to JTF_OBJECTS_B. | |
WORK_ITEM_PK_ID | NUMBER | Contains the primary key of the non-media work item. | ||
FORCE_CLOSED_BY_UWQ_FLAG | VARCHAR2 | (240) | Indicates if the record is force 'Closed' by UWQ, after being identified as 'Idle'. For e.g. a case where the Agent session got crashed. | |
CATEGORY_TYPE | VARCHAR2 | (30) | An activity-specific category type identifier. | |
CATEGORY_VALUE | VARCHAR2 | (128) | An activity-specific category identifier. | |
PARENT_CYCLE_ID | NUMBER | (15) | For media activities, contains the ID of the containing media cycle. |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, SESSION_ID
, ACTIVITY_TYPE_ID
, ACTIVITY_TYPE_CODE
, BEGIN_DATE_TIME
, END_DATE_TIME
, MEDIA_TYPE_ID
, MEDIA_ID
, ACTIVE_FLAG
, COMPLETION_CODE
, DELIVER_DATE_TIME
, REASON_CODE
, REQUEST_METHOD
, REQUESTED_MEDIA_TYPE_ID
, STATE_CODE
, WORK_ITEM_TYPE_CODE
, WORK_ITEM_PK_ID
, FORCE_CLOSED_BY_UWQ_FLAG
, CATEGORY_TYPE
, CATEGORY_VALUE
, PARENT_CYCLE_ID
FROM IEU.IEU_SH_ACTIVITIES;
IEU.IEU_SH_ACTIVITIES does not reference any database object
IEU.IEU_SH_ACTIVITIES is referenced by following:
|
|
|