View: AZ_TASKS_V

Product:	AZ - Application Implementation
Description:	Provides easy access to assigned use and status, as well as context names for Wizard tasks.
Implementation/DBA Data:	APPS.AZ_TASKS_V

View Text

SELECT WI.ITEM_TYPE
, WI.ITEM_KEY
, WI.ROOT_ACTIVITY
, TO_NUMBER(WIAV2.TEXT_VALUE) CONTEXT_ID
, AP.CONTEXT_NAME
, WI.BEGIN_DATE
, WI.END_DATE
, SUBSTR(WIAV1.TEXT_VALUE
, 1
, 100) ASSIGNED_USER
, WIAS.PROCESS_ACTIVITY ACTIVITY_ID
, DECODE (WIAS.ACTIVITY_STATUS
, 'ACTIVE'
, 'A'
, 'C') STATUS
, DECODE(WI.END_DATE
, NULL
, ROUND(MONTHS_BETWEEN(SYSDATE
, WI.BEGIN_DATE)*31)
, ROUND(MONTHS_BETWEEN(WI.END_DATE
, WI.BEGIN_DATE)*31) ) DURATION
FROM WF_ITEM_ACTIVITY_STATUSES WIAS
, WF_ITEM_ATTRIBUTE_VALUES WIAV1
, WF_ITEM_ATTRIBUTE_VALUES WIAV2
, WF_ITEMS WI
, WF_PROCESS_ACTIVITIES WPA
, AZ_PROCESSES AP
WHERE WI.ITEM_TYPE LIKE 'AZW%'
AND WIAV1.ITEM_KEY = WI.ITEM_KEY
AND WIAV1.ITEM_TYPE = WI.ITEM_TYPE
AND WIAV1.NAME = 'AZW_IA_ROLE'
AND WIAV2.ITEM_KEY = WI.ITEM_KEY
AND WIAV2.ITEM_TYPE = WI.ITEM_TYPE
AND WIAV2.NAME = 'AZW_IA_CTXT_ID'
AND AP.ITEM_TYPE = WI.ITEM_TYPE
AND AP.PROCESS_NAME = WI.ROOT_ACTIVITY
AND AP.CONTEXT_ID = TO_NUMBER(WIAV2.TEXT_VALUE)
AND WIAS.ITEM_TYPE = WIAV1.ITEM_TYPE
AND WIAS.ITEM_KEY= WIAV1.ITEM_KEY
AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
AND WI.ROOT_ACTIVITY = WPA.ACTIVITY_NAME
AND WPA.PROCESS_ITEM_TYPE = WI.ITEM_TYPE
AND WPA.PROCESS_NAME = 'ROOT'

Columns