Results for “as_quote_lines_v”

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

Overview

The AS_QUOTE_LINES_V view is a Sales Foundation (AS) database object that exposes quotation line information within Oracle E-Business Suite. In the context of release 12.1.1 and 12.2.2, it belongs to the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / AS) module family, which manages quotations, price lists, discounts, and related sales documents. The view presents a denormalized, query-friendly projection of quotation lines, allowing reporting tools, concurrent programs, forms, and integration interfaces to retrieve quote line detail without navigating multiple base tables directly.

The view carries a rich set of columns covering identification, pricing, discounting, taxation, and contextual attribute data, reflecting the composite nature of a quotation line in EBS. Typical consumers include Oracle Reports, Discoverer workbooks, OBIEE/BI Publisher extracts, and custom PL/SQL that needs read-only access to quote lines. Because it is a view rather than a table, no DML should be performed against it; it inherits the security and integrity constraints of its underlying base tables.

Underlying Base Objects

According to the ETRM metadata, the documented referenced base objects for this view are none documented, and the implementation note states "Not implemented in this database." The view text, however, clearly selects from the base table AS_QUOTE_LINES, joined implicitly through its ROWID and primary key QUOTE_LINE_ID. In a standard EBS 12.1.1/12.2.2 installation, AS_QUOTE_LINES is the core transactional table storing individual quotation lines, with foreign keys to AS_QUOTE_HEADERS (via QUOTE_ID_INVENTORY_ITEM_ID/ORGANIZATION_ID reference inventory and item master structures, PRICE_LIST_LINE_ID references pricing entities, and DISCOUNT_ID/DISCOUNT_LINE_ID reference discount objects.

The view also exposes WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) that support audit and change-data-capture requirements.

Key Columns

• QUOTE_LINE_ID / QUOTE_ID — Primary key of the line and the owning quotation header.
• INVENTORY_ITEM_ID / ORGANIZATION_ID — Item and inventory organization context for the quoted product.
• LINE_QUOTE_PRICE / LINE_LIST_PRICE / CURRENCY_CODE — Quoted and list prices together with currency, central to pricing analysis.
• QUANTITY / UOM_CODE — Ordered quantity and unit of measure.
• LINE_DISCOUNT_AMOUNT / LINE_DISCOUNT_PERCENT / LINE_DISCOUNT_MTHD_CODE / DISCOUNT_ID / DISCOUNT_LINE_ID — Discount details applied to the line, enabling margin and promotion reporting.
• LINE_NUMBER / PARENT_LINE_ID / LINK_TO_LINE_ID / LEAD_LINE_ID / TOP_BILL_SEQUENCE_ID — Line hierarchy and sequencing, supporting configurable or bundled quotes.
• TAX_CODE / TAX_EXEMPT_NUM / TAX_EXEMPT_REASON_CODE / TAX_CODE_EDITED_FLAG — Tax determination and exemption data.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Effective dating for the line.
• PRICING_CONTEXT / PRICING_ATTRIBUTE1..14 — Pricing context and flexible descriptive attributes used by pricing engines. Note: interest_category as searched is not a native column of this view; users seeking "interest_category" typically find it in other AS/interest-related objects, while this view exposes pricing attributes that may map to such categorizations via PRICING_ATTRIBUTEn or PRICING_CONTEXT.
• WHO columns — REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE and standard audit fields.

Common Use Cases and Queries

Typical uses include quotation line reporting, pricing and discount analysis, integration extracts for CRM or order capture, and reconciliation of quote lines to price lists and discounts.

SELECT ql.QUOTE_ID, ql.QUOTE_LINE_ID, ql.LINE_NUMBER,
       ql.INVENTORY_ITEM_ID, ql.QUANTITY, ql.UOM_CODE,
       ql.LINE_QUOTE_PRICE, ql.CURRENCY_CODE,
       ql.LINE_DISCOUNT_PERCENT, ql.TAX_CODE
FROM   AS_QUOTE_LINES_V ql
WHERE  ql.QUOTE_ID = :p_quote_id
ORDER  BY ql.LINE_NUMBER;

A second pattern retrieves pricing context and attributes for integration into external pricing engines:

SELECT QUOTE_LINE_ID, PRICING_CONTEXT,
       PRICING_ATTRIBUTE1, PRICING_ATTRIBUTE2
FROM   AS_QUOTE_LINES_V
WHERE  TRUNC(LAST_UPDATE_DATE) >= TRUNC(SYSDATE) - 7;

Because the ETRM record notes the view is not implemented in the reference database, environments should verify its existence via ALL_VIEWS and inspect ALL_VIEW_COLUMNS before relying on it. When absent, equivalent data is obtained directly from AS_QUOTE_LINES and related AS tables.