Search Results i_header_contact_party

Overview

APPS.IBE_QUOTE_HEADERS_V is a reporting and integration view over Oracle iStore / Quoting (ASO) quote header data. It exposes a denormalized, human-readable projection of the ASO_QUOTE_HEADERS entity joined to Oracle Trading Community Architecture (TCA) party, customer account, and relationship data, together with the decoded status meaning from the quote status lookup view. The view is owned by APPS and is intended for consumers—reports, concurrent programs, OAF pages, and external interfaces—that require quote header information in which party names, contact names, organization names, invoice-to details, and status meanings are already resolved rather than stored as raw identifiers.

Its principal design characteristic is the conditional resolution of party attributes. The view determines the party type from I_PARTIES.PARTY_TYPE and, for the value 'PARTY_RELATIONSHIP', sources person name components from the header contact party; for all other party types it sources the same components from the customer party. This branching allows a single row to present the correct contact identity whether the quote header points at a customer party directly or at a relationship representing a contact.

Underlying Base Objects

The documented base objects are ASO_QUOTE_HEADERS (synonym), ASO_QUOTE_STATUSES_VL (view), HZ_CUST_ACCOUNTS (synonym), HZ_PARTIES (synonym), and HZ_RELATIONSHIPS (synonym).

• ASO_QUOTE_HEADERS — the primary transactional source, supplying all quote-level attributes including QUOTE_HEADER_ID, QUOTE_NAME, QUOTE_NUMBER, QUOTE_VERSION, QUOTE_STATUS_ID, QUOTE_SOURCE_CODE, expiration and pricing dates, and the standard WHO/audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) plus the concurrent program columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE).
• ASO_QUOTE_STATUSES_VL — the translated status view supplying STATUS_CODE, MEANING, UPDATE_ALLOWED_FLAG, and AUTO_VERSION_FLAG.
• HZ_PARTIES — referenced multiple times to resolve party and person names, including the customer party, the header contact party, the invoice-to party, and the invoice-to relationship party aliases seen in the view text.
• HZ_CUST_ACCOUNTS — joined through CUST_ACCOUNT_ID and INVOICE_TO_CUST_ACCOUNT_ID to associate the quote with its customer and invoice-to account contexts.
• HZ_RELATIONSHIPS — used to resolve relationship-based contacts, supporting the PARTY_RELATIONSHIP branch of the name decodes.

Key Columns

• QUOTE_HEADER_ID — primary identifier of the quote header, used for all downstream joins.
• PARTY_TYPE — drives the conditional name resolution; the value 'PARTY_RELATIONSHIP' selects relationship-based contact attributes.
• person_first_name, person_middle_name, person_last_name — contact name components, decoded from either I_HEADER_CONTACT_PARTY or I_CUST_PARTIES based on PARTY_TYPE.
• organization_name / party_name — the account or party display name; organization_name is populated only when the customer party type is 'ORGANIZATION'.
• STATUS_CODE and MEANING — the quote status code and its translated display meaning, with UPDATE_ALLOWED_FLAG and AUTO_VERSION_FLAG indicating whether status changes and automatic versioning are permitted.
• invoice_to_cust_name / invoice_to_party_name — invoice-to account name, returned as null when INVOICE_TO_CUST_ACCOUNT_ID is null.
• invoice_to_contact_first_name, invoice_to_contact_middle_name, invoice_to_contact_last_name — the invoice-to contact person name components.
• QUOTE_NAME, QUOTE_NUMBER, QUOTE_VERSION, QUOTE_EXPIRATION_DATE, PRICE_FROZEN_DATE — core business attributes of the quote header.

Common Use Cases and Queries

The view supports quote status reporting, contact and party identification for iStore quotes, and integration extracts where resolved names are required. The user search term i_header_contact_party corresponds to the internal alias used inside the view text to resolve relationship-based contact names in the PARTY_RELATIONSHIP branch of the decode logic.

A typical query lists active quotes with resolved contact and status information:

• SELECT quote_number, quote_name, quote_version, status_code, meaning, party_name, person_first_name, person_last_name FROM apps.ibe_quote_headers_v WHERE status_code = 'ACTIVE' ORDER BY creation_date DESC;
• SELECT quote_number, invoice_to_cust_name, invoice_to_contact_first_name, invoice_to_contact_last_name FROM apps.ibe_quote_headers_v WHERE invoice_to_cust_account_id IS NOT NULL;

Because the view resolves TCA party structures at query time, it is well suited to ad hoc reporting and interface extraction, while bulk transactional processing should continue to address ASO_QUOTE_HEADERS directly.