View: IEU_UWQ_TASKS_V

Product:	IEU - Universal Work Queue
Description:	View used for UWQ selector SpreadTable.
Implementation/DBA Data:	APPS.IEU_UWQ_TASKS_V

View Text

SELECT A.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, A.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'SOURCE_OBJECT_ID' IEU_PARAM_PK_COL
, TO_CHAR(SOURCE_OBJECT_ID) IEU_PARAM_PK_VALUE
, RESOURCE_ID
, RESOURCE_TYPE
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, TASK_TYPE
, TASK_STATUS
, TASK_PRIORITY
, PLANNED_START_DATE
, PLANNED_END_DATE
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, SOURCE_OBJECT_TYPE
, SOURCE_OBJECT_TYPE_CODE
, SOURCE_OBJECT_ID
, OWNER_ID
, OWNER_TYPE_CODE
, OWNER
, CUSTOMER_NAME
, CUST_ACCOUNT_NUMBER
, GLOBAL_TIMEZONE_NAME
, GMT_DEVIATION_HOURS
, DURATION
, DURATION_UOM
, ESCALATION_LEVEL
, ESCALATION_OWNER
, OWNED_FLAG
, TASK_STATUS_ID
, TASK_TYPE_ID
, CLOSED_FLAG
, LU.MEANING OWN_ASSIGN_LABEL
, A.SOURCE_OBJECT_TYPE_CODE IEU_ACTION_OBJECT_CODE
, ASSIGNEE_ROLE
FROM JTF_TASK_UWQ_V A
, FND_LOOKUP_VALUES_VL LU
WHERE LU.LOOKUP_TYPE = 'IEU_NODE_LABELS'
AND LU.VIEW_APPLICATION_ID = 696
AND LU.LOOKUP_CODE = A.OWNED_FLAG

Columns