Product: | IEU - Universal Work Queue |
---|---|
Description: | View used for UWQ selector SpreadTable. |
Implementation/DBA Data: | APPS.IEU_UWQ_TASKS_MYOWN_V |
SELECT B.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, B.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
, A.OWNER_ID RESOURCE_ID
, A.OWNER_TYPE_CODE RESOURCE_TYPE
, A.TASK_ID
, TASK_NUMBER
, TASKS_TL.TASK_NAME
, TYP.NAME TASK_TYPE
, STS_TL.NAME TASK_STATUS
, PRI.NAME TASK_PRIORITY
, PLANNED_START_DATE
, PLANNED_END_DATE
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, TL.NAME SOURCE_OBJECT_TYPE
, SOURCE_OBJECT_TYPE_CODE
, SOURCE_OBJECT_ID
, PARTIES.PARTY_ID CUSTOMER_ID
, PARTIES.PARTY_NAME CUSTOMER_NAME
, GLOBAL_TIMEZONE_NAME
, TZ.GMT_DEVIATION_HOURS
, DURATION
, DURATION_UOM
, ESCALATION_LEVEL
, A.TASK_STATUS_ID
, A.TASK_TYPE_ID
, JTF_TASK_UWQ_PVT.GET_PRIMARY_PHONE( A.TASK_ID) PRIMARY_PHONE
, HCP.EMAIL_ADDRESS PRIMARY_EMAIL
, A.CREATION_DATE
, A.LAST_UPDATE_DATE
, A.SOURCE_OBJECT_TYPE_CODE IEU_ACTION_OBJECT_CODE
, TASKS_TL.DESCRIPTION
, A.SOURCE_OBJECT_NAME SOURCE_DOCUMENT_NAME
, A.OBJECT_VERSION_NUMBER
FROM JTF_TASKS_B A
, JTF_TASK_STATUSES_TL STS_TL
, JTF_TASKS_TL TASKS_TL
, JTF_OBJECTS_B B
, JTF_OBJECTS_TL TL
, JTF_TASK_PRIORITIES_TL PRI
, HZ_TIMEZONES TZ
, JTF_TASK_TYPES_TL TYP
, JTF_TASK_CONTACTS JTC
, HZ_CONTACT_POINTS HCP
, HZ_PARTIES PARTIES
WHERE A.SOURCE_OBJECT_TYPE_CODE = B.OBJECT_CODE
AND A.TASK_TYPE_ID = TYP.TASK_TYPE_ID
AND CUSTOMER_ID = PARTIES.PARTY_ID(+)
AND TYP.LANGUAGE=USERENV('LANG')
AND A.TASK_ID = TASKS_TL.TASK_ID
AND TASKS_TL.LANGUAGE = USERENV('LANG')
AND (A.OWNER_TYPE_CODE IS NULL OR A.OWNER_TYPE_CODE NOT IN ('RS_GROUP'
, 'RS_TEAM'))
AND TZ.TIMEZONE_ID(+) = A.TIMEZONE_ID
AND B.OBJECT_CODE = TL.OBJECT_CODE
AND TL.LANGUAGE = USERENV('LANG')
AND A.TASK_PRIORITY_ID = PRI.TASK_PRIORITY_ID (+)
AND PRI.LANGUAGE(+) = USERENV('LANG')
AND A.OPEN_FLAG = 'Y'
AND A.TASK_STATUS_ID = STS_TL.TASK_STATUS_ID
AND STS_TL.LANGUAGE = USERENV('LANG')
AND NVL(A.DELETED_FLAG
, 'N') <> 'Y'
AND A.ENTITY = 'TASK'
AND JTC.TASK_ID(+) = A.TASK_ID
AND JTC.PRIMARY_FLAG(+) = 'Y'
AND HCP.OWNER_TABLE_ID(+) = JTC.CONTACT_ID
AND HCP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HCP.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND HCP.PRIMARY_FLAG(+) = 'Y'