Runtime Views for Approvals

Previous Next JavaScript must be enabled to correctly display this content

19.6.12 Runtime Views for Approvals

Learn about the APEX_TASKS, APEX_TASK_COMMENTS, APEX_TASK_HISTORY, APEX_TASK_PARAMETERS, and APEX_TASK_PARTICIPANTS views.

There are five public views available for the Approvals Component:

APEX_TASKS, for the properties of each task instance.
APEX_TASK_COMMENTS, for all comments entered on each task instance.
APEX_TASK_HISTORY, for the chronological series of operations performed during the lifecycle of a task instance, including the user associated with the update and the date the operation was performed.
APEX_TASK_PARAMETERS, for the parameters defined for a task instance along with their computed runtime values in String format.
APEX_TASK_PARTICIPANTS, for the list of participants on each task instance. Note that this list can differ from the list in the task definition due to business administrators inviting new participants.

APEX_TASKS

Name	Null?	Type
`TASK_ID`	`NOT NULL`	`NUMBER`
`WORKSPACE_ID`	`NOT NULL`	`NUMBER`
`WORKSPACE`	`NOT NULL`	`VARCHAR2(255)`
`WORKSPACE_DISPLAY_NAME`	N/A	`VARCHAR2(4000)`
`APPLICATION_ID`	`NOT NULL`	`NUMBER`
`APPLICATION_NAME`	`NOT NULL`	`VARCHAR2(255)`
`TASK_DEF_ID`	N/A	`NUMBER`
`TASK_DEF_NAME`	N/A	`VARCHAR2(255)`
`TASK_DEF_STATIC_ID`	N/A	`VARCHAR2(255)`
`PREVIOUS_TASK_ID`	N/A	`NUMBER`
`SUBJECT`	N/A	`VARCHAR2(1000)`
`DUE_ON`	N/A	`TIMESTAMP(6) WITH TIME ZONE`
`PRIORITY`	`NOT NULL`	`NUMBER(1)`
`PRIORITY_LEVEL`	N/A	`VARCHAR2(6)`
`DETAIL_PK`	N/A	`VARCHAR2(400)`
`INITIATOR`	N/A	`VARCHAR2(255)`
`ACTUAL_OWNER`	N/A	`VARCHAR2(255)`
`PREVIOUS_OWNER`	N/A	`VARCHAR2(255)`
`STATE_CODE`	N/A	`VARCHAR2(10)`
`STATE`	N/A	`VARCHAR2(10)`
`RENEWAL_COUNT`	N/A	`NUMBER`
`OUTCOME_CODE`	N/A	`VARCHAR2(32)`
`OUTCOME`	N/A	`VARCHAR2(32)`
`CREATED_BY`	N/A	`VARCHAR2(255)`
`CREATED_ON`	`NOT NULL`	`TIMESTAMP(6) WITH TIME ZONE`
`LAST_UPDATED_BY`	N/A	`VARCHAR2(255)`
`LAST_UPDATED_ON`	N/A	`TIMESTAMP(6) WITH TIME ZONE`

APEX_TASK_COMMENTS

Name	Null?	Type
`TASK_ID`	`NOT NULL`	`NUMBER`
`WORKSPACE`	`NOT NULL`	`VARCHAR2(255)`
`WORKSPACE_DISPLAY_NAME`	N/A	`VARCHAR2(4000)`
`APPLICATION_ID`	`NOT NULL`	`NUMBER`
`APPLICATION_NAME`	`NOT NULL`	`VARCHAR2(255)`
`CREATED_BY`	N/A	`VARCHAR2(255)`
`CREATED_ON`	N/A	`TIMESTAMP(9) WITH TIME ZONE`
`TEXT`	N/A	`VARCHAR2(4000)`

APEX_TASK_HISTORY

Name	Null?	Type
`TASK_ID`	`NOT NULL`	`NUMBER`
`WORKSPACE`	`NOT NULL`	`VARCHAR2(255)`
`WORKSPACE_DISPLAY_NAME`	N/A	`VARCHAR2(4000)`
`APPLICATION_ID`	N/A	`NUMBER`
`APPLICATION_NAME`	`NOT NULL`	`VARCHAR2(255)`
`EVENT_TYPE_CODE`	N/A	`VARCHAR2(20)`
`EVENT_TYPE`	N/A	`VARCHAR2(15)`
`EVENT_CREATOR`	N/A	`VARCHAR2(255)`
`EVENT_TIMESTAMP`	N/A	`TIMESTAMP(9) WITH TIME ZONE`
`OLD_STATE_CODE`	N/A	`VARCHAR2(32)`
`OLD_STATE`	N/A	`VARCHAR2(10)`
`NEW_STATE_CODE`	N/A	`VARCHAR2(32)`
`NEW_STATE`	N/A	`VARCHAR2(10)`
`OLD_ACTUAL_OWNER`	N/A	`VARCHAR2(255)`
`NEW_ACTUAL_OWNER`	N/A	`VARCHAR2(255)`
`OLD_PRIORITY`	N/A	`NUMBER`
`NEW_PRIORITY`	N/A	`NUMBER`
`OLD_DUE_ON`	N/A	`VARCHAR2(4000)`
`NEW_DUE_ON`	N/A	`VARCHAR2(4000)`
`OUTCOME_CODE`	N/A	`VARCHAR2(32)`
`ACTION_NAME`	N/A	`VARCHAR2(255)`
`ACTION_STATUS`	N/A	`VARCHAR2(7)`
`ACTION_TIMESTAMP`	N/A	`TIMESTAMP WITH TIME ZONE`
`SUCCESS_MSG`	N/A	`VARCHAR2(4000)`
`FAILURE_MSG`	N/A	`VARCHAR2(4000)`
`OUTCOME`	N/A	`CHAR(8)`
`DISPLAY_MSG`	N/A	`VARCHAR2(4000)`

APEX_TASK_PARAMETERS

Name	Null?	Type
`TASK_ID`	`NOT NULL`	`NUMBER`
`TASK_DEF_PARAM_ID`	N/A	`NUMBER`
`WORKSPACE`	`NOT NULL`	`VARCHAR2(255)`
`WORKSPACE_DISPLAY_NAME`	N/A	`VARCHAR2(4000)`
`APPLICATION_ID`	`NOT NULL`	`NUMBER`
`APPLICATION_NAME`	`NOT NULL`	`VARCHAR2(255)`
`PARAM_LABEL`	N/A	`VARCHAR2(255)`
`PARAM_STATIC_ID`	N/A	`VARCHAR2(255)`
`IS_REQUIRED`	N/A	`VARCHAR2(1)`
`IS_VISIBLE`	N/A	`VARCHAR2(1)`
`PARAM_VALUE`	N/A	`VARCHAR2(255)`

APEX_TASK_PARTICIPANTS

Name	Null?	Type
`TASK_ID`	`NOT NULL`	`NUMBER`
`WORKSPACE`	`NOT NULL`	`VARCHAR2(255)`
`WORKSPACE_DISPLAY_NAME`	N/A	`VARCHAR2(4000)`
`APPLICATION_ID`	`NOT NULL`	`NUMBER`
`APPLICATION_NAME`	`NOT NULL`	`VARCHAR2(255)`
`PARTICIPANT`	N/A	`VARCHAR2(4000)`
`PARTICIPANT_TYPE`	N/A	`VARCHAR2(15)`
`IDENTITY_TYPE`	N/A	`VARCHAR2(32)`

Parent topic: Managing Approvals