Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_CS_TASKS_BALI_UV |
SELECT TASK.ROW_ID ROW_ID
, TASK.TASK_ID TASK_ID
, TASK.TASK_NUMBER TASK_NUMBER
, TASK.TASK_NAME TASK_NAME
, TASK.DESCRIPTION DESCRIPTION
, TASK.TASK_TYPE_ID TASK_TYPE_ID
, TYPE.NAME TASK_TYPE
, TASK.TASK_STATUS_ID TASK_STATUS_ID
, STATUS.NAME TASK_STATUS
, NVL(STATUS.CLOSED_FLAG
, 'N') CLOSED
, NVL(STATUS.CANCELLED_FLAG
, 'N') CANCELLED
, NVL(STATUS.COMPLETED_FLAG
, 'N') COMPLETED
, NVL(STATUS.REJECTED_FLAG
, 'N') REJECTED
, TASK.TASK_PRIORITY_ID TASK_PRIORITY_ID
, PRIORITY.NAME TASK_PRIORITY
, TASK.OWNER_ID OWNER_ID
, TASK.OWNER_TYPE_CODE OWNER_TYPE_CODE
, OBJECT2.NAME OWNER_TYPE
, JTF_TASK_UTL.GET_OWNER(TASK.OWNER_TYPE_CODE
, TASK.OWNER_ID) OWNER
, TASK.SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, TASK.SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME
, TASK.SOURCE_OBJECT_TYPE_CODE SOURCE_OBJECT_TYPE_CODE
, OBJECT.NAME SOURCE_OBJECT_TYPE
, TASK.REASON_CODE REASON_CODE
, TASK.PRIVATE_FLAG PRIVATE_FLAG
, TASK.PUBLISH_FLAG PUBLISH_FLAG
, TASK.NOTIFICATION_FLAG NOTIFICATION_FLAG
, TASK.CUSTOMER_ID CUSTOMER_ID
, TASK.CREATED_BY CREATED_BY
, TASK.CREATION_DATE CREATION_DATE
, TASK.LAST_UPDATED_BY LAST_UPDATED_BY
, TASK.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TASK.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TASK.ASSIGNED_BY_ID ASSIGNED_BY_ID
, FND.USER_NAME ASSIGNED_BY_NAME
, TASK.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, TASK.ADDRESS_ID ADDRESS_ID
, TASK.PLANNED_START_DATE PLANNED_START_DATE
, TASK.NOTIFICATION_PERIOD NOTIFICATION_PERIOD
, TASK.NOTIFICATION_PERIOD_UOM NOTIFICATION_PERIOD_UOM
, NULL PARENT_TASK_ID
, NULL PARENT_TASK_NUMBER
, TASK.RECURRENCE_RULE_ID RECURRENCE_RULE_ID
, TASK.ALARM_START ALARM_START
, TASK.ALARM_START_UOM ALARM_START_UOM
, TASK.DELETED_FLAG DELETED_FLAG
, TASK.ACTUAL_START_DATE ACTUAL_START_DATE
, TASK.ACTUAL_END_DATE ACTUAL_END_DATE
, TASK.DURATION DURATION
, TASK.DURATION_UOM DURATION_UOM
, TASK.PLANNED_EFFORT PLANNED_EFFORT
, TASK.PLANNED_EFFORT_UOM PLANNED_EFFORT_UOM
, TASK.ACTUAL_EFFORT ACTUAL_EFFORT
, TASK.ACTUAL_EFFORT_UOM ACTUAL_EFFORT_UOM
, TASK.PERCENTAGE_COMPLETE PERCENTAGE_COMPLETE
, TASK.PLANNED_END_DATE PLANNED_END_DATE
, TASK.SCHEDULED_START_DATE SCHEDULED_START_DATE
, TASK.SCHEDULED_END_DATE SCHEDULED_END_DATE
, TASK.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TASK.OWNER_TERRITORY_ID OWNER_TERRITORY_ID
, ASSG.RESOURCE_TYPE_CODE ASSIGNEE_TYPE_CODE
, (SELECT NAME
FROM JTF_OBJECTS_VL
WHERE OBJECT_CODE = ASSG.RESOURCE_TYPE_CODE) ASSIGNEE_TYPE
, ASSG.RESOURCE_ID ASSIGNEE_ID
, JTF_TASK_UTL.GET_OWNER(ASSG.RESOURCE_TYPE_CODE
, ASSG.RESOURCE_ID) ASSIGN_TO
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
, JTF_TASK_ASSIGNMENTS ASSG
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')
AND TASK.TASK_ID = ASSG.TASK_ID(+)