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.JTF_TASK_UWQ_ALL_REF_V

Source

View Text - Preformatted


SELECT tasks.task_id task_id , tasks.task_number task_number , tasks.task_status_id task_status_id , tasks.task_type_id task_type_id , asg.resource_id resource_id , asg.resource_type_code resource_type , asg.assignee_role from jtf_tasks_b tasks , jtf_task_all_assignments asg WHERE tasks.task_id = asg.task_id AND NVL(tasks.deleted_flag,'N') <> 'Y' AND tasks.task_type_id <> 22 AND tasks.source_object_type_code <> 'APPOINTMENT' AND nvl(tasks.open_flag,'N') = 'Y'

View Text - HTML Formatted

SELECT TASKS.TASK_ID TASK_ID
, TASKS.TASK_NUMBER TASK_NUMBER
, TASKS.TASK_STATUS_ID TASK_STATUS_ID
, TASKS.TASK_TYPE_ID TASK_TYPE_ID
, ASG.RESOURCE_ID RESOURCE_ID
, ASG.RESOURCE_TYPE_CODE RESOURCE_TYPE
, ASG.ASSIGNEE_ROLE
FROM JTF_TASKS_B TASKS
, JTF_TASK_ALL_ASSIGNMENTS ASG
WHERE TASKS.TASK_ID = ASG.TASK_ID
AND NVL(TASKS.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS.TASK_TYPE_ID <> 22
AND TASKS.SOURCE_OBJECT_TYPE_CODE <> 'APPOINTMENT'
AND NVL(TASKS.OPEN_FLAG
, 'N') = 'Y'