Results for “as_sales_groups”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AS_SALES_GROUPS is a foundational reference table in the Oracle E-Business Suite AS - Sales Foundation product family, owned by the OSM schema. It defines sales groups, which represent organizational groupings used to categorize sales forces, territories, and quota-planning structures. Sales groups serve as an intermediate hierarchy between individual salespersons and higher-level sales organizations, and they are referenced throughout Sales Foundation and downstream modules such as Incentive Compensation to attribute revenue, assign managers, and drive compensation calculations.
The table is classified as VALID in the ETRM documentation for releases 12.1.1 and 12.2.2. The table carries a physical schema with 31 documented columns, a surrogate primary key constraint named AS_SALES_GROUPS_PK on SALES_GROUP_ID, and a business-key unique index AS_SALES_GROUPS_U1 also defined on SALES_GROUP_ID. From a Data Vault modeling perspective, the mined foreign-key structure suggests this object is hub-leaning: it holds a stable, slowly-changing business key (SALES_GROUP_ID) that other transactional or descriptive tables reference, making it a natural candidate hub in a dimensional or Data Vault warehouse design.
Key Information Stored
Each row in AS_SALES_GROUPS represents one sales group. The most significant columns include:
- SALES_GROUP_ID — the surrogate primary key (AS_SALES_GROUPS_PK), also the unique business-key candidate (AS_SALES_GROUPS_U1). This is the value referenced and searched under the term "as_sales_groups_pk".
- NAME — the user-facing sales group name.
- DESCRIPTION — free-text description of the group's purpose.
- START_DATE_ACTIVE and END_DATE_ACTIVE — effective-dating columns that define the active lifespan of the group.
- ENABLED_FLAG — indicates whether the sales group is currently enabled for use.
- PARENT_SALES_GROUP_ID — self-referencing parent link that supports a hierarchical sales group structure.
- MANAGER_PERSON_ID and MANAGER_SALESFORCE_ID — identify the responsible manager and associated sales-force record.
- ACCOUNTING_CODE — accounting classification used for financial posting and reporting.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the DFF (descriptive flexfield) columns used for client-specific extensions.
The distinction between the surrogate PK and business-key candidate matters: both AS_SALES_GROUPS_PK and AS_SALES_GROUPS_U1 are defined on SALES_GROUP_ID, indicating the identifier is both system-generated and unique at the business level.
Common Use Cases and Queries
Typical reporting and integration scenarios include listing active sales groups, reconstructing the parent-child hierarchy, and joining sales groups to sales-force assignments for commission analysis.
- Lookup by primary key:
SELECT * FROM OSM.AS_SALES_GROUPS WHERE SALES_GROUP_ID = :p_id; - List enabled groups:
SELECT SALES_GROUP_ID, NAME FROM OSM.AS_SALES_GROUPS WHERE ENABLED_FLAG = 'Y' ORDER BY NAME; - Hierarchy traversal using the self-reference: join a child group to its parent via
PARENT_SALES_GROUP_ID = parent.SALES_GROUP_ID. - Attribute sales forces to groups:
SELECT sf.SALESFORCE_ID, sg.NAME FROM OSM.AS_SALESFORCE sf JOIN OSM.AS_SALES_GROUPS sg ON sf.SALES_GROUP_ID = sg.SALES_GROUP_ID; - Effective-dated reporting: filter using START_DATE_ACTIVE and END_DATE_ACTIVE relative to the reporting period.
Related Objects
The documented foreign-key relationship identifies AS_SALESFORCE as the primary referencing object: AS_SALESFORCE.SALES_GROUP_ID points to AS_SALES_GROUPS.SALES_GROUP_ID, meaning each sales-force record is assigned to exactly one sales group. Additional related objects implied by the sales-group manager and hierarchy model include AS_SALES_GROUP_MEMBERS (member assignment), AS_SALES_GROUP_QUOTAS (quota allocation), and personnel references such as PER_PEOPLE_F via MANAGER_PERSON_ID. DFF validation and lookup objects, along with standard EBS audit views, may also depend on this table. Together these establish AS_SALES_GROUPS as the hub reference for sales-force organization and incentive-compensation processing.
-
Defines sales groups
-
Defines sales groups
-
TABLE: OSM.AS_SALES_GROUPS 12.2.2
-
TABLE: OSM.AS_SALES_GROUPS 12.1.1
-
View: BIS_SALES_GROUPS_V 12.1.1
Not implemented in this database·Explore BIS module →
-
View: ASFV_SALES_GROUPS 12.2.2
Not implemented in this database·Explore AS module →
-
Not implemented in this database·Explore AS module →
-
Not implemented in this database·Explore AS module →
-
VIEW: OSM.AS_SALES_GROUPS# 12.2.2
-
View: ASFV_SALES_GROUPS 12.1.1
Not implemented in this database·Explore AS module →
-
View: BIS_SALES_GROUPS_V 12.2.2
Not implemented in this database·Explore BIS module →
-
Not implemented in this database·Explore AS module →
-
Not implemented in this database·Explore AS module →
-
View: ASBV_SALES_GROUPS 12.1.1
Not implemented in this database·Explore AS module →
-
VIEW: OSM.AS_SALES_GROUPS# 12.2.2
-
View: ASFV_SALES_CREDITS 12.2.2
Not implemented in this database·Explore AS module →
-
View: ASBV_SALES_GROUPS 12.2.2
Not implemented in this database·Explore AS module →
-
View: ASFV_SALES_FORCE 12.2.2
Not implemented in this database·Explore AS module →
-
View: ASFV_SALES_FORCE 12.1.1
Not implemented in this database·Explore AS module →
-
View: AS_DIST_SC_MEMBERS_V 12.1.1
Distinct view of sales credit members
Not implemented in this database·Explore AS module →
-
View: ASFV_SALES_CREDITS 12.1.1
Not implemented in this database·Explore AS module →
-
View: AS_DIST_SC_MEMBERS_V 12.2.2
Distinct view of sales credit members
Not implemented in this database·Explore AS module →
-
Denormalized table derived from AS_SALES_GROUPS
-
Denormalized table derived from AS_SALES_GROUPS
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
View: AS_QUOTAS_FORECASTS_V 12.1.1
Sales quotas for forecast view
Not implemented in this database·Explore AS module →
-
View: AS_PTR_SALESREPS_V 12.1.1
Salesperson Definition View for Partner type salesreps
Not implemented in this database·Explore AS module →
-
View: AS_QUOTAS_FORECASTS_V 12.2.2
Sales quotas for forecast view
Not implemented in this database·Explore AS module →
-
View: AS_EMP_SALESREPS_V 12.1.1
Salesperson Definition View for Employee type salesreps
Not implemented in this database·Explore AS module →
-
View: AS_VIEW_FORECAST_V 12.2.2
Forecast detail view
Not implemented in this database·Explore AS module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
View: AS_PTR_SALESREPS_V 12.2.2
Salesperson Definition View for Partner type salesreps
Not implemented in this database·Explore AS module →
-
12.2.2 FND Design Data 12.2.2
-
Obsolete Defines the salesforce