Search Results account_info

Overview

XNC_QUOTE_FIND_V is a database view that belongs to the XNC – Sales for Communications product family, a module classified as obsolete in Oracle E-Business Suite. The view consolidates quote information drawn from Oracle Advanced Sales and Order Management (ASO) and Oracle Order Management (OE) tables, together with party and customer account master data from Oracle Trading Community Architecture (HZ). Its documented purpose is to retrieve quote details — including party information, quote details, account details, and subscription information — and it is currently used by the Quote Search Window in the XNC application.

The view functions as a flattened, denormalized reporting surface for quote searching. Rather than requiring the Quote Search Window to join the quote header, quote line, attribute, and multiple HZ master tables on demand, XNC_QUOTE_FIND_V exposes a single row per qualifying quote line (with the DISTINCT operator applied to remove duplication), making it directly consumable for search results and integration queries. Because the module is obsolete, the view is not implemented in the current database schema, and no base objects are documented in the ETRM 12.2.2 metadata.

Underlying Base Objects

The view text reveals a multi-table join across four functional areas:

• ASO quote tables: ASO_QUOTE_HEADERS_ALL (aliased QUOTE_HEADERS), ASO_QUOTE_LINES_ALL (QUOTE_LINES), and ASO_QUOTE_LINE_ATTRIBS_EXT (QUOTE_LINE_ATTRIBS). These supply quote header, quote line, and line attribute (subscription) data.
• Order Management: OE_ORDER_HEADERS (ORDER_HEADERS), outer-joined to the quote header via the ORDER_ID/HEADER_ID relationship.
• HZ party and account tables: HZ_PARTIES (PARTY_INFO), HZ_CUST_ACCOUNTS (ACCOUNT_INFO), and HZ_CONTACT_POINTS (PHONE_INFO).

Join conditions link quote headers to parties by PARTY_ID, to customer accounts by CUST_ACCOUNT_ID, to quote lines by QUOTE_HEADER_ID, to order headers by ORDER_ID, and quote lines to their extended attributes by QUOTE_LINE_ID. The HZ_CUST_ACCOUNTS and OE_ORDER_HEADERS joins are outer joins (denoted by the (+) operator), confirming that a quote record can surface even when no associated customer account or order exists.

Key Columns

• ROW_ID, QUOTE_HEADER_ID: The row identifier and primary key of the quote header.
• QUOTE_NAME, QUOTE_NUMBER, QUOTE_VERSION: Human-readable quote identification. QUOTE_VERSION is the column most relevant to a "quote_version" search, enabling users to distinguish successive revisions of the same quote.
• QUOTE_EXPIRATION_DATE, QUOTE_STATUS_ID, ORDERED_DATE: Lifecycle and status information for the quote.
• ORDER_ID, ORDER_NUMBER: The associated order header, indicating conversion of a quote into an order.
• ORG_ID, PARTY_ID, PARTY_TYPE, ORGANIZATION_NAME, CONTACT_FIRST_NAME, CONTACT_MIDDLE_NAME, CONTACT_LAST_NAME: Multi-org and party/contact identification fields.
• CUST_ACCOUNT_ID, ACCOUNT_NUMBER: Customer account information.
• ORG_CONTACT_ID, PHONE_ID, FULL_PHONE_NUMBER: Contact point details, with the phone number concatenated from area code and number.
• TOTAL_QUOTE_PRICE, ORDER_TYPE_ID: Commercial attributes of the quote.
• LINE_ATTRIBS_NAME, SUBSCRIPTION_VALUE: Subscription-oriented extended attribute name/value pairs sourced from ASO_QUOTE_LINE_ATTRIBS_EXT.

Common Use Cases and Queries

The primary use case is the XNC Quote Search Window, which allows users to locate quotes by number, version, party, account, or status. Typical query patterns filter on quote identity or associated party/account.

• Locate a quote by version:
  SELECT QUOTE_NUMBER, QUOTE_VERSION, QUOTE_NAME, QUOTE_STATUS_ID FROM XNC_QUOTE_FIND_V WHERE QUOTE_NUMBER = :quote_number ORDER BY QUOTE_VERSION DESC;
• Search quotes for a party:
  SELECT QUOTE_NUMBER, QUOTE_VERSION, ORGANIZATION_NAME, ACCOUNT_NUMBER FROM XNC_QUOTE_FIND_V WHERE PARTY_ID = :party_id;
• Retrieve subscription attributes for a quote:
  SELECT QUOTE_NUMBER, QUOTE_VERSION, LINE_ATTRIBS_NAME, SUBSCRIPTION_VALUE FROM XNC_QUOTE_FIND_V WHERE QUOTE_HEADER_ID = :quote_header_id;

Because XNC is obsolete and the view is not implemented in the current database, these queries should be treated as reference examples. Organizations migrating off XNC should reproduce equivalent joins directly against ASO_QUOTE_HEADERS_ALL and its related tables.