Search Results aso_quote_parties




Overview
Explore in AI Chat

Overview

The ASO_QUOTE_PARTIES table is a core data object within the Oracle E-Business Suite (EBS) Order Capture (ASO) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for storing all party-related information associated with sales quotes. A party, in this context, represents any entity involved in a quote transaction, such as a customer, contact, bill-to, ship-to, or sold-to party. The table's primary role is to establish and maintain the relationships between a quote (or specific quote lines and shipments) and the various parties from the Trading Community Architecture (TCA) model, thereby enabling complex customer hierarchies and contact management during the quotation process.

Key Information Stored

The table's structure is designed to link quote entities to TCA parties and define their roles. Its primary key is the system-generated QUOTE_PARTY_ID. The most critical columns are the foreign key references that define the object relationships: QUOTE_HEADER_ID links to ASO_QUOTE_HEADERS_ALL, QUOTE_LINE_ID links to ASO_QUOTE_LINES_ALL, and QUOTE_SHIPMENT_ID links to ASO_SHIPMENTS. The PARTY_ID column is a foreign key to HZ_PARTIES, which holds the actual party details. Additional columns typically include attributes to specify the party's role (e.g., customer, contact), the source of the party record, and standard Who columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing.

Common Use Cases and Queries

This table is essential for reporting and data extraction related to quote parties. A common use case is generating a list of all contacts or ship-to addresses for a specific quote. Another is analyzing customer engagement by identifying all quotes associated with a particular TCA party. A typical query involves joining ASO_QUOTE_PARTIES with HZ_PARTIES and the relevant quote header or line table.

  • Sample Query (Parties for a Quote Header):
    SELECT aqp.quote_header_id, hp.party_name, aqp.party_role
    FROM aso.aso_quote_parties aqp,
    hz_parties hp
    WHERE aqp.party_id = hp.party_id
    AND aqp.quote_header_id = <quote_id>;
  • Reporting Use Case: Creating a report showing the distribution of party roles (bill-to vs. ship-to) across all active quotes.

Related Objects

As indicated by the foreign keys in the metadata, ASO_QUOTE_PARTIES has direct, integral relationships with several key ASO tables. It is a child table of ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES_ALL, and ASO_SHIPMENTS. Its most critical relationship is with HZ_PARTIES in the TCA schema, which supplies the master party data. This table is also referenced by various Order Capture APIs and user interfaces (OAF pages) that manage quote creation and maintenance. Consequently, any custom integrations or extensions involving quote party data will typically interact with this table or its associated public APIs.