Results for “aso_bi_quote_lines_all”

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

Overview

ASO_BI_QUOTE_LINES_ALL is a base table in the ASO (Order Capture) module of Oracle E-Business Suite, designed specifically to store quote line information for Daily Business Intelligence (DBI) reporting. Unlike the operational quote tables that drive transactional order capture workflows, this table serves as a denormalized reporting substrate. It aggregates quote header attributes together with line-level detail so that DBI dashboards, quote pipeline analytics, and sales performance reports can be satisfied with fewer joins and lower query cost.

ETRM metadata explicitly notes that the object is not implemented in the referenced database, meaning it exists in the data model but is populated only where the DBI collection process has run. From a modeling perspective, the mined foreign-key structure suggests the table behaves as a satellite-leaning structure — it carries descriptive and measured context about quote lines keyed to a surrounding hub/link network (quote header, customer, status, shipment), rather than acting as a pure transaction hub itself.

Key Information Stored

With 47 documented columns, the table combines header-level dimensions and line-level facts. The most significant include:

• QUOTE_LINE_ID — Line-level identifier; the primary business-key candidate for the line grain.
• QUOTE_HEADER_ID — Foreign key to ASO_QUOTE_HEADERS_ALL, establishing the quote header context.
• QUOTE_NUMBER, QUOTE_VERSION — Business-facing quote identifier and revision control.
• CUST_ACCOUNT_ID, CUST_PARTY_ID — Customer account and party references (FK to HZ_CUST_ACCOUNTS and HZ_PARTIES).
• QUOTE_STATUS_ID — FK to ASO_QUOTE_STATUSES_B; drives pipeline-stage reporting.
• SHIPMENT_ID — FK to ASO_SHIPMENTS, linking the line to fulfillment intent.
• INVENTORY_ITEM_ID, ORGANIZATION_ID — Item and inventory organization for product-level analysis.
• QUANTITY, UOM_CODE — Quoted quantity and unit of measure.
• LINE_VALUE, LINE_QUOTE_VALUE — Monetary measures for the line.
• CURRENCY_CODE, REPORTING_CURRENCY, FUNCTIONAL_CURRENCY — Multi-currency conversion context.
• SALES_CHANNEL_CODE — Channel dimension for segmentation.
• ORG_ID — Multi-org operating unit discriminator.
• QUOTE_CREATION_DATE, QUOTE_EXPIRATION_DATE — Temporal dimensions for aging and pipeline trends.

Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) follow standard EBS conventions.

Common Use Cases and Queries

Because the table is purpose-built for DBI, it is primarily consumed by reporting and analytics rather than OLTP processing. Typical patterns include open quote pipeline by status, win/loss trend analysis, and product mix reporting by channel and operating unit.

• Pipeline value by status: SELECT QUOTE_STATUS_ID, SUM(LINE_VALUE) FROM ASO_BI_QUOTE_LINES_ALL GROUP BY QUOTE_STATUS_ID
• Customer-level quote analysis joined to HZ_PARTIES on CUST_PARTY_ID.
• Item performance joined to inventory item master on INVENTORY_ITEM_ID and ORGANIZATION_ID.
• Currency-normalized reporting using REPORTING_CURRENCY and REPORTING_CONVERSION_RATE.
• Time-series trend of quote creation using QUOTE_CREATION_DATE.

Related Objects

• ASO_QUOTE_HEADERS_ALL — joined on QUOTE_HEADER_ID; header grain.
• ASO_QUOTE_STATUSES_B — joined on QUOTE_STATUS_ID; status lookup.
• ASO_SHIPMENTS — joined on SHIPMENT_ID; fulfillment linkage.
• HZ_CUST_ACCOUNTS — joined on CUST_ACCOUNT_ID; customer account context.
• HZ_PARTIES — joined on CUST_PARTY_ID; party master.
• Operational quoting APIs and DBI concurrent programs that refresh this table from ASO_QUOTE_LINES_ALL and related source tables.