Results for “as_price_lists”

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

Overview

The AS_PRICE_LISTS table is a Sales Foundation (AS) data object owned by the OSM schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the association between price lists and the price list groups to which they belong, effectively acting as an intersection or assignment table within the pricing infrastructure. The AS_PRICE_LISTS table links the underlying price list definition held in Oracle Advanced Pricing to a logical grouping maintained in the Sales Foundation module, allowing multiple price lists to be organized under a common group identifier for administrative, security, and reporting purposes.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure identifies AS_PRICE_LISTS as a link table. This is appropriate: the table resolves a many-to-many (or grouped) relationship between two independent business entities—the price list header (QP_LIST_HEADERS_B) and the price list group (AS_PRICE_LIST_GROUPS). The composite primary key of two foreign keys confirms this link role rather than a hub or satellite designation.

Key Information Stored

The documented physical schema contains nine columns. The most significant are:

• PRICE_LIST_ID — Foreign key to QP_LIST_HEADERS_B; identifies the specific price list being assigned. It is part of the composite primary key (AS_PRICE_LISTS_PK) and the unique index AS_PRICE_LISTS_U1.
• GROUP_ID — Foreign key to AS_PRICE_LIST_GROUPS; identifies the group to which the price list is assigned. It is also part of the composite primary key and the unique index AS_PRICE_LISTS_U1.
• DESCRIPTION — Free-text description providing context for the price list assignment.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS; enforces multi-tenant or operating-unit level data security, restricting visibility of the assignment.
• CREATED_BY / CREATION_DATE — Standard WHO columns capturing the creating user and timestamp.
• LAST_UPDATED_BY / LAST_UPDATE_DATE — Standard WHO columns capturing the last modifying user and timestamp.
• LAST_UPDATE_LOGIN — Tracks the login session associated with the most recent update.

The surrogate primary key is the composite AS_PRICE_LISTS_PK (PRICE_LIST_ID, GROUP_ID). A unique index, AS_PRICE_LISTS_U1 (GROUP_ID, PRICE_LIST_ID), serves as a business-key candidate, reinforcing that a given price list may appear only once per group. Note that the primary key columns are also the foreign-key columns, so no separate surrogate sequence column is documented.

Common Use Cases and Queries

Typical scenarios for querying AS_PRICE_LISTS include determining which price lists belong to a specific group, listing all groups associated with a given price list, and auditing assignments for security-group compliance. A representative join to resolve price list names is:

• SELECT apl.PRICE_LIST_ID, qlh.NAME, apl.GROUP_ID, apg.GROUP_NAME FROM AS_PRICE_LISTS apl JOIN QP_LIST_HEADERS_B qlh ON apl.PRICE_LIST_ID = qlh.LIST_HEADER_ID JOIN AS_PRICE_LIST_GROUPS apg ON apl.GROUP_ID = apg.GROUP_ID;

Reporting use cases include price list group membership reports, security-group-level access reviews, and data migration validation when moving pricing configurations between environments. The WHO columns support audit trail queries identifying who assigned a price list to a group and when.

Related Objects

The following objects are most significant in relation to AS_PRICE_LISTS, based on documented foreign-key relationships:

• QP_LIST_HEADERS_B — Referenced via AS_PRICE_LISTS.PRICE_LIST_ID; holds the price list header definition.
• AS_PRICE_LIST_GROUPS — Referenced via AS_PRICE_LISTS.GROUP_ID; defines the logical grouping of price lists.
• FND_SECURITY_GROUPS — Referenced via AS_PRICE_LISTS.SECURITY_GROUP_ID; governs data security partitioning.
• AS_PRICE_LISTS_PK — The primary key constraint enforcing uniqueness of the composite identifier.
• AS_PRICE_LISTS_U1 — Unique index on (GROUP_ID, PRICE_LIST_ID), supporting business-key lookups.

These relationships position AS_PRICE_LISTS as a critical integration point between Advanced Pricing list definitions and Sales Foundation grouping mechanisms, with security enforcement layered through FND_SECURITY_GROUPS.