[Home] [Help] [Dependency Information]
Object Name: | IEU_SH_ACTIVITIES# |
---|---|
Object Type: | VIEW |
Owner: | IEU |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_ID | NUMBER | (15) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SECURITY_GROUP_ID | NUMBER | |||
SESSION_ID | NUMBER | (15) | Yes | |
ACTIVITY_TYPE_ID | NUMBER | (15) | Yes | |
ACTIVITY_TYPE_CODE | VARCHAR2 | (32) | Yes | |
BEGIN_DATE_TIME | DATE | Yes | ||
END_DATE_TIME | DATE | |||
MEDIA_TYPE_ID | NUMBER | (15) | ||
MEDIA_ID | NUMBER | (15) | ||
ACTIVE_FLAG | VARCHAR2 | (1) | ||
COMPLETION_CODE | VARCHAR2 | (30) | ||
DELIVER_DATE_TIME | DATE | |||
REASON_CODE | VARCHAR2 | (30) | ||
REQUEST_METHOD | VARCHAR2 | (30) | ||
REQUESTED_MEDIA_TYPE_ID | NUMBER | (15) | ||
STATE_CODE | VARCHAR2 | (30) | ||
WORK_ITEM_TYPE_CODE | VARCHAR2 | (30) | ||
WORK_ITEM_PK_ID | NUMBER | |||
FORCE_CLOSED_BY_UWQ_FLAG | VARCHAR2 | (240) | ||
CATEGORY_TYPE | VARCHAR2 | (30) | ||
CATEGORY_VALUE | VARCHAR2 | (128) | ||
PARENT_CYCLE_ID | NUMBER | (15) |
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#;
|
|
|