Results for “service_ref_order_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.ASO_PVT_QUOTE_LINES_BALIVIEW_V view is a denormalized reporting object within the ASO (Order Capture) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It consolidates quote line data from the Oracle Advanced Pricing and quoting tables with item master attribute information and configurator/service line details, presenting a single logical row per quote line. Its "BALIVIEW" naming convention reflects a BI-oriented, read-only presentation layer intended for reporting, extensibility, and integration consumers that require flattened access to quote line and quote line detail attributes without joining multiple base objects manually. The view is owned by APPS and is defined solely as a SQL join; it holds no physical storage and is executed at query time against the underlying synonyms and views listed in the ETRM metadata.

Underlying Base Objects

The view text is defined over three documented base objects:

• ASO_QUOTE_LINES (exposed via the synonym ASO_QUOTE_LINES_ALL) — the primary quote line fact source, aliased QUOTE_LINES. This is the driving table, supplying quote header, pricing, quantity, and unit-of-measure attributes.
• ASO_QUOTE_LINE_DETAILS — aliased LINE_DETAILS, providing configuration and service-specific line attributes.
• MTL_SYSTEM_ITEMS_VL — a view over the item master, aliased ITEMS, supplying item description, type, concatenated segments, and service/return flags.

The join between QUOTE_LINES and LINE_DETAILS is an outer join on QUOTE_LINE_ID (+) and the join to MTL_SYSTEM_ITEMS_VL is on INVENTORY_ITEM_ID. Because MTL_SYSTEM_ITEMS_VL is a view rather than a base table, queries against this view are subject to the performance characteristics of that view layer.

Key Columns

Key columns fall into three groups. Quote line identity and pricing columns include QUOTE_LINE_ID, QUOTE_HEADER_ID, ORG_ID, LINE_NUMBER, QUANTITY, UOM_CODE, CURRENCY_CODE, LINE_LIST_PRICE, LINE_ADJUSTED_AMOUNT, LINE_ADJUSTED_PERCENT, and LINE_QUOTE_PRICE; two derived amount columns compute LINE_LIST_PRICE * QUANTITY and LINE_ADJUSTED_AMOUNT * QUANTITY. Item attribute columns exposed from MTL_SYSTEM_ITEMS_VL include CONCATENATED_SEGMENTS, PADDED_CONCATENATED_SEGMENTS, BOM_ITEM_TYPE, DESCRIPTION, SERVICEABLE_PRODUCT_FLAG, SERVICE_ITEM_FLAG, VENDOR_WARRANTY_FLAG, and RETURNABLE_FLAG. The line detail group, sourced from ASO_QUOTE_LINE_DETAILS, contains QUOTE_LINE_DETAIL_ID, CONFIG_HEADER_ID, CONFIG_REVISION_NUM, CONFIG_ITEM_ID, COMPLETE_CONFIGURATION_FLAG, VALID_CONFIGURATION_FLAG, COMPONENT_CODE, and the service columns SERVICE_DURATION, SERVICE_NUMBER, SERVICE_PERIOD, SERVICE_UNIT_SELLING_PERCENT, SERVICE_UNIT_LIST_PERCENT, and SERVICE_REF_LINE_ID.

Common Use Cases and Queries

This view is typically used to report quote line content with configuration and service context, to feed downstream integrations requiring flattened quote data, and to reconcile pricing versus item attributes. A representative query selecting line details for a quote follows:

• SELECT quote_line_id, line_number, concatenated_segments, description, quantity, uom_code, line_quote_price, component_code, service_number FROM aso_pvt_quote_lines_baliview_v WHERE quote_header_id = :p_header_id ORDER BY line_number;
• Reporting configured components: SELECT quote_line_id, config_item_id, component_code, complete_configuration_flag FROM aso_pvt_quote_lines_baliview_v WHERE quote_header_id = :p_header_id AND component_code IS NOT NULL;
• Service line analysis: SELECT quote_line_id, service_number, service_duration, service_unit_list_percent FROM aso_pvt_quote_lines_baliview_v WHERE service_number IS NOT NULL;

Because the view is private-style ("PVT") and not a documented public API, consumers should treat it as a reporting convenience and validate its continued validity on patch application in 12.1.1 and 12.2.2.