VIEW: APPS.JTF_AM_TASK_DTLS_V

Source

View Text - Preformatted

SELECT a.rowid row_id , a.resource_type_code , a.resource_id , a.task_id , a.task_assignment_id , t.scheduled_start_date , t.scheduled_end_date , t.timezone_id, a.sched_travel_duration , t.source_object_type_code , t.source_object_id , t.source_object_name , t.task_number , t.task_type_id , t.task_status_id , a.assignment_status_id , t.task_priority_id , t.task_name, a.created_by , a.creation_date , a.last_updated_by , a.last_update_date , a.last_update_login , decode(t.escalation_level, 'DE', 'N', 'NE', 'N', decode(t.task_type_id||r.reference_code||NVL(s.closed_flag,'N')||NVL(s.completed_flag,'N')|| NVL(s.cancelled_flag,'N')||NVL(s.rejected_flag,'N')||NVL(t.deleted_flag,'N'), '22ESCNNNNN','Y', 'N') ) escalation_flag FROM jtf_tasks_vl t ,jtf_task_assignments a , jtf_tasks_b t1 , jtf_task_statuses_b s , jtf_task_references_b r WHERE t.task_id = a.task_id and nvl(t.deleted_flag, 'N') <> 'Y' and t.scheduled_end_date >= t.scheduled_start_date and ( nvl(a.actual_start_date,a.actual_end_date) is not null or ( exists ( select null from jtf_task_statuses_b s where s.task_status_id = t.task_status_id and sysdate between nvl(s.start_date_active,sysdate) and nvl(s.end_date_active,sysdate) and nvl(s.cancelled_flag,'N') <> 'Y' ) and exists ( select null from jtf_task_statuses_b s where s.task_status_id = a.assignment_status_id and sysdate between nvl(s.start_date_active,sysdate) and nvl(s.end_date_active,sysdate) and nvl(s.cancelled_flag,'N') <> 'Y' ) ) ) and r.object_id (+)= a.task_id and r.reference_code (+)= 'ESC' and r.object_type_code (+)= 'TASK' and t1.task_id (+)= r.task_id and s.task_status_id (+)= t.task_status_id

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.RESOURCE_TYPE_CODE
, A.RESOURCE_ID
, A.TASK_ID
, A.TASK_ASSIGNMENT_ID
, T.SCHEDULED_START_DATE
, T.SCHEDULED_END_DATE
, T.TIMEZONE_ID
, A.SCHED_TRAVEL_DURATION
, T.SOURCE_OBJECT_TYPE_CODE
, T.SOURCE_OBJECT_ID
, T.SOURCE_OBJECT_NAME
, T.TASK_NUMBER
, T.TASK_TYPE_ID
, T.TASK_STATUS_ID
, A.ASSIGNMENT_STATUS_ID
, T.TASK_PRIORITY_ID
, T.TASK_NAME
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, DECODE(T.ESCALATION_LEVEL
, 'DE'
, 'N'
, 'NE'
, 'N'
, DECODE(T.TASK_TYPE_ID||R.REFERENCE_CODE||NVL(S.CLOSED_FLAG
, 'N')||NVL(S.COMPLETED_FLAG
, 'N')|| NVL(S.CANCELLED_FLAG
, 'N')||NVL(S.REJECTED_FLAG
, 'N')||NVL(T.DELETED_FLAG
, 'N')
, '22ESCNNNNN'
, 'Y'
, 'N') ) ESCALATION_FLAG
FROM JTF_TASKS_VL T
, JTF_TASK_ASSIGNMENTS A
, JTF_TASKS_B T1
, JTF_TASK_STATUSES_B S
, JTF_TASK_REFERENCES_B R
WHERE T.TASK_ID = A.TASK_ID
AND NVL(T.DELETED_FLAG
, 'N') <> 'Y'
AND T.SCHEDULED_END_DATE >= T.SCHEDULED_START_DATE
AND ( NVL(A.ACTUAL_START_DATE
, A.ACTUAL_END_DATE) IS NOT NULL OR ( EXISTS ( SELECT NULL
FROM JTF_TASK_STATUSES_B S
WHERE S.TASK_STATUS_ID = T.TASK_STATUS_ID
AND SYSDATE BETWEEN NVL(S.START_DATE_ACTIVE
, SYSDATE)
AND NVL(S.END_DATE_ACTIVE
, SYSDATE)
AND NVL(S.CANCELLED_FLAG
, 'N') <> 'Y' )
AND EXISTS ( SELECT NULL
FROM JTF_TASK_STATUSES_B S
WHERE S.TASK_STATUS_ID = A.ASSIGNMENT_STATUS_ID
AND SYSDATE BETWEEN NVL(S.START_DATE_ACTIVE
, SYSDATE)
AND NVL(S.END_DATE_ACTIVE
, SYSDATE)
AND NVL(S.CANCELLED_FLAG
, 'N') <> 'Y' ) ) )
AND R.OBJECT_ID (+)= A.TASK_ID
AND R.REFERENCE_CODE (+)= 'ESC'
AND R.OBJECT_TYPE_CODE (+)= 'TASK'
AND T1.TASK_ID (+)= R.TASK_ID
AND S.TASK_STATUS_ID (+)= T.TASK_STATUS_ID