VIEW: APPS.AZ_TASKS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'