VIEW: APPS.AMS_TASKS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'