View: AMS_TASKS_V

Product:	AMS - Marketing
Description:	This view returns the task and task assignment details.
Implementation/DBA Data:	APPS.AMS_TASKS_V

View Text

SELECT A.TASK_ID
, A.OBJECT_VERSION_NUMBER
, A.TASK_NAME
, A.TASK_TYPE_ID
, A.TASK_PRIORITY_ID
, A.TASK_STATUS_ID
, A.ACTUAL_START_DATE
, A.ACTUAL_END_DATE
, A.PLANNED_START_DATE
, A.PLANNED_END_DATE
, A.OWNER_ID
, A.OWNER_TYPE_CODE
, A.SOURCE_OBJECT_ID
, A.SOURCE_OBJECT_NAME
, A.SOURCE_OBJECT_TYPE_CODE
, B.TASK_ASSIGNMENT_ID
, B.OBJECT_VERSION_NUMBER
, B.RESOURCE_ID
, B.RESOURCE_TYPE_CODE
, B.ASSIGNMENT_STATUS_ID
, A.OWNER
, C.FULL_NAME
, A.PRIVATE_FLAG
, D.MEANING
, A.CREATION_DATE
, C.EMAIL
, A.TASK_STATUS
, A.TASK_TYPE
, A.TASK_PRIORITY
FROM JTF_TASKS_V A
, JTF_TASK_ASSIGNMENTS B
, AMS_JTF_RS_EMP_V C
, AMS_LOOKUPS D
, JTF_TASK_TYPES_B E
WHERE A.TASK_ID = B.TASK_ID
AND B.RESOURCE_ID = C.RESOURCE_ID
AND DECODE(A.SOURCE_OBJECT_TYPE_CODE
, 'AMS_CAMP'
, 'CAMP'
, 'AMS_EVEO'
, 'EVEO'
, 'AMS_EVEH'
, 'EVEH'
, 'AMS_DELV'
, 'DELV') = D.LOOKUP_CODE(+)
AND D.LOOKUP_TYPE(+) = 'AMS_SYS_ARC_QUALIFIER'
AND A.DELETED_FLAG != 'Y'
AND A.OWNER_TYPE_CODE = 'RS_EMPLOYEE'
AND A.TASK_TYPE_ID = E.TASK_TYPE_ID
AND E.RULE = 'ORACLE_MARKETING'

Columns