Results for “jtf_task_resources_vl”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JTF_TASK_RESOURCES_VL is an APPS-owned database view in the Oracle E-Business Suite CRM Foundation (JTF) product. In Oracle EBS 12.1.1 and 12.2.2 it presents a unified, denormalized listing of every resource that can be assigned to a task, an interaction, or a CRM activity. Rather than querying each resource subtype separately, application code and reports can select from a single row source that already resolves the underlying category into a resource type code. This view belongs to the "VL" (view with translatable columns) family of CRM Foundation objects, meaning the resource, group, and team names it exposes are sourced from translation-enabled underlying views. It is a read-only construct and is marked VALID in the data dictionary.
Underlying Base Objects
The view is defined as a UNION ALL of three documented base objects:
- JTF_RS_RESOURCE_EXTNS_VL — the primary source, supplying individual resources with resource number, name, email, phone, party ID, organization, and active dates. A DECODE maps the CATEGORY column (EMPLOYEE, PARTNER, SUPPLIER_CONTACT, PARTY, OTHER, TBH) into the RESOURCE_TYPE values RS_EMPLOYEE, RS_PARTNER, RS_SUPPLIER_CONTACT, RS_PARTY, RS_OTHER, and RS_TBH.
- JTF_RS_GROUPS_VL — contributes group records, hard-coded as RESOURCE_TYPE 'RS_GROUP'.
- JTF_RS_TEAMS_VL — contributes team records, hard-coded as RESOURCE_TYPE 'RS_TEAM'.
Because a UNION ALL is used with no de-duplication, the same logical party could appear once as an individual resource and again through a group or team membership; consumers must filter by RESOURCE_TYPE when uniqueness matters.
Key Columns
- RESOURCE_ID — source identifier (RESOURCE_ID, GROUP_ID, or TEAM_ID depending on branch).
- RESOURCE_NUMBER — the system-generated resource, group, or team number.
- RESOURCE_TYPE — the discriminator that classifies each row; the value 'RS_OTHER' is produced when the underlying CATEGORY is 'OTHER', which is exactly the term "rs_other" found in the DECODE list.
- RESOURCE_NAME — display name from the translation-enabled base view.
- EMAIL / PHONE — contact attributes; PHONE is NULL for groups and teams.
- START_DATE_ACTIVE / END_DATE_ACTIVE — effective-dating window for the resource.
- PERSON_PARTY_ID — HZ party link for individuals; NULL for groups and teams.
- ORG_ID / ORG_NAME — for employees, mapped from the business group columns; otherwise mapped from source organization columns.
Common Use Cases and Queries
The view is typically used for CRM task assignment lookups, resource availability reporting, and integration extracts that must enumerate all assignable resources. A frequent query isolates a specific resource type, for example the generic, non-categorized resources represented by RS_OTHER:
SELECT resource_id, resource_number, resource_name, email, start_date_active, end_date_active FROM apps.jtf_task_resources_vl WHERE resource_type = 'RS_OTHER' AND (end_date_active IS NULL OR end_date_active > SYSDATE);
Other common patterns include joining to JTF_TASKS to list resources assigned to an activity, restricting by ORG_ID for security or reporting by operating unit, or filtering on the date columns to return only currently active resources, groups, and teams. When a report must distinguish staff from teams, add RESOURCE_TYPE predicates or a GROUP BY on that column. Because the view references translation-enabled base views, results reflect the session language, making it suitable for multilingual CRM reporting without additional joins.
-
View: JTF_TASK_RESOURCES_VL 12.2.2
APPS.JTF_TASK_RESOURCES_VL·↳ JTF_RS_GROUPS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_TEAMS_VL·Explore JTF module →
-
View: JTF_TASK_RESOURCES_VL 12.1.1
APPS.JTF_TASK_RESOURCES_VL·↳ JTF_RS_GROUPS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_TEAMS_VL·Explore JTF module →
-
View: JTF_CAL_RES_ASSIGN_V 12.1.1
View for table JTF_CAL_RESOURCE_ASSIGN , and view JTF_RS_ALL_RESOURCES_VL
APPS.JTF_CAL_RES_ASSIGN_V·↳ JTF_CAL_RESOURCE_ASSIGN·↳ JTF_TASK_RESOURCES_VL·Explore JTF module →
-
View: JTF_CAL_RES_ASSIGN_V 12.2.2
View for table JTF_CAL_RESOURCE_ASSIGN , and view JTF_RS_ALL_RESOURCES_VL
APPS.JTF_CAL_RES_ASSIGN_V·↳ JTF_CAL_RESOURCE_ASSIGN·↳ JTF_TASK_RESOURCES_VL·Explore JTF module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
VIEW: APPS.JTF_RS_TEAMS_VL 12.1.1