Search Results inventory_item




Overview
Explore in AI Chat

Overview

ASO_PVT_QUOTE_LINES_BALI_V is a reporting view owned by the APPS schema within the ASO (Order Capture) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents quote line information enriched with inventory item master data, forming a flattened, presentation-oriented record set suitable for quote line inquiry, pricing review, and integration extracts. The view is designated "BALI," reflecting its use in the Order Capture quote-line presentation layer. Because it joins quote line, quote line detail, and item master sources, it allows concurrent access to configuration, service, and pricing attributes without requiring callers to reproduce the underlying join logic themselves.

In EBS reporting and integration contexts, the view serves as a stable read interface over the base quote line tables, shielding consumers from the details of the item master view (MTL_SYSTEM_ITEMS_VL) and the line detail table. This is particularly relevant for the search term "inventory_item," since the view projects both INVENTORY_ITEM_ID and the concatenated user-facing inventory item identifier.

Underlying Base Objects

The view is defined over three principal sources joined by an outer join on quote line detail. The documented referenced base objects include ASO_LINE_NUM_INT (package), ASO_PVT_QUOTE_LINES_NUM_V (view), and FND_PROFILE (package). The view text itself selects from ASO_QUOTE_LINES_ALL (aliased QUOTE_LINES), ASO_QUOTE_LINE_DETAILS (aliased LINE_DETAILS), and MTL_SYSTEM_ITEMS_VL (aliased ITEMS).

  • ASO_QUOTE_LINES_ALL — the primary quote line entity, supplying line identifiers, organization, item reference, pricing, and quantity.
  • ASO_QUOTE_LINE_DETAILS — the detail entity joined via an outer join on QUOTE_LINE_ID, supplying configuration and service attributes that may be absent for non-service or non-configured lines.
  • MTL_SYSTEM_ITEMS_VL — the item master view, providing concatenated segments, padded segments, and description for the inventory item.

The outer join on LINE_DETAILS (marked with the (+) operator) ensures that quote lines without corresponding detail rows are retained, which is important for completeness in extracts.

Key Columns

Common Use Cases and Queries

A frequent requirement is resolving quote lines by inventory item, which this view supports directly through the concatenated segment column.

  • Retrieving quote lines for a specific inventory item for pricing review or margin analysis.
  • Producing configuration hierarchies using the indented description expression.
  • Extracting service line details tied to reference orders.

Example query:

  • SELECT ql.quote_header_id, ql.quote_line_id, ql.line_number, ql.inventory_item, ql.item_description, ql.quantity, ql.uom_code, ql.line_quote_price FROM aso_pvt_quote_lines_bali_v ql WHERE ql.inventory_item LIKE :p_item_pattern AND ql.org_id = :p_org_id ORDER BY ql.quote_header_id, ql.line_number;

Because the view already resolves the item master join, callers need not query MTL_SYSTEM_ITEMS_VL separately, reducing join complexity in quote-to-order reporting and interface extracts.