Search Results icx_quote_lines_v

Overview

ICX_QUOTE_LINES_V is a reporting view in the Oracle iProcurement (ICX) module of Oracle E-Business Suite, documented for releases 12.1.1 and 12.2.2. The ETRM metadata describes the object with the annotation "Retrofitted" and records its implementation status as "Not implemented in this database." This indicates that the view is a legacy artifact carried forward from an earlier release, most likely originating in an Oracle Advanced Pricing or Oracle Quoting context and retrofitted into the iProcurement schema for backward compatibility. In practice, the view is best understood as a pricing quotation line wrapper rather than a native iProcurement shopping construct.

The view presents one row per quote line, exposing pricing, discounting, tax, and item descriptive attributes. Its primary role in EBS reporting and integration is to provide a denormalized, query-friendly projection of quote line data that joins item and unit-of-measure information inline, sparing consumers from repeatedly resolving foreign keys against Oracle Inventory and pricing base tables.

Underlying Base Objects

The ETRM metadata documents no explicit referenced base objects for the 12.2.2 release. However, the embedded view text reveals the driving table and joins clearly:

• AS_QUOTE_LINES — the primary source table. All transactionally significant columns, including QUOTE_LINE_ID, QUOTE_ID, PRICE_LIST_LINE_ID, LINE_QUOTE_PRICE, and the PRICING_ATTRIBUTE1–13 flexfields, derive from this table.
• MSI (MTL_SYSTEM_ITEMS) — joined to retrieve CONCATENATED_SEGMENTS as ITEM_NAME and DESCRIPTION as ITEM_DESCRIPTION.
• UOM (unit of measure reference) — joined on UOM_CODE to return the UNIT_OF_MEASURE description.

The view also carries the standard EBS WHO columns — ROW_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — which support audit and concurrent-program lineage reporting.

Key Columns

• QUOTE_LINE_ID / QUOTE_ID — primary identifier of the line and its parent quotation header.
• INVENTORY_ITEM_ID, ITEM_NAME, ITEM_DESCRIPTION — item identity and descriptive text resolved from MTL_SYSTEM_ITEMS.
• LINE_QUOTE_PRICE, LINE_LIST_PRICE, CURRENCY_CODE — quoted and list pricing with currency context.
• LINE_DISCOUNT_AMOUNT, LINE_DISCOUNT_PERCENT, LINE_DISCOUNT_MTHD_CODE, DISCOUNT_ID, DISCOUNT_LINE_ID — discounting detail, including modifier linkage.
• QUANTITY, UOM_CODE, UNIT_OF_MEASURE — ordered quantity and its unit of measure.
• TAX_CODE, TAX_EXEMPT_NUM, TAX_EXEMPT_REASON_CODE — tax determination attributes.
• PRICING_CONTEXT and PRICING_ATTRIBUTE1–13 — the pricing descriptive flexfield context and segments.
• PARENT_LINE_ID, LEAD_LINE_ID, LINK_TO_LINE_ID, TOP_BILL_SEQUENCE_ID, GROUP_ID, SHIP_SET_NUMBER — structural and grouping lineage, including bill-of-material and shipment set associations.
• START_DATE_ACTIVE, END_DATE_ACTIVE — effective dating for the line.

The user's search term, "interest_category," does not appear among the documented columns of this view. Interest categories are typically associated with Oracle Purchasing or sourcing objects rather than quotation lines, so this view is unlikely to satisfy that query directly.

Common Use Cases and Queries

Typical scenarios include reconciling iProcurement requisition pricing against pre-negotiated quotation lines, auditing discount application by modifier, and extracting quote line detail for downstream price comparison reporting. Because the metadata reports the view as not implemented in the reference database, DBAs should verify its presence before relying on it.

• Validate existence: query ALL_VIEWS where VIEW_NAME = 'ICX_QUOTE_LINES_V'.
• Retrieve quote line pricing for a given quotation: SELECT quote_line_id, item_name, line_quote_price, currency_code FROM icx_quote_lines_v WHERE quote_id = :p_quote_id;
• Audit discounting: SELECT item_name, line_list_price, line_discount_percent, line_discount_mthd_code FROM icx_quote_lines_v WHERE discount_id IS NOT NULL;
• Inventory item lookup: SELECT inventory_item_id, item_name, item_description FROM icx_quote_lines_v WHERE inventory_item_id = :p_item_id;