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 onGRP.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 onGRP.MANAGER_PERSON_ID = PER.PERSON_ID (+), restricted by the effective-dating predicateTRUNC(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 fromGRP.NAME.START_DATE_ACTIVE/END_DATE_ACTIVE— the date range during which the group is active._LA:ENABLED— a lookup-encoded flag derived fromGRP.ENABLED_FLAGagainst theAS_LOOKUPS:FLAGlookup, rendering theMEANINGvalue (for example, a user-facing enabled/disabled label)._DF— a descriptive-flexfield reference resolving toAS:AS_SALES_GROUPS:GRP.MANAGER_FIRST_NAME/MANAGER_LAST_NAME— the manager's name from the effectivePER_ALL_PEOPLE_Frecord.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.
-
View: ASFV_SALES_GROUPS 12.1.1
Not implemented in this database·Explore AS module →
-
View: ASFV_SALES_GROUPS 12.2.2
Not implemented in this database·Explore AS module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2