VIEW: APPS.OKL_CS_TASKS_MAIN_UV

Source

View Text - Preformatted

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.TIMEZONE_ID TIMEZONE_ID , TIME.NAME TIMEZONE , 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 , PARTY.PARTY_NAME PRIMARY_CONTACT , PHONE.PHONE_COUNTRY_CODE|| ' '||PHONE.PHONE_AREA_CODE || ' ' ||PHONE.PHONE_NUMBER ||' '||PHONE.PHONE_EXTENSION PRIMARY_PHONE , 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 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_CONTACTS_V JTFCON,HZ_PARTIES PARTY,JTF_TASK_PHONES_V JTFPHON,HZ_CONTACT_POINTS PHONE,HZ_TIMEZONES_TL TIME WHERE task.task_type_id = type.task_type_id AND (task.deleted_flag != 'Y' OR task.deleted_flag is null) AND task.task_id = jtfcon.task_id(+) AND jtfcon.contact_id = party.party_id (+) AND jtfcon.primary_flag (+) = 'Y' AND task.task_id = jtfphon.task_contact_id(+) AND jtfphon.phone_id = phone.contact_point_id (+) AND jtfphon.primary_flag (+) = 'Y' AND jtfphon.owner_table_name (+) = 'JTF_TASKS_B' 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 time.timezone_id(+) = task.timezone_id AND time.language(+) = userenv('LANG') AND priority.language(+) = userenv('LANG') AND type.language(+) = userenv('LANG')

View Text - HTML Formatted

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.TIMEZONE_ID TIMEZONE_ID
, TIME.NAME TIMEZONE
, 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
, PARTY.PARTY_NAME PRIMARY_CONTACT
, PHONE.PHONE_COUNTRY_CODE|| ' '||PHONE.PHONE_AREA_CODE || ' ' ||PHONE.PHONE_NUMBER ||' '||PHONE.PHONE_EXTENSION PRIMARY_PHONE
, 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
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_CONTACTS_V JTFCON
, HZ_PARTIES PARTY
, JTF_TASK_PHONES_V JTFPHON
, HZ_CONTACT_POINTS PHONE
, HZ_TIMEZONES_TL TIME
WHERE TASK.TASK_TYPE_ID = TYPE.TASK_TYPE_ID
AND (TASK.DELETED_FLAG != 'Y' OR TASK.DELETED_FLAG IS NULL)
AND TASK.TASK_ID = JTFCON.TASK_ID(+)
AND JTFCON.CONTACT_ID = PARTY.PARTY_ID (+)
AND JTFCON.PRIMARY_FLAG (+) = 'Y'
AND TASK.TASK_ID = JTFPHON.TASK_CONTACT_ID(+)
AND JTFPHON.PHONE_ID = PHONE.CONTACT_POINT_ID (+)
AND JTFPHON.PRIMARY_FLAG (+) = 'Y'
AND JTFPHON.OWNER_TABLE_NAME (+) = 'JTF_TASKS_B'
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 TIME.TIMEZONE_ID(+) = TASK.TIMEZONE_ID
AND TIME.LANGUAGE(+) = USERENV('LANG')
AND PRIORITY.LANGUAGE(+) = USERENV('LANG')
AND TYPE.LANGUAGE(+) = USERENV('LANG')