Results for “asfv_sales_groups”

4 results




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

Overview

ASFV_SALES_GROUPS is a read-only reporting view in the Oracle E-Business Suite AS – Sales Foundation module. It presents sales group definitions from the AS_SALES_GROUPS table together with the name of the manager responsible for each group, resolved from Oracle HR (PER_ALL_PEOPLE_F), and with the name of any parent sales group to which the group is subordinate. The view is intended for reporting, inquiry, and downstream integration rather than for transactional maintenance; the underlying table retains the authoritative data.

The view is defined WITH READ ONLY, so it cannot be used as a DML target. The ETRM metadata notes that the view is Not implemented in this database, indicating that it is a documented seed/metadata object whose presence in a given environment depends on product installation and patching. The user's search term manager_salesforce_id corresponds directly to the exposed column MANAGER_SALESFORCE_ID, which is passed through from the base table and is relevant to environments integrating sales group ownership with external CRM or Salesforce-based hierarchy data.

Underlying Base Objects

The documented base objects are:

  • AS_SALES_GROUPS GRP — the primary source of sales group attributes such as name, active dates, accounting code, parent group, manager person, and manager Salesforce identifier.
  • AS_SALES_GROUPS PARENT_GRP — a self-join on the same table, outer-joined on GRP.PARENT_SALES_GROUP_ID = PARENT_GRP.SALES_GROUP_ID (+), used to resolve the parent group's name. A group with no parent yields a null parent name.
  • PER_ALL_PEOPLE_F PER — an outer join on GRP.MANAGER_PERSON_ID = PER.PERSON_ID (+), restricted by the effective-dating predicate TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+) AND NVL(PER.EFFECTIVE_END_DATE (+), TRUNC(SYSDATE)). This retrieves the manager's current effective person record, so the manager's first and last names reflect the row effective as of the query date.

The document lists no other referenced base objects; the same table appears twice in the FROM clause, which accounts for the multiple base-table references in a single view definition.

Key Columns

  • SALES_GROUP_NAME — the display name of the sales group, sourced from GRP.NAME.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — the date range during which the group is active.
  • _LA:ENABLED — a lookup-encoded flag derived from GRP.ENABLED_FLAG against the AS_LOOKUPS:FLAG lookup, rendering the MEANING value (for example, a user-facing enabled/disabled label).
  • _DF — a descriptive-flexfield reference resolving to AS:AS_SALES_GROUPS:GRP.
  • MANAGER_FIRST_NAME / MANAGER_LAST_NAME — the manager's name from the effective PER_ALL_PEOPLE_F record.
  • PARENT_SALES_GROUP_NAME — the name of the parent group, if any.
  • SALES_GROUP_ID / PARENT_SALES_GROUP_ID — primary key and self-referencing foreign key.
  • MANAGER_PERSON_ID — foreign key to the manager's person record.
  • MANAGER_SALESFORCE_ID — the Salesforce identifier associated with the manager, supporting integration between EBS sales groups and Salesforce.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard "WHO" audit columns.

Common Use Cases and Queries

Typical uses include listing sales groups with their managers, validating parent-child hierarchies, and extracting groups with associated Salesforce manager identifiers for CRM synchronization.

List all active groups with manager and parent names:

  • SELECT sales_group_name, manager_first_name, manager_last_name, parent_sales_group_name FROM asfv_sales_groups WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE));

Retrieve groups by manager Salesforce identifier:

  • SELECT sales_group_id, sales_group_name, manager_salesforce_id FROM asfv_sales_groups WHERE manager_salesforce_id = :p_salesforce_id;

Extract the hierarchy for integration:

  • SELECT sales_group_id, sales_group_name, parent_sales_group_id, parent_sales_group_name, manager_person_id FROM asfv_sales_groups ORDER BY parent_sales_group_id NULLS FIRST, sales_group_name;

Because the view is read-only and performs outer joins, queries should account for null manager or parent values, and any adjustments to sales group data must be made against AS_SALES_GROUPS through the application.