VIEW: APPS.CSF_SR_TASKS_V

Source

View Text - Preformatted

SELECT t.task_id , t.task_number , t.task_type_id , t.task_status_id , t.task_priority_id , t.owner_id , t.owner_type_code , t.assigned_by_id , t.cust_account_id , t.customer_id , t.address_id , t.parent_task_id , t.source_object_type_code , t.timezone_id , t.source_object_id , t.source_object_name , jta.resource_id , jta.resource_type_code FROM jtf_tasks_b t , jtf_tasks_tl tl , jtf_task_assignments jta, jtf_task_priorities_tl tp , jtf_task_types_b tt , jtf_task_types_tl ttl , jtf_task_statuses_b ts , jtf_task_statuses_tl tsl WHERE tl.task_id = t.task_id AND jta.Task_assignment_id = t.task_id AND tsl.language = userenv('lang') AND tsl.task_status_id = t.task_status_id AND ts.usage = 'TASK' AND ts.task_status_id = t.task_status_id AND ttl.language = userenv('lang') AND ttl.task_type_id = t.task_type_id AND tt.task_type_id = t.task_type_id AND tp.language(+) = userenv('lang') AND tp.task_priority_id(+) = t.task_priority_id AND tl.language = userenv('lang') AND NVL(t.deleted_flag, 'N') <> 'Y' AND t.source_object_type_code = 'SR' AND (t.planned_start_date + 0 = t.planned_start_date OR t.planned_start_date IS NULL) AND (NVL(t.task_split_flag,'N') <> 'D' OR NVL(ts.cancelled_flag,'N') <> 'Y')

View Text - HTML Formatted

SELECT T.TASK_ID
, T.TASK_NUMBER
, T.TASK_TYPE_ID
, T.TASK_STATUS_ID
, T.TASK_PRIORITY_ID
, T.OWNER_ID
, T.OWNER_TYPE_CODE
, T.ASSIGNED_BY_ID
, T.CUST_ACCOUNT_ID
, T.CUSTOMER_ID
, T.ADDRESS_ID
, T.PARENT_TASK_ID
, T.SOURCE_OBJECT_TYPE_CODE
, T.TIMEZONE_ID
, T.SOURCE_OBJECT_ID
, T.SOURCE_OBJECT_NAME
, JTA.RESOURCE_ID
, JTA.RESOURCE_TYPE_CODE
FROM JTF_TASKS_B T
, JTF_TASKS_TL TL
, JTF_TASK_ASSIGNMENTS JTA
, JTF_TASK_PRIORITIES_TL TP
, JTF_TASK_TYPES_B TT
, JTF_TASK_TYPES_TL TTL
, JTF_TASK_STATUSES_B TS
, JTF_TASK_STATUSES_TL TSL
WHERE TL.TASK_ID = T.TASK_ID
AND JTA.TASK_ASSIGNMENT_ID = T.TASK_ID
AND TSL.LANGUAGE = USERENV('LANG')
AND TSL.TASK_STATUS_ID = T.TASK_STATUS_ID
AND TS.USAGE = 'TASK'
AND TS.TASK_STATUS_ID = T.TASK_STATUS_ID
AND TTL.LANGUAGE = USERENV('LANG')
AND TTL.TASK_TYPE_ID = T.TASK_TYPE_ID
AND TT.TASK_TYPE_ID = T.TASK_TYPE_ID
AND TP.LANGUAGE(+) = USERENV('LANG')
AND TP.TASK_PRIORITY_ID(+) = T.TASK_PRIORITY_ID
AND TL.LANGUAGE = USERENV('LANG')
AND NVL(T.DELETED_FLAG
, 'N') <> 'Y'
AND T.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND (T.PLANNED_START_DATE + 0 = T.PLANNED_START_DATE OR T.PLANNED_START_DATE IS NULL)
AND (NVL(T.TASK_SPLIT_FLAG
, 'N') <> 'D' OR NVL(TS.CANCELLED_FLAG
, 'N') <> 'Y')