DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AZ_TASKS_V

Object Details
Object Name: AZ_TASKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAZ.AZ_TASKS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


AZ_TASKS_V is a view containing all the tasks, or items in Workflow terminology, belong to AZ. Each row includes item key, item type, process name, activity instance id, begin date, end date, assigned user, status, and duration. It is built upon WF_ITEMS, WF_ITEM_ATTRIBUTE_STATUSES, WF_ITEM_ATTRIBUTE_VALUES, and WF_PROCESS_ACTIVITIES.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_TYPE VARCHAR2 (8) Yes Workflow item type
ITEM_KEY VARCHAR2 (240) Yes Workflow item key
ROOT_ACTIVITY VARCHAR2 (30) Yes Root activity for this task
CONTEXT_ID NUMBER

Context ID for this task
CONTEXT_NAME VARCHAR2 (80)
Context name for this task
BEGIN_DATE DATE
Yes The date this task is started
END_DATE DATE

The date this task is completed
ASSIGNED_USER VARCHAR2 (100)
The user working on this task
ACTIVITY_ID NUMBER
Yes Activity ID for this task
STATUS VARCHAR2 (1)
Implementation status for this task
DURATION NUMBER

The period between BEGIN_DATE and END_DATE
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM_TYPE
,      ITEM_KEY
,      ROOT_ACTIVITY
,      CONTEXT_ID
,      CONTEXT_NAME
,      BEGIN_DATE
,      END_DATE
,      ASSIGNED_USER
,      ACTIVITY_ID
,      STATUS
,      DURATION
FROM APPS.AZ_TASKS_V;

Dependencies

[top of page]

APPS.AZ_TASKS_V references the following:

SchemaAPPS
SynonymAZ_PROCESSES
SynonymWF_ITEMS
SynonymWF_ITEM_ACTIVITY_STATUSES
SynonymWF_ITEM_ATTRIBUTE_VALUES
SynonymWF_PROCESS_ACTIVITIES
APPS.AZ_TASKS_V is referenced by following:

SchemaAPPS
Package BodyAZW_ARCHIVE - show dependent code
Package BodyAZW_PROC - show dependent code
Package BodyAZW_REPORT - show dependent code