Search Results po_document_types_all




Overview
Explore in AI Chat

Overview

APPS.POFV_QUOTATIONS is a Purchasing Foundation view that consolidates supplier quotation and RFQ response data stored in the Oracle E-Business Suite Purchasing module. In the ETRM metadata for 12.2.2, the view is owned by APPS and is defined over a substantial set of Purchasing, HR, Financials, and supplier master objects. Its purpose is to present quote header information together with the descriptive attributes required for reporting, forms, and integration purposes, avoiding the need for consumers to replicate the numerous joins to lookup, currency, terms, vendor, and location tables.

The view exposes quotation header identifiers, document numbers, supplier and supplier site details, buyer information, currency and conversion data, shipping and billing locations, terms, freight, and administrative attributes such as approval flags and sourcing behavior. Because the source query references PO_LOOKUP_CODES and AR_LOOKUPS through the '_LA' display convention, many columns are surfaced as user-readable descriptions rather than raw coded values, making the view well suited to operational reporting and inquiry screens.

Underlying Base Objects

The view is documented as being defined over the following referenced base objects: AP_TERMS (SYNONYM), FINANCIALS_SYSTEM_PARAMS_ALL (SYNONYM), FND_CURRENCIES_VL (VIEW), GL_DAILY_CONVERSION_TYPES (SYNONYM), HR_ALL_ORGANIZATION_UNITS (SYNONYM), HR_LOCATIONS (VIEW), MTL_PARAMETERS (SYNONYM), ORG_FREIGHT (SYNONYM), PER_PEOPLE_F (VIEW), PO_DOCUMENT_TYPES_ALL (SYNONYM), PO_HEADERS_ALL (SYNONYM), PO_VENDORS (VIEW), PO_VENDOR_CONTACTS (VIEW), and PO_VENDOR_SITES_ALL (VIEW). The metadata also lists package references including FND_GLOBAL, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY, which are used for organizational and security context.

The principal driving object is PO_HEADERS_ALL, aliased as QU, which holds the quotation header rows. Supplier data is joined from PO_VENDORS and PO_VENDOR_SITES_ALL, contacts from PO_VENDOR_CONTACTS, and buyer information from PER_PEOPLE_F. Document type descriptions are supplied by PO_DOCUMENT_TYPES_ALL, referenced twice as FT (from-document type) and QT (quotation type). Locations are resolved through HR_LOCATIONS, currency descriptions through FND_CURRENCIES_VL, conversion types through GL_DAILY_CONVERSION_TYPES, payment terms through AP_TERMS, and freight/ship-via data through ORG_FREIGHT and MTL_PARAMETERS.

Key Columns

Common Use Cases and Queries

The view supports quotation reporting, sourcing analysis, supplier response tracking, and integrations that need descriptive quotation data. Because it already joins PO_DOCUMENT_TYPES_ALL, it is a convenient substitute when reporting quotation types without querying PO_DOCUMENT_TYPES_ALL directly.

A typical query lists quotations for an operating unit with supplier and buyer detail:

SELECT segment1, vendor_name, vendor_site_code, full_name, currency_code, start_date, end_date FROM apps.pofv_quotations WHERE org_id = :p_org_id ORDER BY creation_date DESC;

Another common pattern filters by status or from-document type to reconcile RFQ-to-quote flows:

SELECT q.segment1, q.type_name, q.from_type_lookup_code, f.segment1 from_document FROM apps.pofv_quotations q WHERE q.auto_sourcing_flag = 'Y';

Because the view references secured HR and supplier objects, row visibility may be restricted by HR security and operating unit context, so queries should be run with an appropriate responsibility and org_id predicate.