eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CS_TASKS_BALI_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.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(+)

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.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(+)