Results for “ast_sales_group_admins_v”

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

Overview

AST_SALES_GROUP_ADMINS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the AST (TeleSales) product family. It presents a denormalized, read-only projection that joins sales group administrator assignments to the underlying person records and their parent salesforce. The view exists primarily to simplify the retrieval of telemarketing administrator information for reporting, concurrent programs, and integration interfaces that need to resolve which persons administer which sales groups, together with contact details and the operational status of the associated salesforce.

The view is marked VALID in the ETRM metadata and is available in both Oracle EBS 12.1.1 and 12.2.2. Because it is a view rather than a base table, it carries no independent storage and reflects the current state of its underlying tables at query time. Its principal value lies in encapsulating the three-way join between the administration table, the person view, and the salesforce table so that callers do not need to reconstruct that logic.

Underlying Base Objects

The view is constructed from three primary sources, all referenced through synonyms in the APPS schema:

• AS_SALES_GRP_ADMIN (aliased SALES) — the base administration table holding the sales group to person assignments, including descriptive flexfield attributes and the standard WHO audit columns.
• PER_PEOPLE_X (aliased PEOPLE) — a person-level view supplying the human-readable identity and contact fields.
• AS_SALESFORCE (aliased FORCE) — the salesforce definition table, supplying the status code for the owning salesforce.

Joins are performed on SALES.PERSON_ID = PEOPLE.PERSON_ID and SALES.SALESFORCE_ID = FORCE.SALESFORCE_ID. The ETRM metadata additionally lists the HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages as dependencies; these are invoked internally by the PER_PEOPLE_X view to derive the person name and to apply row-level security based on the reporting user's HR security profile. Consequently, results returned from this view are typically filtered by the security context of the session.

Key Columns

• ROW_ID — the ROWID of the AS_SALES_GRP_ADMIN row, providing a stable identifier for update or reference purposes.
• SALES_GROUP_ID — identifies the sales group the administrator is associated with.
• PERSON_ID — the unique identifier of the administrator in the person model.
• SALESFORCE_ID — the salesforce to which the assignment belongs.
• FIRST_NAME, LAST_NAME, FULL_NAME — the administrator's name components as resolved through the HR name packages.
• EMAIL_ADDRESS, WORK_TELEPHONE — contact attributes for the administrator.
• STATUS_CODE — the status of the associated salesforce, useful for filtering active versus inactive assignments.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield segments carried from the base administration table.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The view is commonly used to list administrators with contact information, to reconcile sales group ownership, and to drive notification or assignment logic in TeleSales customizations. A simple listing of active administrators demonstrates typical usage:

• SELECT full_name, email_address, work_telephone, sales_group_id FROM apps.ast_sales_group_admins_v WHERE status_code = 'A';
• SELECT salesforce_id, COUNT(*) FROM apps.ast_sales_group_admins_v GROUP BY salesforce_id;
• SELECT * FROM apps.ast_sales_group_admins_v WHERE person_id = :p_person_id;

Because the underlying PER_PEOPLE_X view invokes HR security, query results are constrained by the caller's security profile; integrations running under a privileged or seeded APPS responsibility generally see the complete set, while end-user sessions see a restricted subset.