Search Results exp_date

Overview

ASO_SEARCH_QUOTES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the ASO - Order Capture product family. It is a narrow, denormalized projection designed specifically to support quote search and lookup functionality within Oracle Quoting and Oracle Order Capture. The view exposes a flattened, user-friendly set of quote header attributes — including the quote name, company, account, customer name, category, status, and total price — so that search screens, list-of-values (LOV) queries, and lightweight integrations can retrieve candidate quote records without navigating the full complexity of the underlying quoting data model.

In both EBS 12.1.1 and 12.2.2, the view is documented as VALID, meaning it is compiled and available for query at runtime. Because every column in ASO_SEARCH_QUOTES_V originates from Aso_Quote_Headers_V, it is best understood as a convenience layer or "search facade" rather than a distinct business entity. It carries no additional joins, filters, or computed logic beyond column renaming; its value lies in the simplified naming and reduced column count, which make it practical for search-driven interfaces.

Underlying Base Objects

The ETRM metadata documents two referenced base objects: ASO_QUOTE_HEADERS_V (VIEW) and ASO_SHIPMENT_PVT (PACKAGE). The primary dependency is ASO_QUOTE_HEADERS_V, a view over the quote header tables that itself resolves customer, organization, account, and pricing information. The documented view text confirms a direct one-to-one relationship: each row in ASO_SEARCH_QUOTES_V maps to exactly one row in ASO_QUOTE_HEADERS_V, since the query is a simple SELECT with column aliasing and no joins or aggregation.

ASO_SHIPMENT_PVT appears as a referenced dependency in the metadata. In practice, this package is more commonly associated with shipment-related processing; its appearance in the dependency chain is likely incidental (for example, inherited through compilation dependencies of underlying objects) rather than reflecting a functional relationship to quote search. Consultants should not assume that ASO_SEARCH_QUOTES_V exposes shipping data — it does not; its column list is confined entirely to quote header attributes.

Key Columns

• QUOTE_HEADER_ID — Primary identifier of the quote header; the join key back to ASO_QUOTE_HEADERS_V and downstream quoting tables.
• QUOTE_NAME — The user-assigned descriptive name of the quote; the column most relevant to the "quote_name" search use case.
• COMPANY — Derived from QHDR.ORGANIZATION_NAME; identifies the customer organization.
• ACCOUNT — Derived from QHDR.ACCOUNT_NUMBER; the customer account number.
• CATEGORY — The quote category code, indicating the classification of the quote.
• FIRST_NAME / LAST_NAME — Customer contact person's names, useful for person-based searches.
• QUOTE_NUMBER — The system-generated quote number.
• VERSION — The quote version indicator, supporting versioned quote tracking.
• STATUS — The current quote status.
• EXP_DATE — The quote expiration date.
• QUOTE_PRICE — The total quote price, derived from QHDR.TOTAL_QUOTE_PRICE.

Common Use Cases and Queries

The view's principal use case is interactive quote search. Search pages and LOVs commonly filter on QUOTE_NAME, QUOTE_NUMBER, or customer attributes to present a concise result list. A typical search by quote name:

SELECT quote_header_id, quote_name, company, account,
       quote_number, version, status, quote_price
FROM   aso_search_quotes_v
WHERE  UPPER(quote_name) LIKE UPPER(:p_quote_name)||'%'
ORDER  BY quote_name;

Other common scenarios include restricting to active quotes (WHERE status = 'ACTIVE'), listing quotes nearing expiration (ORDER BY exp_date), or retrieving the header ID for a known quote name to pass to downstream APIs. Because the view draws entirely from ASO_QUOTE_HEADERS_V, any security or business rules enforced by that underlying view are inherited automatically. When greater detail is required — such as lines, pricing attributes, or shipment context — join back to ASO_QUOTE_HEADERS_V or the base quoting tables on QUOTE_HEADER_ID rather than expecting additional columns here.