Results for “quote_party_id”

50+ results




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

Overview

ASO_QUOTE_PARTIES is a table in the ASO (Order Capture) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. As its description states, it stores "party information related to quotes." In the Oracle iStore and Quoting data model, a quote is not associated with a single customer; instead, multiple parties participate in the transaction lifecycle — the sold-to customer, the ship-to party, the bill-to party, and other role-bearing entities. ASO_QUOTE_PARTIES is the intersection table that records which HZ party, party site, and customer account plays which role against a given quote header, quote line, or quote shipment.

The table resides in the ASO schema and contains 37 documented columns. Its heuristic Data Vault classification, mined from the foreign key structure, is link. This is a modeling suggestion only: the table principally resolves many-to-many relationships between quotes and trading partners, and it does not carry a wide set of descriptive attributes beyond the role and attribute columns that would characterize a satellite.

Key Information Stored

The surrogate primary key is QUOTE_PARTY_ID, enforced by the ASO_QUOTE_PARTIES_PK constraint. Three unique indexes are documented, and these identify business-key candidates: ASO_QUOTE_PARTIES_U1 on QUOTE_PARTY_ID, ASO_QUOTE_PARTIES_U2 on PARTY_SITE_ID, and ASO_QUOTE_PARTIES_U3 on CUST_ACCOUNT_ID.

The most significant columns are:

Standard WHO columns are present: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and OBJECT_VERSION_NUMBER, the last of which supports optimistic locking in the OAF-based quoting UI.

Common Use Cases and Queries

The most frequent scenario is retrieving all parties associated with a quote in order to display or validate the sold-to, ship-to, and bill-to roles. A typical query joins the quote header to its parties and thence to the customer master:

  • SELECT p.quote_party_id, p.party_type, p.party_id, p.cust_account_id, hp.party_name FROM aso_quote_parties p, hz_parties hp WHERE p.party_id = hp.party_id AND p.quote_header_id = :quote_header_id;
  • Identifying which quote shipments carry which ship-to site, by joining QUOTE_SHIPMENT_ID to ASO_SHIPMENTS.
  • Reporting on all quotes in which a given customer account appears, using CUST_ACCOUNT_ID as the filter.
  • Extracting the flexible attribute columns into an integration or data-warehouse feed, keyed on QUOTE_PARTY_ID.
  • Auditing role assignments over time via CREATION_DATE, LAST_UPDATE_DATE, and OBJECT_VERSION_NUMBER.

Because the table is link-style, reports commonly aggregate it against ASO_QUOTE_HEADERS_ALL for pipeline analysis by customer, and against HZ_CUST_ACCOUNTS for revenue or territory reporting.

Related Objects

  • ASO_QUOTE_HEADERS_ALL — parent quote header; joined on ASO_QUOTE_PARTIES.QUOTE_HEADER_ID = ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID.
  • ASO_QUOTE_LINES_ALL — quote line detail; joined on ASO_QUOTE_PARTIES.QUOTE_LINE_ID = ASO_QUOTE_LINES_ALL.QUOTE_LINE_ID.
  • ASO_SHIPMENTS — shipment records; joined on ASO_QUOTE_PARTIES.QUOTE_SHIPMENT_ID = ASO_SHIPMENTS.QUOTE_SHIPMENT_ID.
  • HZ_PARTIES — the trading partner master; joined on ASO_QUOTE_PARTIES.PARTY_ID = HZ_PARTIES.PARTY_ID.
  • HZ_CUST_ACCOUNTS — customer account master; joined on ASO_QUOTE_PARTIES.CUST_ACCOUNT_ID = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID.
  • FND_SECURITY_GROUPS — multi-org security; joined on ASO_QUOTE_PARTIES.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID.

The table is populated and maintained principally through the Order Capture and Quoting application APIs rather than by direct DML, and it should be treated as an internal ASO object when designing extensions or data extracts.