VIEW: APPS.AST_TASKS_V

Source

View Text - Preformatted

SELECT TASK.ROW_ID , TASK.TASK_ID, TASK.TASK_NUMBER, TASK.TASK_NAME, TASK.DESCRIPTION, TASK.TASK_TYPE_ID , TYPE.NAME, TASK.TASK_STATUS_ID , STATUS.NAME, nvl(status.closed_flag,'N'), nvl(status.cancelled_flag,'N'), nvl(status.completed_flag,'N'), nvl(status.rejected_flag,'N'), TASK.TASK_PRIORITY_ID, priority.name, TASK.OWNER_ID, TASK.OWNER_TYPE_CODE, OBJECT2.NAME, jtf_task_utl.get_owner(TASK.owner_type_code, TASK.owner_id), TASK.SOURCE_OBJECT_ID, TASK.SOURCE_OBJECT_NAME, TASK.SOURCE_OBJECT_TYPE_CODE, OBJECT.NAME, TASK.REASON_CODE, TASK.PRIVATE_FLAG, TASK.PUBLISH_FLAG, TASK.NOTIFICATION_FLAG, TASK.CUSTOMER_ID , TASK.ATTRIBUTE_CATEGORY, TASK.ATTRIBUTE1, TASK.ATTRIBUTE2, TASK.ATTRIBUTE3, TASK.ATTRIBUTE4 , TASK.ATTRIBUTE5 , TASK.ATTRIBUTE6 , TASK.ATTRIBUTE7 , TASK.ATTRIBUTE8 , TASK.ATTRIBUTE9 , TASK.ATTRIBUTE10 , TASK.ATTRIBUTE11 , TASK.ATTRIBUTE12 , TASK.ATTRIBUTE13 , TASK.ATTRIBUTE14 , TASK.ATTRIBUTE15, TASK.CREATED_BY , TASK.CREATION_DATE , TASK.LAST_UPDATED_BY , TASK.LAST_UPDATE_DATE , TASK.LAST_UPDATE_LOGIN , TASK.ASSIGNED_BY_ID , FND.USER_NAME, TASK.CUST_ACCOUNT_ID , TASK.ADDRESS_ID , TASK.PLANNED_START_DATE , TASK.NOTIFICATION_PERIOD , TASK.NOTIFICATION_PERIOD_UOM , null , null , TASK.RECURRENCE_RULE_ID, TASK.ALARM_START , TASK.ALARM_START_UOM, TASK.DELETED_FLAG, TASK.ACTUAL_START_DATE, TASK.ACTUAL_END_DATE, TASK.DURATION, TASK.DURATION_UOM, TASK.PLANNED_EFFORT, TASK.PLANNED_EFFORT_UOM, TASK.ACTUAL_EFFORT, TASK.ACTUAL_EFFORT_UOM, TASK.PERCENTAGE_COMPLETE, TASK.PLANNED_END_DATE, TASK.SCHEDULED_START_DATE, TASK.SCHEDULED_END_DATE, TASK.OBJECT_VERSION_NUMBER, TASK.OWNER_TERRITORY_ID FROM JTF_TASKS_VL task, JTF_TASK_TYPES_TL type, JTF_TASK_STATUSES_VL status, JTF_TASK_PRIORITIES_TL priority, JTF_OBJECTS_VL OBJECT, JTF_OBJECTS_VL OBJECT2, FND_USER FND WHERE task.task_type_id = type.task_type_id AND (task.deleted_flag != 'Y' OR task.deleted_flag is null) AND task.task_status_id = status.task_status_id AND task.task_priority_id = priority.task_priority_id(+) AND task.source_object_type_code = OBJECT.OBJECT_CODE AND task.owner_type_code = OBJECT2.object_code AND task.assigned_by_id = FND.USER_ID(+) AND type.task_type_id <> 22 AND priority.language(+) = userenv('LANG') AND type.language(+) = userenv('LANG')

View Text - HTML Formatted

