Results for “jtf_rs_role_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.JTF_RS_ROLE_RELATIONS_VL is a reporting and integration view in the Oracle E-Business Suite Resource Manager (JTF_RS) schema. It presents the relationship between a role definition and the resource or group to which that role is assigned, joined to the role's descriptive attributes and to the lookup that classifies the role type. Because the view resolves the role type code to its lookup meaning and filters out logically deleted rows, it provides a clean, denormalized projection suitable for concurrent programs, OAF/Forms LOVs, Oracle Reports, XML Publisher data templates, and inbound/outbound interface extracts.
The "_VL" suffix conventionally denotes a view that has been validated for translation-enabled columns via a corresponding "_TL" table pattern; here the joined role view JTF_RS_ROLES_VL supplies the translated role name while the role relations themselves remain language-independent. The view is owned by APPS and is therefore expected to be queried with the standard MO: Operating Unit and MO: Security Profile initialization, since row visibility in the Resource Manager model is often driven by FND_GLOBAL context.
Underlying Base Objects
The view is defined over three joined sources plus one documented package dependency:
- JTF_RS_ROLE_RELATIONS (accessed via synonym) — the driving table holding one row per role-to-resource assignment, including the polymorphic role_resource_type/role_resource_id pair, the validity dates, and the delete_flag.
- JTF_RS_ROLES_VL (view) — supplies role_name, role_code, role_type_code, and the role behavior flags (member_flag, admin_flag, lead_flag, manager_flag) for the joined role_id.
- FND_LOOKUPS (view) — resolves role_type_code against lookup_type = 'JTF_RS_ROLE_TYPE' to return the descriptive meaning of the role type.
- FND_GLOBAL (package) — documented as a referenced base object, confirming that the view participates in the standard EBS runtime context (user_id, responsibility_id, org_id) used by Resource Manager security and defaulting logic.
The join conditions are rrt.role_id = rol.role_id for the role attributes and rol.role_type_code = fnd.lookup_code with fnd.lookup_type = 'JTF_RS_ROLE_TYPE' for the classification meaning. The predicate NVL(rrt.delete_flag,'N') <> 'Y' excludes soft-deleted relations, so consumers should not need to add their own delete_flag filter.
Key Columns
- ROLE_RELATE_ID — primary identifier of the role-relation row; join key back to JTF_RS_ROLE_RELATIONS.
- ROLE_RESOURCE_TYPE / ROLE_RESOURCE_ID — the polymorphic target of the assignment (for example a resource or a group), identifying who or what holds the role.
- ROLE_ID — foreign key to the role definition.
- START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating for the relation; filter these to determine whether an assignment is currently active.
- ROLE_NAME, ROLE_CODE — translated name and developer key of the role.
- MEMBER_FLAG, ADMIN_FLAG, LEAD_FLAG, MANAGER_FLAG — Y/N indicators describing the nature of the role's authority within the group hierarchy.
- ROLE_TYPE_CODE / MEANING — the lookup code and its translated meaning from FND_LOOKUPS for lookup_type 'JTF_RS_ROLE_TYPE'.
Common Use Cases and Queries
Typical uses include listing all roles held by a resource, reporting role membership by role type, and feeding role-assignment extracts.
- Roles for a specific resource:
SELECT role_name, meaning, start_date_active, end_date_active FROM apps.jtf_rs_role_relations_vl WHERE role_resource_type = :p_type AND role_resource_id = :p_id AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1); - Headcount by role type:
SELECT meaning, COUNT(*) FROM apps.jtf_rs_role_relations_vl GROUP BY meaning ORDER BY 2 DESC; - Manager-flagged assignments:
SELECT role_name, role_resource_id FROM apps.jtf_rs_role_relations_vl WHERE manager_flag = 'Y';
Because the lookup join is an inner join on role_type_code, roles whose type code is not present in FND_LOOKUPS for 'JTF_RS_ROLE_TYPE' will be omitted from this view; validate lookup completeness before relying on it for reconciliation. The search term "jtf_rs_role_type" corresponds to this lookup_type, which is the classification backbone of the view.
-
This is used to define all the roles which can be assigned to a resource.
-
This is used to define all the roles which can be assigned to a resource.
-
This view shows the listing of details of roles attached to resource.
APPS.JTF_RS_ROLE_RELATIONS_VL·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_ROLES_VL·Explore JTF module →
-
This view shows the listing of details of roles attached to resource.
APPS.JTF_RS_ROLE_RELATIONS_VL·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_ROLES_VL·Explore JTF module →
-
View: JTF_RS_DEFRESROLES_VL 12.2.2
This view is used by Define Resource Form roles,gmbr_roles,tmbr_roles block
APPS.JTF_RS_DEFRESROLES_VL·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_ROLES_VL·Explore JTF module →
-
View: JTF_RS_ROLE_DETAILS_VL 12.1.1
This View shows Roles and its details like Role type, Role name, etc.
APPS.JTF_RS_ROLE_DETAILS_VL·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_ROLES_VL·Explore JTF module →
-
View: JTF_RS_ROLE_DETAILS_VL 12.2.2
This View shows Roles and its details like Role type, Role name, etc.
APPS.JTF_RS_ROLE_DETAILS_VL·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_ROLES_VL·Explore JTF module →
-
View: JTF_RS_DEFRESROLES_VL 12.1.1
This view is used by Define Resource Form roles,gmbr_roles,tmbr_roles block
APPS.JTF_RS_DEFRESROLES_VL·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_ROLES_VL·Explore JTF module →
-
View: JTF_RS_GROUP_DTLS_VL 12.2.2
This view has the groups details including name and manager
APPS.JTF_RS_GROUP_DTLS_VL·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_GROUPS_B·Explore JTF module →
-
View: JTF_RS_GROUP_DTLS_VL 12.1.1
This view has the groups details including name and manager
APPS.JTF_RS_GROUP_DTLS_VL·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_GROUPS_B·Explore JTF module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
Base Table JTF_RS_ROLES_B stores general information about a given Role.
-
Base Table JTF_RS_ROLES_B stores general information about a given Role.
-
TABLE: JTF.JTF_RS_ROLES_B 12.2.2
-
TABLE: JTF.JTF_RS_ROLES_B 12.1.1
-
VIEW: APPS.JTF_RS_ROLES_VL 12.1.1
-
VIEW: APPS.JTF_RS_ROLES_VL 12.2.2