Results for “pon_price_element_types_tl”

50+ results




Overview
Explore in AI Chat

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

Overview

The PON_PRICE_ELEMENT_TYPES_TL table is a translation (TL) table within the PON (Sourcing) product schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the language-specific descriptive details for price element types used in Oracle Sourcing and related procurement negotiation flows. Price element types define the individual cost, charge, or pricing components that suppliers and buyers attach to negotiation lines, quotations, and sourcing events, such as freight, tariff, or discount components. Because these business entities require multilingual display, the underlying definitions are held in a base table (PON_PRICE_ELEMENT_TYPES) while the human-readable attributes — specifically the name and description — are stored here, keyed by language.

From a dimensional modeling perspective, the metadata classifies this object as satellite-leaning. In Data Vault terms, this is a heuristic suggestion: the translation table behaves like a satellite attached to the base PON_PRICE_ELEMENT_TYPES hub, where language acts as an additional descriptive qualifier rather than an independent business entity. Each row augments the base price element type definition with localized text.

Key Information Stored

The table contains eleven documented columns. The most significant are described below.

  • PRICE_ELEMENT_TYPE_ID — the surrogate identifier linking each translation row to its parent definition in PON_PRICE_ELEMENT_TYPES. It forms part of the composite primary key.
  • LANGUAGE — the language code for the localized text; the second component of the composite primary key.
  • NAME — the translated display name of the price element type; uniquely indexed via the functional index PON_PRICE_ELEMENT_TYPES_TL_U2 on UPPER("NAME"), making it a business-key candidate.
  • DESCRIPTION — the translated longer description of the price element type.
  • SOURCE_LANG — the source language from which the translation originated, supporting the standard EBS multilanguage framework.
  • TRADING_PARTNER_ID — an organizational/partner context identifier associated with the definition.
  • ZD_EDITION_NAME — an edition-designator column included in the unique index PON_PRICE_ELEMENT_TYPES_TL_U1, part of EBS's editioning and online-patching infrastructure.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard EBS audit columns capturing who created and last modified each translation row and when.

The primary key PON_PRICE_ELEMENT_TYPES_TL_PK is composite, spanning PRICE_ELEMENT_TYPE_ID and LANGUAGE. The business-key candidates are captured by PON_PRICE_ELEMENT_TYPES_TL_U1 (ID, language, edition) and PON_PRICE_ELEMENT_TYPES_TL_U2 (uppercased name).

Common Use Cases and Queries

Typical usage retrieves the localized name and description for one or all price element types, usually joined back to the base table and filtered by the session language.

A common reporting pattern resolves the translation for a specific language:

  • Join PON_PRICE_ELEMENT_TYPES_TL to PON_PRICE_ELEMENT_TYPES on PRICE_ELEMENT_TYPE_ID and filter LANGUAGE = USERENV('LANG') to return the current session's text.
  • Query by UPPER(NAME) to locate a price element type by its display name, leveraging the _TL_U2 index.
  • Audit queries examining CREATED_BY and LAST_UPDATED_BY to track translation maintenance.
  • Multilingual reporting that lists all languages available for each price element type by grouping on PRICE_ELEMENT_TYPE_ID.

Because translation tables can hold multiple rows per entity (one per installed language), queries intended for single-language output must always constrain LANGUAGE to avoid row multiplication.

Related Objects

The following objects are most significant in relation to this table:

  • PON_PRICE_ELEMENT_TYPES — the base (non-translated) table; referenced via foreign key on PRICE_ELEMENT_TYPE_ID. This is the primary join partner.
  • PON_PRICE_ELEMENT_TYPES_TL_PK — the composite primary key constraint on PRICE_ELEMENT_TYPE_ID and LANGUAGE.
  • PON_PRICE_ELEMENT_TYPES_TL_U1 — unique index over ID, language, and edition name.
  • PON_PRICE_ELEMENT_TYPES_TL_U2 — functional unique index on UPPER("NAME"), supporting name-based lookups.
  • Standard EBS multilanguage views layered over PON Sourcing price element functionality, which expose translated text to the application.

Developers integrating with Sourcing should treat this table as the authoritative source of localized price element type text and always route writes through supported APIs rather than direct DML.