[Home] [Help] [Dependency Information]
Object Name: | WF_ITEM_ACTIVITY_STATUSES# |
---|---|
Object Type: | VIEW |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_TYPE | VARCHAR2 | (8) | Yes | |
ITEM_KEY | VARCHAR2 | (240) | Yes | |
PROCESS_ACTIVITY | NUMBER | Yes | ||
ACTIVITY_STATUS | VARCHAR2 | (8) | ||
ACTIVITY_RESULT_CODE | VARCHAR2 | (30) | ||
ASSIGNED_USER | VARCHAR2 | (320) | ||
NOTIFICATION_ID | NUMBER | |||
BEGIN_DATE | DATE | |||
END_DATE | DATE | |||
EXECUTION_TIME | NUMBER | |||
ERROR_NAME | VARCHAR2 | (30) | ||
ERROR_MESSAGE | VARCHAR2 | (2000) | ||
ERROR_STACK | VARCHAR2 | (4000) | ||
OUTBOUND_QUEUE_ID | RAW | (16) | ||
DUE_DATE | DATE | |||
SECURITY_GROUP_ID | VARCHAR2 | (32) | ||
ACTION | VARCHAR2 | (30) | ||
PERFORMED_BY | VARCHAR2 | (320) | ||
INST_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_TYPE
, ITEM_KEY
, PROCESS_ACTIVITY
, ACTIVITY_STATUS
, ACTIVITY_RESULT_CODE
, ASSIGNED_USER
, NOTIFICATION_ID
, BEGIN_DATE
, END_DATE
, EXECUTION_TIME
, ERROR_NAME
, ERROR_MESSAGE
, ERROR_STACK
, OUTBOUND_QUEUE_ID
, DUE_DATE
, SECURITY_GROUP_ID
, ACTION
, PERFORMED_BY
, INST_ID
FROM APPLSYS.WF_ITEM_ACTIVITY_STATUSES#;
|
|
|