Search Results hide_terms_flag




Overview
Explore in AI Chat

Overview

APPS.PON_NEGOTIATION_STYLES_VL is a bilingual (VL, "_Variant List") view in Oracle E-Business Suite that exposes the negotiation style definitions used by Oracle Sourcing and the Oracle Procurement family of applications. Negotiation styles are reusable configuration profiles that determine which features are enabled when a buyer creates an RFQ, RFI, or auction. Each row in the view represents one negotiation style combined with its translated name and description for the session language.

Because the view joins the base transaction table to its translation table and filters on USERENV('LANG'), it presents only the single, session-appropriate language row per style. This makes it the standard access point for reports, concurrent programs, personalizations, and integration interfaces that need a clean, language-resolved list of negotiation styles rather than the raw multilingual tables.

The view is central to the user's search term QTY_PRICE_TIERS_ENABLED_FLAG, which indicates whether quantity-based price tier (volume/quantity price break) functionality is enabled for a given negotiation style.

Underlying Base Objects

The view is defined in the APPS schema and is built over two referenced base objects, both exposed through synonyms:

The two are joined on B.STYLE_ID = T.STYLE_ID, with the additional predicate T.LANGUAGE = USERENV('LANG'). The VL suffix reflects this translation-aware design: the underlying entities follow the standard Oracle MLS (Multi-Language Support) pattern of a base table plus a "_TL" translation table, and the "_VL" view collapses them into one language-filtered result set.

Key Columns

The view projects the full functional flag set plus identity and audit columns. Principal columns include:

Common Use Cases and Queries

The view is typically queried to inspect or report on negotiation style configuration, to verify whether a specific capability (such as quantity price tiers) is enabled, and by integration routines that must map style behavior to external systems.

SELECT style_id, style_name, status, qty_price_tiers_enabled_flag
FROM   apps.pon_negotiation_styles_vl
WHERE  UPPER(style_name) LIKE '%AUCTION%';
SELECT style_id, style_name
FROM   apps.pon_negotiation_styles_vl
WHERE  qty_price_tiers_enabled_flag = 'Y'
AND    status = 'ACTIVE';
SELECT style_name, system_flag,
       price_element_enabled_flag, line_attribute_enabled_flag,
       lot_enabled_flag, group_enabled_flag,
       qty_price_tiers_enabled_flag
FROM   apps.pon_negotiation_styles_vl;

Because the view already resolves the session language, callers avoid joining PON_NEGOTIATION_STYLES_TL directly and rely on the view for consistent, language-correct results.