VIEW: APPS.WF_ITEM_ACTIVITY_STATUSES_V

Source

View Text - Preformatted

SELECT /* $Header: afwf.odf 120.31.12020000.3 2013/03/25 20:35:25 vshanmug 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

View Text - HTML Formatted

SELECT /* $HEADER: AFWF.ODF 120.31.12020000.3 2013/03/25 20:35:25 VSHANMUG 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