Results for “line_attribute_enabled_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PON_NEGOTIATION_STYLES_VL is a translation-enabled (VL) view owned by the APPS schema in Oracle E-Business Suite, belonging to the PON – Sourcing product family. Its documented purpose is to expose negotiation style name and description in the session language. Negotiation styles define the behavioral template applied to a sourcing negotiation — for example, whether line attributes, price elements, lots, groups, proxy bidding, or team scoring are enabled — and therefore drive both the user interface and the underlying business rules during negotiation creation and execution.

Because the view is language-aware, it resolves the name and description columns from the translation table using the session language rather than returning the base-language values. This makes it the appropriate source for reports, concurrent programs, and integration interfaces that must present negotiation style information in the language of the logged-in user. The view is documented as VALID, and it is available in both 12.1.1 and 12.2.2 releases of Oracle EBS; the documented ETRM metadata is drawn from the 12.2.2 repository.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as synonyms in the APPS schema:

• PON_NEGOTIATION_STYLES — the base (non-translated) table holding the style definition, including the STYLE_ID primary key, the STATUS flag, the SYSTEM_FLAG, and the full set of feature enablement indicators.
• PON_NEGOTIATION_STYLES_TL — the translation table holding STYLE_NAME and DESCRIPTION per language.

The join condition links B.STYLE_ID to T.STYLE_ID and filters T.LANGUAGE = USERENV('LANG'), so exactly one translation row per style is returned, matching the current session language. The view therefore behaves as a thin, read-only presentation layer over the base and translation tables, combining descriptive text with the complete set of configuration flags.

Key Columns

• STYLE_ID — primary identifier of the negotiation style; the join key between the base and translation tables.
• STYLE_NAME, DESCRIPTION — translated descriptive text in the session language.
• STATUS — indicates whether the style is active or inactive; inactive styles are typically excluded from selection lists.
• SYSTEM_FLAG — distinguishes seeded system-defined styles from user-defined styles. This is the column most directly associated with the search term "system_flag," and it is the principal filter used to prevent modification or deletion of Oracle-supplied styles.
• Feature enablement flags — LINE_ATTRIBUTE_ENABLED_FLAG, LINE_MAS_ENABLED_FLAG, PRICE_ELEMENT_ENABLED_FLAG, RFI_LINE_ENABLED_FLAG, LOT_ENABLED_FLAG, GROUP_ENABLED_FLAG, LARGE_NEG_ENABLED_FLAG, HDR_ATTRIBUTE_ENABLED_FLAG, NEG_TEAM_ENABLED_FLAG, PROXY_BIDDING_ENABLED_FLAG, POWER_BIDDING_ENABLED_FLAG, AUTO_EXTEND_ENABLED_FLAG, TEAM_SCORING_ENABLED_FLAG, and QTY_PRICE_TIERS_ENABLED_FLAG. Each controls whether the corresponding capability is available for negotiations created with that style.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include populating negotiation style list-of-values displays, driving conditional logic in custom forms or OAF pages, and producing configuration reports that document which features are enabled per style.

To list all active, system-defined styles in the session language:

• SELECT style_id, style_name, description FROM apps.pon_negotiation_styles_vl WHERE status = 'ACTIVE' AND system_flag = 'Y';

To identify styles with proxy bidding enabled:

• SELECT style_name, status, system_flag FROM apps.pon_negotiation_styles_vl WHERE proxy_bidding_enabled_flag = 'Y';

Because the view already restricts rows to the session language, callers should not add an additional language predicate; use PON_NEGOTIATION_STYLES_TL directly when cross-language extraction is required.