Search Results pofv_quotations




Overview
Explore in AI Chat

Overview

POFV_QUOTATIONS is a Purchasing (PO) module view owned by the APPS schema and defined as VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated, report-ready projection of supplier quotation headers — the documents vendors return in response to a Request for Quotation (RFQ). The view inherits its name from the older Purchasing "PO Forms" (POFV) object family, and the ETRM record carries the description "- Retrofitted", indicating the object was carried forward from an earlier release with minimal change to support backward compatibility for external integrations, custom reports, and form-based lookups.

Functionally, the view isolates quotation records from the shared PO_HEADERS_ALL table by filtering on TYPE_LOOKUP_CODE = 'QUOTATION', then enriches each row with descriptive, human-readable values by joining organizations, currencies, terms, vendor master data, employees, and locations. This makes it suitable for inline LOV queries and reporting where code values alone would be insufficient.

Underlying Base Objects

The view is defined over the following documented base objects:

Documented metadata also lists FND_GLOBAL, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages as referenced dependencies, consistent with the view's use of security and name-formatting functions.

Key Columns

Common Use Cases and Queries

Typical uses include quotation registers, buyer workload reports, RFQ response tracking, and LOV population. A basic register query:

  • SELECT segment1, vendor_name, status_lookup_code, start_date, end_date FROM pofv_quotations WHERE org_id = :p_org;
  • SELECT segment1, vendor_name, reply_method_lookup_code, reply_date FROM pofv_quotations WHERE status_lookup_code = 'ACTIVE';
  • SELECT agent_id, full_name, COUNT(*) FROM pofv_quotations GROUP BY agent_id, full_name;

Because the view embeds lookup display and security logic, queries benefit from standard FND and HR session context being initialized before use.