Results for “aso_quote_lines_all”

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

Overview

ASO_QUOTE_LINES_ALL is the core transactional table in the Oracle EBS Order Capture (ASO) module, owned by the ASO schema with status VALID in releases 12.1.1 and 12.2.2. Per the ETRM documentation, the table "stores information for a typical quote or an order line." Each row represents one line of a quote or sales order captured through the Oracle Quoting and Order Capture functionality, anchoring pricing, shipment, party, tax, and configuration data that downstream modules such as Order Management and Advanced Pricing depend upon. The table maintains 87 documented columns and is a high-volume child of ASO_QUOTE_HEADERS_ALL, keyed by the surrogate primary key QUOTE_LINE_ID.

From a modeling perspective, the ETRM relationship mining classifies this object as hub-leaning — that is, a suggested candidate for a Data Vault hub because QUOTE_LINE_ID is the stable business key referenced by numerous dependent satellites (price attributes, tax details, shipments) and links (line relationships, party relationships). This classification is heuristic and intended as a design suggestion, not an enforced constraint.

Key Information Stored

The table's unique business-key candidate is QUOTE_LINE_ID, also defined as the single-column primary key through ASO_QUOTE_LINES_ALL_PK and mirrored in unique index ASO_QUOTE_LINES_ALL_U1. The principal columns include:

• QUOTE_LINE_ID — surrogate primary key, the dependency anchor for all child tables.
• QUOTE_HEADER_ID — foreign key to the parent quote header; the mandatory join to ASO_QUOTE_HEADERS_ALL.
• LINE_NUMBER and LINE_CATEGORY_CODE / ITEM_TYPE_CODE — sequence and classification of the line (e.g., standard, service, configuration).
• ORG_ID and ORGANIZATION_ID — multi-org and inventory organization context.
• INVENTORY_ITEM_ID, QUANTITY, UOM_CODE — the ordered item, quantity, and unit of measure.
• PRICE_LIST_ID, PRICE_LIST_LINE_ID, CURRENCY_CODE, LINE_LIST_PRICE, LINE_ADJUSTED_AMOUNT, LINE_QUOTE_PRICE — pricing foundation used by Advanced Pricing and the price adjustment engine.
• INVOICE_TO_PARTY_ID, INVOICE_TO_PARTY_SITE_ID, INVOICE_TO_CUST_ACCOUNT_ID, INVOICE_TO_CUST_PARTY_ID — invoice-to party references into HZ_PARTIES and HZ_PARTY_SITES.
• PRICING_QUANTITY, PRICING_QUANTITY_UOM, RECALCULATE_FLAG, SELLING_PRICE_CHANGE — pricing recalculation controls.
• COMMITMENT_ID — foreign key to PON_OFFER_COMMITMENTS supporting procurement commitment linkage.
• SECURITY_GROUP_ID — application-level row security into FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the ASO API layer.
• ATTRIBUTE1 through ATTRIBUTE20 — descriptive flexfield segments for client-specific extensions.
• CONFIG_MODEL_TYPE and SHIP_MODEL_COMPLETE_FLAG — configuration model state.

Common Use Cases and Queries

The most frequent reporting pattern joins quote lines to their headers, showing quoted value by customer, currency, and period. A representative query is:

SELECT h.QUOTE_NUMBER, l.LINE_NUMBER, l.INVENTORY_ITEM_ID,
       l.QUANTITY, l.LINE_QUOTE_PRICE, l.CURRENCY_CODE
  FROM ASO_QUOTE_LINES_ALL l,
       ASO_QUOTE_HEADERS_ALL h
 WHERE l.QUOTE_HEADER_ID = h.QUOTE_HEADER_ID
   AND l.ORG_ID = :org_id;

Typical scenarios include: pipeline reporting on open quotes by line price; reconciliation of quoted versus ordered quantities before order submission; extraction of all price adjustments applied to a line through ASO_PRICE_ADJUSTMENTS; configuration audit using ASO_QUOTE_LINE_DETAILS joined on QUOTE_LINE_ID; tax analysis via ASO_TAX_DETAILS; and multi-org reporting driven by ORG_ID and SECURITY_GROUP_ID. Queries against this table should generally be filtered by ORG_ID and date bounds to avoid full scans on the 87-column structure, and joins through QUOTE_LINE_ID should be indexed on the child side.

Related Objects

The ETRM FK graph shows ASO_QUOTE_LINES_ALL as a dependent of several parents and a hub for numerous children:

• ASO_QUOTE_HEADERS_ALL — parent via QUOTE_HEADER_ID, defining the enclosing quote.
• HZ_PARTIES and HZ_PARTY_SITES — customer and site references via INVOICE_TO_PARTY_ID, INVOICE_TO_CUST_PARTY_ID, and INVOICE_TO_PARTY_SITE_ID.
• SO_PRICE_LIST_LINES_115 — source price list line via PRICE_LIST_LINE_ID.
• PON_OFFER_COMMITMENTS — commitment source via COMMITMENT_ID.
• FND_SECURITY_GROUPS — security context via SECURITY_GROUP_ID.
• ASO_QUOTE_LINE_DETAILS, ASO_PRICE_ATTRIBUTES, ASO_PRICE_ADJUSTMENTS — child detail, qualifier, and adjustment tables keyed on QUOTE_LINE_ID.
• ASO_SHIPMENTS, ASO_TAX_DETAILS, ASO_PAYMENTS, ASO_SALES_CREDITS — downstream fulfillment, tax, payment, and credit records.
• ASO_LINE_RELATIONSHIPS (both QUOTE_LINE_ID and RELATED_QUOTE_LINE_ID), ASO_PARTY_RELATIONSHIPS, and ASO_QUOTE_PARTIES — relationship and party mapping structures.
• ASO_QUOTE_RELATED_OBJECTS and JAI_CRM_QUOTE_TAXES — cross-object associations and the JAI (localization) tax extension.

This web of foreign keys makes ASO_QUOTE_LINES_ALL the central transactional anchor of Order Capture, and any purge or archival routine must respect the full set of child references to avoid orphaned pricing, shipping, and tax records.