Search Results max_quote_version

Overview

ASO.ASO_BI_LINE_IDS is a staging and batch-control table residing in the APPS_TS_INTERFACE tablespace within the Oracle EBS ASO (Quoting) schema. Its principal function is to divide quote lines into manageable batches for incremental collection. The batch size is governed by the profile option BIS_TXN_COMPLEXITY_LOW, allowing the collection process to be tuned for transaction complexity and system load. The table carries an FND Design Data designation of ASO.ASO_BI_LINE_IDS and has a status of VALID in the ETRM repository.

From a Data Vault modeling perspective, the mined FK structure classifies this object as standalone. Heuristically, the presence of QUOTE_HEADER_ID and QUOTE_LINE_ID as identifiers, together with descriptive attributes such as QUOTE_NUMBER, MAX_QUOTE_VERSION, and QUOTE_CREATION_DATE, suggests that this table behaves most like a link-style construct connecting quote headers to quote lines while carrying an enrichment attribute (BATCH_ID). It is not a true hub, since it introduces no independent business key of its own, and not a pure satellite, since it holds multiple related entity references. In 12.1.1 and 12.2.2, it functions as an interface-side control table rather than an OLTP master.

Key Information Stored

The table contains six documented columns. The most significant are described below.

• QUOTE_HEADER_ID (NUMBER) — Unique identifier for the highest version of a quote. This is a foreign-key candidate referencing ASO.ASO_QUOTE_HEADERS_ALL and serves as the primary join key back into the quoting model.
• QUOTE_LINE_ID (NUMBER) — Unique identifier of a quote line, providing the line-level grain needed for batch segmentation.
• QUOTE_NUMBER (NUMBER) — Business-facing quote number, useful for user-oriented reporting and reconciliation.
• MAX_QUOTE_VERSION (NUMBER) — Highest quote version. This column is the direct answer to the search term "max_quote_version" and drives version-aware batch selection.
• QUOTE_CREATION_DATE (DATE) — Creation date of the first version of the quote, supporting date-range filtering and incremental collection windows.
• BATCH_ID (NUMBER) — Unique identifier of the batch used in incremental collection of lines. This is the operative control attribute for the batching mechanism.

No explicit surrogate primary key or unique index is documented for this object; QUOTE_HEADER_ID combined with QUOTE_LINE_ID forms the practical composite key at the line grain. Storage is configured with PCTFREE 10 in APPS_TS_INTERFACE.

Common Use Cases and Queries

The primary use case is incremental collection of quote lines, where the collection program reads rows from this table in BATCH_ID order and processes each batch independently. A representative query filters by quote version and batch:

• SELECT QUOTE_HEADER_ID, QUOTE_NUMBER, MAX_QUOTE_VERSION, QUOTE_LINE_ID, BATCH_ID FROM ASO.ASO_BI_LINE_IDS WHERE MAX_QUOTE_VERSION = :p_version;
• SELECT BATCH_ID, COUNT(*) FROM ASO.ASO_BI_LINE_IDS GROUP BY BATCH_ID ORDER BY BATCH_ID;
• Retrieving the highest version per quote for reconciliation: SELECT QUOTE_NUMBER, MAX(MAX_QUOTE_VERSION) FROM ASO.ASO_BI_LINE_IDS GROUP BY QUOTE_NUMBER;

Reporting scenarios include monitoring batch distribution, validating that every quote line has been assigned a BATCH_ID, and auditing the version spread across quotes created within a date window using QUOTE_CREATION_DATE.

Related Objects

The documented dependency indicates that ASO.ASO_BI_LINE_IDS references ASO.ASO_QUOTE_HEADERS_ALL through QUOTE_HEADER_ID, and that the APPS synonym ASO_BI_LINE_IDS depends on this table. The most significant related objects are therefore:

• ASO.ASO_QUOTE_HEADERS_ALL — header master, joined on QUOTE_HEADER_ID.
• ASO.ASO_QUOTE_LINES_ALL — line master, joined on QUOTE_LINE_ID.
• APPS.ASO_BI_LINE_IDS — the APPS-layer synonym exposing this table.
• ASO.ASO_QUOTE_HEADERS — header view layer for versioned header access.
• BIS_TXN_COMPLEXITY_LOW profile — governs the batch size applied to BATCH_ID generation.

Collectively these objects support the incremental quote collection and batch orchestration flow within Oracle Quoting.