Results for “as_price_list_groups”

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

Overview

AS_PRICE_LIST_GROUPS is a Sales Foundation (AS) table owned by the OSM schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores price list groups — logical groupings used to organize and categorize price lists maintained within the Sales Foundation pricing infrastructure. Rather than treating every price list as an isolated entity, EBS allows administrators to bucket related price lists under a common group, which simplifies maintenance, reporting, and security assignment across pricing operations.

Under the heuristic Data Vault classification provided in the ETRM metadata, this table is described as hub-leaning. This classification derives from the fact that AS_PRICE_LIST_GROUPS carries a surrogate primary key (GROUP_ID) with no dependent child attributes that would qualify it as a satellite, and it sits on the referenced (parent) side of the key relationship with AS_PRICE_LISTS. In Data Vault modeling terms, it would therefore be a candidate for treatment as a hub entity, with its descriptive attributes optionally split into an associated satellite.

Key Information Stored

The table contains ten documented columns. The most significant are:

• GROUP_ID — the surrogate primary key, defined by the constraint AS_PRICE_LIST_GROUPS_PK and mirrored by the unique index AS_PRICE_LIST_GROUPS_U1. It is the business-key candidate and the column referenced by dependent tables.
• GROUP_NAME — the user-facing descriptive label for the group.
• DESCRIPTION — free-form text clarifying the purpose or scope of the group.
• ENABLED_FLAG — a status indicator controlling whether the group is active and available for assignment.
• SECURITY_GROUP_ID — a foreign key to FND_SECURITY_GROUPS, controlling row-level access for multi-org or multi-tenant security models.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit WHO columns tracking who created and last modified each record, and when.

Because AS_PRICE_LIST_GROUPS itself acts as a hub, its non-key attributes (GROUP_NAME, DESCRIPTION, ENABLED_FLAG) are the descriptive payload an analyst would expect to find duplicated in a satellite table in a Data Vault implementation.

Common Use Cases and Queries

The table is commonly queried to enumerate active groups prior to price list maintenance, to join price lists to their grouping for reporting, or to audit security-scoped price list visibility.

• List enabled groups with their security assignment:

  SELECT g.group_id, g.group_name, g.description
  FROM   as_price_list_groups g
  WHERE  g.enabled_flag = 'Y'
  ORDER BY g.group_name;

• Report price lists grouped by price list group:

  SELECT g.group_name, p.price_list_name
  FROM   as_price_list_groups g
  JOIN   as_price_lists p ON p.group_id = g.group_id
  ORDER BY g.group_name, p.price_list_name;

• Audit recently changed groups:

  SELECT group_id, group_name, last_updated_by, last_update_date
  FROM   as_price_list_groups
  WHERE  last_update_date > SYSDATE - 30;

Related Objects

AS_PRICE_LIST_GROUPS participates in a small, well-defined set of relationships:

• AS_PRICE_LISTS — the principal dependent table. AS_PRICE_LISTS.GROUP_ID is a foreign key pointing to AS_PRICE_LIST_GROUPS, making every price list optionally associated with a group. This is the most common join path.
• FND_SECURITY_GROUPS — referenced through this table's own SECURITY_GROUP_ID column, providing the security grouping context that governs access to group records.
• The primary key constraint AS_PRICE_LIST_GROUPS_PK and unique index AS_PRICE_LIST_GROUPS_U1, both keyed on GROUP_ID, define the integrity contract for dependent objects.

Because the FK graph is narrow, integration or extension work generally touches AS_PRICE_LISTS and FND_SECURITY_GROUPS rather than a wide web of related tables.