Search Results inventory_item

Overview

AST_LS_QUOTES_LINES_V is a reporting view within the Oracle E-Business Suite TeleSales (AST) module, which forms part of the broader ETRM (Enterprise Telecommunications Resource Management / Advanced Sales) family of applications. The view presents a streamlined projection of quote line information, combining quote line attributes from the Oracle Advanced Sales Online (ASO) quote line entity with descriptive item information sourced from the item master. Its principal role is to expose a user-readable representation of quote lines — pairing the internal identifiers used by the sales quoting engine with the human-recognizable inventory item number and description.

In Oracle EBS 12.1.1 and 12.2.2, the view is primarily intended for reporting, inquiry screens, and integration scenarios where a compact, read-only snapshot of quote lines is required. It is not a base transaction table; it is documented as "Not implemented in this database" for the ETRM environment described in the metadata, meaning the definition is provided for reference and may exist only where the TeleSales / Advanced Sales modules are licensed and deployed. The view carries the Oracle Proprietary, Confidential Information designation.

Underlying Base Objects

The view text is defined as an inner join between two underlying objects:

• ASO_QUOTE_LINES_ALL — aliased as QUOTE_LINES, this is the primary base table holding quote line records. The join is driven by a targeted hint, /*+ INDEX(QUOTE_LINES) */, encouraging index-based access on the quote lines table.
• ASO_I_ITEMS_V — aliased as ITEMS, this is an items view (the "I" prefix indicating an internal items interface view) supplying the item segment and description used to translate the numeric inventory item identifier into a displayable value.

The relationship between the two objects is enforced by a two-key join: QUOTE_LINES.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID combined with QUOTE_LINES.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID. This organization-scoped join ensures that the item attributes returned are those valid for the inventory organization in which the quote line is defined.

Key Columns

The view exposes a focused set of columns that support identification, linkage, and descriptive reporting:

• ROW_ID — the ROWID of the underlying ASO_QUOTE_LINES_ALL record, useful for high-performance direct addressing of the source row.
• QUOTE_LINE_ID — the unique surrogate identifier of the quote line; the primary join key back to the base quote line entity.
• QUOTE_HEADER_ID — the identifier of the parent quote header, enabling grouping of all lines belonging to a single quote.
• INVENTORY_ITEM_ID — the internal numeric identifier of the inventory item referenced by the quote line.
• INVENTORY_ITEM — the item's segment value (SEGMENT1), representing the user-facing item number.
• DESCRIPTION — the item description, providing readable context for reporting and inquiry.

Common Use Cases and Queries

Typical uses include reporting all lines of a given quote, resolving item numbers and descriptions for printed or on-screen output, and feeding downstream integrations that require quote-to-item mappings. A representative query retrieves all lines for a specific quote header:

• SELECT quote_line_id, quote_header_id, inventory_item, description FROM ast_ls_quotes_lines_v WHERE quote_header_id = :header_id ORDER BY quote_line_id;
• SELECT inventory_item, description, COUNT(*) FROM ast_ls_quotes_lines_v GROUP BY inventory_item, description; — to analyze item frequency across quotes.
• SELECT ql.quote_line_id, ql.inventory_item, ql.description FROM ast_ls_quotes_lines_v ql, aso_quote_headers_all qh WHERE ql.quote_header_id = qh.quote_header_id; — to join line detail with header-level attributes.

Because the view reflects only quote lines whose inventory item resolves to a valid, organization-specific item record, it is best suited to inquiry and reporting rather than to authoritative data maintenance.