Results for “as_rpt_admins_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AS_RPT_ADMINS_V view is a reporting object owned by the APPS schema within the AS (Sales Foundation) product family. According to the ETRM metadata, it presents the sales reporting hierarchy information for administrative users. In practice, this view resolves the relationship between sales resources (employees and salesforce members), the sales groups they belong to, and the roles assigned to those members within the reporting hierarchy. Its principal purpose is to expose, in a denormalized and query-friendly form, which members of a sales group carry an administrative or managerial designation, and how those members are positioned relative to their parent groups.

Because the view joins role definitions, group membership, and denormalized group hierarchy data, it is primarily consumed by reporting and integration processes that need to render an accurate picture of the sales administration structure. This is especially relevant for downstream applications such as territory and quota reporting, sales team dashboards, and any custom report requiring the identification of managers and administrators within the sales hierarchy.

Underlying Base Objects

The view text documented in the ETRM metadata identifies five base objects, each referenced through APPS synonyms and ultimately resolving to the JTF (Foundation) schema tables:

• JTF_RS_RESOURCE_EXTNS — provides the salesforce resource information (the RES alias in the view text), including the resource identifier and category.
• JTF_RS_GROUP_MEMBERS — links a resource to a sales group through the group member identifier.
• JTF_RS_GROUPS_DENORM — supplies the denormalized group hierarchy, including parent group, immediate parent flag, and the group's active date range.
• JTF_RS_ROLES_B — holds the role definitions, including ROLE_CODE, ROLE_TYPE_CODE, and the MEMBER_FLAG, ADMIN_FLAG, and MANAGER_FLAG indicator columns.
• JTF_RS_ROLE_RELATIONS — associates a role with a resource or group member, constrained here to the role resource type of RS_GROUP_MEMBER.

The join path runs from the denormalized group to group members, from group members to resources, from the group member identifier to the role relation, and finally from the role relation to the role definition. The view additionally restricts role types to SALES, TELESALES, FIELDSALES, and PRM, and filters to records where either MEMBER_FLAG or MANAGER_FLAG equals 'Y'.

Key Columns

• EMPLOYEE_PERSON_ID / SALESFORCE_ID — the resource identifier exposed from the resource extensions, representing the salesperson or employee.
• SALES_GROUP_ID / PARENT_SALES_GROUP_ID — the group to which the resource belongs and its parent group in the hierarchy.
• IMMEDIATE_PARENT_FLAG — indicates whether the relationship to the parent group is the immediate one.
• GRP_START_DATE_ACTIVE / GRP_END_DATE_ACTIVE — the active date range of the group assignment.
• ROLE_ID / ROLE_NAME / ROLE_TYPE_CODE — the role assigned to the member and its classification within the sales role types.
• MEMBER_FLAG — the column most commonly searched; when 'Y', the associated role designates the resource as a member of the sales role.
• ADMIN_FLAG — when 'Y', designates administrative status for the role assignment.
• MANAGER_FLAG — when 'Y', designates managerial status for the role assignment.
• SF_START_DATE_ACTIVE / SF_END_DATE_ACTIVE — the active date range of the salesforce role relationship.

Common Use Cases and Queries

The view is typically queried to enumerate administrators and managers within a sales reporting hierarchy, or to identify all members of a given sales group. A representative query filtering on the searched column follows:

• Find administrative members of a sales group:

SELECT salesforce_id,
       sales_group_id,
       parent_sales_group_id,
       role_name,
       member_flag,
       admin_flag,
       manager_flag
FROM   apps.as_rpt_admins_v
WHERE  member_flag = 'Y'
AND    admin_flag  = 'Y'
AND    TRUNC(SYSDATE) BETWEEN grp_start_date_active
                          AND NVL(grp_end_date_active, SYSDATE);

• List managers within a specific sales group:

SELECT salesforce_id, role_code, manager_flag
FROM   apps.as_rpt_admins_v
WHERE  sales_group_id = :p_group_id
AND    manager_flag   = 'Y';

Because the view already filters for member or manager designations and restricts role types, consumers can build reporting extracts, territory alignment checks, and integration payloads without re-deriving the underlying JTF_RS relationships. Note that the view exposes duplicate-named date columns (GRP and SF ranges) from different base objects, so column references should be qualified carefully when embedded in larger reporting queries.