Search Results total_shipping_charge




Overview
Explore in AI Chat

Overview

APPS.ASO_QUOTE_HEADERS_ALL_V is a reporting and integration view in Oracle E-Business Suite that exposes the header-level attributes of sales quotations managed within Oracle Advanced Pricing / Oracle Sales (the ASO schema). The view is defined as a single-source projection over the ASO_QUOTE_HEADERS base table and carries no joins, aggregations, or filtering logic of its own. Each row represents one version of one quote header, uniquely identified by QUOTE_HEADER_ID, within a specific operating unit context given by ORG_ID.

Because the view contains the "_ALL_" naming convention, it is intended to make quote header data visible across organizations within multi-org security models, subject to the profile-based security wrapper implemented at the base table or synonym level. It is the canonical source for quote totals, pricing currency information, customer and site references, and workflow/approval state. The user search term total_shipping_charge points directly to one of the monetary roll-up columns exposed here, confirming that this view is the correct stopping point for quote-level freight and shipping reporting.

Underlying Base Objects

The documented referenced base object is ASO_QUOTE_HEADERS, accessed through a SYNONYM. The view text is a straightforward column-by-column SELECT from that object, meaning column names, data types, and nullability are inherited unchanged. There is no denormalization: every attribute available in ASO_QUOTE_HEADERS is surfaced unfiltered in the view.

  • ASO_QUOTE_HEADERS — the physical table storing one record per quote header version, including versioning, approval, pricing, and multi-org columns.
  • ASO_QUOTE_HEADERS (SYNONYM) — the APPS-layer public synonym that the view references, permitting the view to be created and queried without a hard-coded schema qualifier.

Because the view is a pure projection, it carries no additional performance penalty beyond the base table access, and it does not introduce a WHERE clause that would suppress rows from other operating units or statuses.

Key Columns

Common Use Cases and Queries

The most common requirement associated with this view is reporting and extracting quote header totals, including shipping charges, by customer, operating unit, and currency. The following sample isolates the current version of each quote and surfaces its shipping charge.

SELECT qh.quote_number, qh.quote_name, qh.quote_version, qh.org_id,
       qh.customer_name_and_title, qh.currency_code,
       qh.total_list_price, qh.total_adjusted_amount,
       qh.total_tax, qh.total_shipping_charge, qh.total_quote_price
 FROM apps.aso_quote_headers_all_v qh
 WHERE qh.max_version_flag = 'Y'
   AND qh.quote_status_id IS NOT NULL
 ORDER BY qh.org_id, qh.quote_number;

Other frequent uses include joining this view to ASO_QUOTE_LINES_ALL to reconcile header-level shipping totals against line-level charges, feeding shipping amounts into downstream order import via ORDER_ID, and monitoring contract-backed quotes by filtering on CONTRACT_ID or CONTRACT_TEMPLATE_ID. Because the view exposes ATTRIBUTE1 through ATTRIBUTE20, it is also a standard vehicle for extracting descriptive flexfield content into data warehouse or integration staging layers.