Search Results rs_group_member




Overview
Explore in AI Chat

Overview

The view APPS.JTF_RS_GROUP_DTLS_VL is a denormalized, language-aware reporting view within the Oracle E-Business Suite Resource Manager (JTF_RS) schema. It exposes the full detail of a resource group — its descriptive name and description, its parent-child relationships, its manager assignment, and its associated role relations — as a single flattened result set. The _VL suffix indicates that the view joins translated (TL) data using USERENV('LANG'), so that GROUP_NAME and GROUP_DESC are returned in the session's current language. Because it consolidates data that is otherwise spread across base, translation, member, relation, and role tables, it is well suited to reporting, concurrent programs, and integration interfaces that need a complete picture of group membership and hierarchy without writing complex multi-table joins.

Underlying Base Objects

The view is defined over the following documented base objects, all owned by APPS:

The joins are predominantly outer joins, and soft-delete filters (DELETE_FLAG <> 'Y') are applied to the relations, members, and role-relation tables, ensuring logically deleted rows are excluded.

Key Columns

The view exposes identifiers, translated descriptions, hierarchical links, and role metadata. Significant columns include:

Common Use Cases and Queries

Typical use cases include resource group reporting, manager/role assignment audits, and hierarchy-driven integrations. A common requirement is finding the group and manager context for a given member (RS_GROUP_MEMBER):

SELECT g.GROUP_ID,
       g.GROUP_NAME,
       g.PARENT_GROUP_ID,
       g.MANAGER_PERSON_ID,
       g.ROLE_TYPE_NAME
FROM   APPS.JTF_RS_GROUP_DTLS_VL g
WHERE  g.GROUP_ID = :p_group_id;

Because the view is language-aware, no explicit language predicate is required; the current session language is applied automatically. Callers should note that restrictive filters on MANAGER_FLAG = 'Y' and the sole supported role relation type (RS_GROUP_MEMBER) mean the result set reflects manager-oriented group detail rather than every possible role assignment. For full membership lists, the underlying JTF_RS_GROUP_MEMBERS table should be queried directly.