SELECT TASK.ROW_ID
, TASK.TASK_ID
, TASK.TASK_NUMBER
, TASK.TASK_NAME
, TASK.DESCRIPTION
, TASK.TASK_TYPE_ID
, TYPE.NAME
, TASK.TASK_STATUS_ID
, STATUS.NAME
, NVL(STATUS.CLOSED_FLAG
, 'N')
, NVL(STATUS.CANCELLED_FLAG
, 'N')
, NVL(STATUS.COMPLETED_FLAG
, 'N')
, NVL(STATUS.REJECTED_FLAG
, 'N')
, TASK.TASK_PRIORITY_ID
, PRIORITY.NAME
, TASK.OWNER_ID
, TASK.OWNER_TYPE_CODE
, OBJECT2.NAME
, JTF_TASK_UTL.GET_OWNER(TASK.OWNER_TYPE_CODE
, TASK.OWNER_ID)
, TASK.SOURCE_OBJECT_ID
, TASK.SOURCE_OBJECT_NAME
, TASK.SOURCE_OBJECT_TYPE_CODE
, OBJECT.NAME
, TASK.REASON_CODE
, TASK.PRIVATE_FLAG
, TASK.PUBLISH_FLAG
, TASK.NOTIFICATION_FLAG
, TASK.CUSTOMER_ID
, TASK.ATTRIBUTE_CATEGORY
, TASK.ATTRIBUTE1
, TASK.ATTRIBUTE2
, TASK.ATTRIBUTE3
, TASK.ATTRIBUTE4
, TASK.ATTRIBUTE5
, TASK.ATTRIBUTE6
, TASK.ATTRIBUTE7
, TASK.ATTRIBUTE8
, TASK.ATTRIBUTE9
, TASK.ATTRIBUTE10
, TASK.ATTRIBUTE11
, TASK.ATTRIBUTE12
, TASK.ATTRIBUTE13
, TASK.ATTRIBUTE14
, TASK.ATTRIBUTE15
, TASK.CREATED_BY
, TASK.CREATION_DATE
, TASK.LAST_UPDATED_BY
, TASK.LAST_UPDATE_DATE
, TASK.LAST_UPDATE_LOGIN
, TASK.ASSIGNED_BY_ID
, FND.USER_NAME
, TASK.CUST_ACCOUNT_ID
, TASK.ADDRESS_ID
, TASK.PLANNED_START_DATE
, TASK.NOTIFICATION_PERIOD
, TASK.NOTIFICATION_PERIOD_UOM
, NULL
, NULL
, TASK.RECURRENCE_RULE_ID
, TASK.ALARM_START
, TASK.ALARM_START_UOM
, TASK.DELETED_FLAG
, TASK.ACTUAL_START_DATE
, TASK.ACTUAL_END_DATE
, TASK.DURATION
, TASK.DURATION_UOM
, TASK.PLANNED_EFFORT
, TASK.PLANNED_EFFORT_UOM
, TASK.ACTUAL_EFFORT
, TASK.ACTUAL_EFFORT_UOM
, TASK.PERCENTAGE_COMPLETE
, TASK.PLANNED_END_DATE
, TASK.SCHEDULED_START_DATE
, TASK.SCHEDULED_END_DATE
, TASK.OBJECT_VERSION_NUMBER
, TASK.OWNER_TERRITORY_ID
FROM JTF_TASKS_VL TASK
, JTF_TASK_TYPES_TL TYPE
, JTF_TASK_STATUSES_VL STATUS
, JTF_TASK_PRIORITIES_TL PRIORITY
, JTF_OBJECTS_VL OBJECT
, JTF_OBJECTS_VL OBJECT2
, FND_USER FND
WHERE TASK.TASK_TYPE_ID = TYPE.TASK_TYPE_ID
AND (TASK.DELETED_FLAG != 'Y' OR TASK.DELETED_FLAG IS NULL)
AND TASK.TASK_STATUS_ID = STATUS.TASK_STATUS_ID
AND TASK.TASK_PRIORITY_ID = PRIORITY.TASK_PRIORITY_ID(+)
AND TASK.SOURCE_OBJECT_TYPE_CODE = OBJECT.OBJECT_CODE
AND TASK.OWNER_TYPE_CODE = OBJECT2.OBJECT_CODE
AND TASK.ASSIGNED_BY_ID = FND.USER_ID(+)
AND TYPE.TASK_TYPE_ID <> 22
AND PRIORITY.LANGUAGE(+) = USERENV('LANG')
AND TYPE.LANGUAGE(+) = USERENV('LANG')