Search Results pon_system_fields_values_v




Overview
Explore in AI Chat

Overview

PON_SYSTEM_FIELDS_VALUES_V is an APPS-owned database view in the Oracle E-Business Suite Sourcing (PON) module. It exposes the resolved values of the system fields that appear on a Negotiation (auction) entry form, so that the header-level attributes of a sourcing document — organization, dates, payment terms, freight, currency, and display flags — can be queried in a single, denormalized row per negotiation. The view is documented as VALID and is deployed in both EBS 12.1.1 and 12.2.2.

Rather than requiring reporting or integration code to join the underlying transactional tables directly, the view performs all of the necessary lookups: document type translation, operating unit name resolution, payment term name lookup, freight carrier description, and the decoding of several FND lookup codes. This makes it suitable for extract, reporting, and interface programs that need to read the descriptive values of a negotiation without re-implementing the standard resolution logic.

The presence of AP_TERMS_VL in the FROM clause is why a search for the term "ap_terms_vl" surfaces this object: the payment terms attribute of the negotiation header (PAYMENT_TERMS_ID) is resolved to a human-readable name through the AP_TERMS_VL view, joining on TERM_ID with the outer-join (+) syntax.

Underlying Base Objects

The view is defined over a mix of base tables, synonyms, translation views, and PL/SQL utilities. The documented base objects are: AP_TERMS_VL (VIEW), FINANCIALS_SYSTEM_PARAMS_ALL (SYNONYM), FND_LOOKUP_VALUES (SYNONYM), HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM), HR_GENERAL (PACKAGE), HR_LEGAL_ENTITIES (VIEW), HR_SECURITY (PACKAGE), PER_BUSINESS_GROUPS (VIEW), PON_AUCTION_HEADERS_ALL (SYNONYM), PON_AUC_DOCTYPES (SYNONYM), PON_AUC_DOCTYPES_TL (SYNONYM), PON_CONTERMS_UTL_PVT (PACKAGE), PON_FORMS_UTIL_PVT (PACKAGE), and PON_LOCALE_PKG (PACKAGE).

PON_AUCTION_HEADERS_ALL is the driving table and supplies the negotiation header record. PON_AUC_DOCTYPES and its translation table PON_AUC_DOCTYPES_TL resolve the internal negotiation type and its translated name. HR_ALL_ORGANIZATION_UNITS_TL provides the operating unit name, translated by the session language. AP_TERMS_VL resolves the payment terms name, FND_LOOKUP_VALUES resolves the bid visibility, FOB, and freight terms codes, and FINANCIALS_SYSTEM_PARAMS_ALL supplies the inventory organization for the freight carrier lookup. The PON_FORMS_UTIL_PVT package provides the GET_FREIGHT function used to derive the carrier description; HR_GENERAL, HR_SECURITY, PER_BUSINESS_GROUPS, HR_LEGAL_ENTITIES, PON_CONTERMS_UTL_PVT, and PON_LOCALE_PKG support organization security and localization.

Key Columns

Common Use Cases and Queries

Typical uses include negotiation status reporting, payment terms auditing, and integration feeds. A simple extract follows.

  • List negotiations with their payment terms and buyer:
    SELECT negotiation_num, title, buyer, payment_terms_name FROM pon_system_fields_values_v WHERE organization_name = :org;
  • Find open negotiations by close date: SELECT negotiation_num, open_date, close_date FROM pon_system_fields_values_v WHERE close_date > SYSDATE;
  • Audit freight and FOB terms: SELECT negotiation_num, carrier_name, fob_name, freight_terms_name FROM pon_system_fields_values_v;

Because the view already applies USERENV('LANG') to the translation joins, queries automatically return names in the session language. Organization security, however, is enforced by the calling application rather than by the view, so reports should filter on ORGANIZATION to respect operating unit access.