Search Results pon_cost_factors_vl




Overview
Explore in AI Chat

Overview

PON_COST_FACTORS_VL is a documented Oracle E-Business Suite view owned by the APPS schema within the PON (Sourcing) product family. It presents the details of cost factors and price elements in the session language, joining the base price element definition table to its translation table so that the NAME and DESCRIPTION columns are returned in the language of the current user session. The view is functionally a sibling of PON_PRICE_ELEMENT_TYPES_VL, with one deliberate difference: its WHERE clause excludes the price element whose PRICE_ELEMENT_TYPE_ID equals -10, which corresponds to the item price. As a result, PON_COST_FACTORS_VL exposes only the true cost factors and price components (such as freight, duty, or other acquisition cost elements) that a sourcing or negotiation document may reference, while filtering out the reserved item-price element. In Oracle EBS reporting and integration contexts, the view serves as a language-aware, read-only access point to sourcing cost factor metadata, allowing forms, concurrent programs, and external interfaces to retrieve consistent, translated cost factor definitions without directly querying the underlying base and translation tables.

Underlying Base Objects

The view is defined over two base objects, exposed to APPS through synonyms: PON_PRICE_ELEMENT_TYPES and PON_PRICE_ELEMENT_TYPES_TL. PON_PRICE_ELEMENT_TYPES is the primary transactional definition table that stores the attribute data for each price element/cost factor, including its trading partner, pricing basis, allocation basis, and cost classification attributes. PON_PRICE_ELEMENT_TYPES_TL is the translation table that holds the language-dependent NAME and DESCRIPTION values, keyed by PRICE_ELEMENT_TYPE_ID and LANGUAGE. The view joins these two sources on the common PRICE_ELEMENT_TYPE_ID column and restricts the translation row to the session language using the condition T.LANGUAGE = USERENV('LANG'). A second predicate, B.PRICE_ELEMENT_TYPE_ID <> -10, removes the item-price element. Because the view draws from a translation table and filters on USERENV('LANG'), the displayed text automatically adapts to the logged-in user's language preference.

Key Columns

The view exposes the following columns, as documented in the ETRM metadata:

Common Use Cases and Queries

Typical usage includes validating available cost factors before building sourcing or negotiation documents, populating LOVs in custom forms, and extracting translated cost factor metadata for integration or reporting. A basic retrieval of all enabled, session-language cost factors is:

  • SELECT price_element_type_id, name, price_element_code, pricing_basis FROM pon_cost_factors_vl WHERE enabled_flag = 'Y' ORDER BY name;

To isolate system-seeded versus user-defined elements:

  • SELECT price_element_type_id, name FROM pon_cost_factors_vl WHERE system_flag = 'Y';

To retrieve cost analysis attributes for landed-cost integration:

  • SELECT price_element_code, name, cost_component_class_id, cost_analysis_code FROM pon_cost_factors_vl WHERE enabled_flag = 'Y';

Because the view already excludes the item-price element and resolves text to the session language, developers can rely on it directly for list-of-values queries and read-only reporting without reapplying the language join or the exclusion predicate.