Search Results invoice_to_cust_name




Overview
Explore in AI Chat

Overview

IBE_QUOTE_HEADERS_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite (R12.1.1 and R12.2.2). It belongs to the IBE (iStore) product family and provides a denormalized, presentation-ready projection of sales quote header data originating in Oracle Advanced Supply Chain Planning's Order Capture / Quoting module (ASO). Its principal function is to expose quote header attributes together with party, account, and contact name resolution logic, so that iStore and related quoting interfaces can render quote information without repeatedly joining the underlying TCA (Trading Community Architecture) tables.

The view is especially relevant to the queried token party_relationship. Because quotes may be issued against either a standalone party (a person) or a party relationship (a contact associated with an organization), the view applies DECODE logic against I_PARTIES.PARTY_TYPE to select the applicable name column. When the party type is PARTY_RELATIONSHIP, the contact-based name columns from I_HEADER_CONTACT_PARTY are used; otherwise the person name columns from I_CUST_PARTIES are returned. This conditional resolution is the core mechanism that makes the view useful for both business-to-consumer and business-to-business quoting scenarios.

Underlying Base Objects

The documented base objects referenced by the view are:

  • ASO_QUOTE_HEADERS (synonym) — the primary source for quote header attributes such as quote number, name, version, status, and expiration.
  • ASO_QUOTE_STATUSES_VL (view) — supplies the status code, meaning, and status control flags (update/allowed, auto-version).
  • HZ_CUST_ACCOUNTS (synonym) — the customer account records that identify the invoice-to account.
  • HZ_PARTIES (synonym) — the party master, providing party type and name information.
  • HZ_RELATIONSHIPS (synonym) — the relationship records linking a contact to an organization, which drive the PARTY_RELATIONSHIP branch of the name resolution logic.

The view therefore sits on top of the ASO quoting model and the Oracle TCA model, joining them so that quote headers can be reported with fully resolved customer and contact identity.

Key Columns

Common Use Cases and Queries

Typical uses include iStore quote listings, customer-facing quote status reporting, and integration extracts by quote number or party.

Example — retrieve quote headers for a party relationship:

SELECT qh.quote_number,
       qh.quote_name,
       qh.party_type,
       qh.person_first_name,
       qh.person_last_name,
       qh.organization_name,
       qh.meaning AS status_meaning
  FROM apps.ibe_quote_headers_v qh
 WHERE qh.party_type = 'PARTY_RELATIONSHIP'
   AND qh.quote_expiration_date > SYSDATE;

Example — resolve a specific quote by number:

SELECT quote_header_id,
       quote_number,
       quote_version,
       party_name,
       invoice_to_cust_name,
       status_code
  FROM apps.ibe_quote_headers_v
 WHERE quote_number = :p_quote_number;

Because the view embeds the PARTY_RELATIONSHIP DECODE logic, reports do not need to re-implement TCA relationship joins, simplifying integration and reporting against Oracle Quoting.