Search Results jtf_task_assignments_v




Overview
Explore in AI Chat

Overview

JTF_TASK_ASSIGNMENTS_V is a database view owned by the APPS schema in Oracle E-Business Suite, belonging to the JTF (CRM Foundation) product family. Its documented purpose is narrow and precise: it returns all task assignment records in which the ASSIGNEE_ROLE value is equal to the literal 'ASSIGNEE'. This makes it a filtered projection over the broader assignment data model rather than an unfiltered replica. In Oracle EBS 12.1.1 and 12.2.2, the view is frequently reached indirectly by Oracle Field Service, Oracle TeleService, and Oracle Sales applications, as well as by CRM scheduling and resource-assignment logic that needs to distinguish the primary assignee from other assignment participants such as owners, resources, or notification recipients.

Because the view is registered with status VALID, it is safe for custom reporting, concurrent program queries, Oracle Discoverer workbooks, and inbound/outbound interface extraction. Users searching for the term "assignee_role" typically encounter this object because ASSIGNEE_ROLE is the discriminator column embedded in its WHERE clause, and it is also exposed as a selectable column in the view's projection.

Underlying Base Objects

According to the documented metadata, the view is defined over JTF_TASK_ALL_ASSIGNMENTS, which resolves through a SYNONYM at runtime. JTF_TASK_ALL_ASSIGNMENTS is the all-encompassing assignment table for the JTF task model; it stores every assignment row regardless of role. The predicate NVL(ASSIGNEE_ROLE, 'ASSIGNEE') = 'ASSIGNEE' has an important consequence: rows where ASSIGNEE_ROLE is NULL are treated as primary assignees and are therefore included in the view. Only rows explicitly tagged with a non-null, non-'ASSIGNEE' role are excluded. Any referential joins required to resolve resource names, statuses, or task headers must be performed by the caller against the relevant base/reference entities, since the view itself is a straightforward column-level projection.

Key Columns

Common Use Cases and Queries

Typical uses include building assignee worklists, driving resource-scheduling reports, and extracting task assignments into a data warehouse. A simple listing of assignments for a given task:

SELECT TASK_ASSIGNMENT_ID, TASK_ID, RESOURCE_TYPE_CODE, RESOURCE_ID, ASSIGNMENT_STATUS_ID
  FROM APPS.JTF_TASK_ASSIGNMENTS_V
 WHERE TASK_ID = :p_task_id
   AND NVL(SECURITY_GROUP_ID, -1) = :p_security_group_id;

Incremental extraction by audit columns is common for interfaces:

SELECT TASK_ASSIGNMENT_ID, TASK_ID, ASSIGNEE_ROLE, LAST_UPDATE_DATE
  FROM APPS.JTF_TASK_ASSIGNMENTS_V
 WHERE LAST_UPDATE_DATE >= :p_since
 ORDER BY LAST_UPDATE_DATE;

A join to obtain task headers for a calendar report:

SELECT a.TASK_ID, t.NAME, a.RESOURCE_ID, a.BOOKING_START_DATE, a.BOOKING_END_DATE
  FROM APPS.JTF_TASK_ASSIGNMENTS_V a,
       APPS.JTF_TASKS_VL t
 WHERE a.TASK_ID = t.TASK_ID
   AND a.SHOW_ON_CALENDAR = 'Y'
   AND a.BOOKING_START_DATE BETWEEN :p_from AND :p_to;