Search Results quotation_id




Overview
Explore in AI Chat

Overview

APPS.POFV_QUOTATION_LINES is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Purchasing (PO) module, owned by the APPS schema and registered under FND Design Data as PO.POFV_QUOTATION_LINES. It exposes item and price information for a good or service offered on a supplier quotation. In EBS 12.1.1 and 12.2.2 the view is delivered with a VALID status and is intended primarily for operational reporting, ad-hoc query, and integration extracts rather than for transactional processing.

The view consolidates supplier quotation line data with descriptive attributes denormalized from surrounding master data: operating unit, supplier item, item master, unit of measure, category, project and task, hazardous material classification, and the originating RFQ. Because the view flattens these relationships into a single projection, it is well suited for reporting tools and interface programs that need quotation line detail without constructing complex multi-table joins. A user searching for rfq_line_id will find that this identifier is exposed directly on the view, allowing quotation lines to be traced back to the RFQ line they respond to.

Underlying Base Objects

The documented referenced base objects underlying POFV_QUOTATION_LINES are:

These objects are referenced as synonyms, so the view resolves through the APPS synonyms to the underlying PO, MTL, HR, PA, and financials tables. The view does not persist data; it derives its result set at query time.

Key Columns

Core identifiers include QUOTATION_LINE_ID, LINE_NUMBER, QUOTATION_ID, and QUOTATION_DOCUMENT_NUMBER, which uniquely locate a quotation line. The RFQ relationship is carried by RFQ_ID, RFQ_DOCUMENT_NUMBER, RFQ_LINE_ID, and RFQ_LINE_NUMBER — the column set relevant to the search term rfq_line_id. Because a quotation can respond to multiple RFQ lines, RFQ_LINE_ID provides the granular link between the quotation and the specific RFQ line being quoted.

Commercial attributes include LINE_TYPE, ITEM_DESCRIPTION, UNIT_PRICE, MINIMUM_ORDER_QUANTITY, MAXIMUM_ORDER_QUANTITY, SUPPLIER_PRODUCT_NUMBER, and SUPPLIER_NOTE. Item and UOM context is supplied by ITEM_ID, ITEM_NUMBER, ITEM_REVISION, ITEM_ORGANIZATION_ID, ITEM_ORGANIZATION_CODE, CATEGORY_ID, UNIT_OF_MEASURE, UOM_CLASS, and UOM_DESCRIPTION. Project context is provided by PROJECT_ID, PROJECT_NAME, TASK_ID, and TASK_NAME. Hazard attributes are exposed via HAZARD_CLASS_ID, HAZARD_CLASS, UN_NUMBER_ID, and UN_NUMBER. Standard WHO columns (CREATED_BY, CREATED_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE) and financial terms such as RETAINAGE_RATE, PROGRESS_PAYMENT_RATE, MAX_RETAINAGE_AMOUNT, and RECOUPMENT_RATE complete the projection.

Common Use Cases and Queries

Typical uses include supplier quotation comparison reports, RFQ response analysis, price list extracts, and integration feeds into sourcing or contract systems. The following query retrieves quotation lines responding to a specific RFQ line:

  • SELECT quotation_document_number, line_number, item_number, unit_price, rfq_line_id FROM apps.pofv_quotation_lines WHERE rfq_line_id = :p_rfq_line_id;
  • SELECT quotation_document_number, item_number, unit_price, minimum_order_quantity, maximum_order_quantity FROM apps.pofv_quotation_lines WHERE rfq_document_number = :p_rfq_doc ORDER BY quotation_document_number, line_number;
  • SELECT project_name, task_name, item_number, unit_price FROM apps.pofv_quotation_lines WHERE project_id = :p_project_id;

Because the view is read-only and denormalized, it should not be used as a substitute for base tables in validation logic or concurrent programs that update quotation data. For reporting and extraction it provides a stable, supported interface across both EBS 12.1.1 and 12.2.2.