View: WF_ITEM_ACTIVITY_STATUSES_V

Product:	FND - Application Object Library
Description:	Public view for accessing Workflow runtime status
Implementation/DBA Data:	APPS.WF_ITEM_ACTIVITY_STATUSES_V

View Text

SELECT /* $HEADER: VIEW_FND_R12.LDT 120.6 2012/06/21 17:12:42 JVALENTI SHIP $ */ IAS.ROWID
, 'R'
, IAS.ITEM_TYPE
, IT.DISPLAY_NAME
, IT.DESCRIPTION
, IAS.ITEM_KEY
, I.USER_KEY
, I.BEGIN_DATE
, I.END_DATE
, IAS.PROCESS_ACTIVITY
, PA.INSTANCE_LABEL
, A.NAME
, A.DISPLAY_NAME
, A.DESCRIPTION
, A.TYPE
, L_AT.MEANING
, IAS.EXECUTION_TIME
, IAS.BEGIN_DATE
, IAS.END_DATE
, IAS.ACTIVITY_STATUS
, L_AS.MEANING
, IAS.ACTIVITY_RESULT_CODE
, WF_CORE.ACTIVITY_RESULT(A.RESULT_TYPE
, IAS.ACTIVITY_RESULT_CODE)
, IAS.ASSIGNED_USER
, WF_DIRECTORY.GETROLEDISPLAYNAME(IAS.ASSIGNED_USER)
, IAS.NOTIFICATION_ID
, IAS.OUTBOUND_QUEUE_ID
, IAS.ERROR_NAME
, IAS.ERROR_MESSAGE
, IAS.ERROR_STACK
FROM WF_LOOKUPS L_AT
, WF_LOOKUPS L_AS
, WF_ACTIVITIES_VL A
, WF_PROCESS_ACTIVITIES PA
, WF_ITEM_TYPES_VL IT
, WF_ITEMS I
, WF_ITEM_ACTIVITY_STATUSES IAS
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
AND IAS.ITEM_KEY = I.ITEM_KEY
AND I.BEGIN_DATE BETWEEN A.BEGIN_DATE
AND NVL(A.END_DATE
, I.BEGIN_DATE)
AND I.ITEM_TYPE = IT.NAME
AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
AND PA.ACTIVITY_NAME = A.NAME
AND PA.ACTIVITY_ITEM_TYPE = A.ITEM_TYPE
AND L_AT.LOOKUP_TYPE = 'WFENG_ACTIVITY_TYPE'
AND L_AT.LOOKUP_CODE = A.TYPE
AND L_AS.LOOKUP_TYPE = 'WFENG_STATUS'
AND L_AS.LOOKUP_CODE = IAS.ACTIVITY_STATUS UNION ALL SELECT IAS.ROWID
, 'H'
, IAS.ITEM_TYPE
, IT.DISPLAY_NAME
, IT.DESCRIPTION
, IAS.ITEM_KEY
, I.USER_KEY
, I.BEGIN_DATE
, I.END_DATE
, IAS.PROCESS_ACTIVITY
, PA.INSTANCE_LABEL
, A.NAME
, A.DISPLAY_NAME
, A.DESCRIPTION
, A.TYPE
, L_AT.MEANING
, IAS.EXECUTION_TIME
, IAS.BEGIN_DATE
, IAS.END_DATE
, IAS.ACTIVITY_STATUS
, L_AS.MEANING
, IAS.ACTIVITY_RESULT_CODE
, WF_CORE.ACTIVITY_RESULT(A.RESULT_TYPE
, IAS.ACTIVITY_RESULT_CODE)
, IAS.ASSIGNED_USER
, WF_DIRECTORY.GETROLEDISPLAYNAME(IAS.ASSIGNED_USER)
, IAS.NOTIFICATION_ID
, IAS.OUTBOUND_QUEUE_ID
, IAS.ERROR_NAME
, IAS.ERROR_MESSAGE
, IAS.ERROR_STACK
FROM WF_LOOKUPS L_AT
, WF_LOOKUPS L_AS
, WF_ACTIVITIES_VL A
, WF_PROCESS_ACTIVITIES PA
, WF_ITEM_TYPES_VL IT
, WF_ITEMS I
, WF_ITEM_ACTIVITY_STATUSES_H IAS
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
AND IAS.ITEM_KEY = I.ITEM_KEY
AND I.BEGIN_DATE BETWEEN A.BEGIN_DATE
AND NVL(A.END_DATE
, I.BEGIN_DATE)
AND I.ITEM_TYPE = IT.NAME
AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
AND PA.ACTIVITY_NAME = A.NAME
AND PA.ACTIVITY_ITEM_TYPE = A.ITEM_TYPE
AND L_AT.LOOKUP_TYPE = 'WFENG_ACTIVITY_TYPE'
AND L_AT.LOOKUP_CODE = A.TYPE
AND L_AS.LOOKUP_TYPE = 'WFENG_STATUS'
AND L_AS.LOOKUP_CODE = IAS.ACTIVITY_STATUS

Columns