Results for “line_extension_id”

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

Overview

The OKL_EXT_AP_LINE_SOURCES_TL table resides in the OKL schema, which supports the Oracle Leasing and Finance Management (OKL) product within Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is a translation (TL) table that stores language-specific descriptive text for externally sourced accounts payable line component sources used by the OKL Leasing application. Translation tables in EBS carry one row per language for each business entity, enabling multilanguage deployments to present the same underlying record in multiple installed languages.

The table is composed of 13 documented columns and is uniquely identified by the primary key OKL_EXT_AP_LINE_SOURCES_TL_PK, defined on the combination of LINE_EXTENSION_ID and LANGUAGE. A unique index, OKL_EXT_AP_LINE_SRCS_TL_U1, is also defined on the same two-column combination, confirming that (LINE_EXTENSION_ID, LANGUAGE) is the effective business key. Under the heuristic Data Vault classification mined from the foreign-key structure, this object is treated as standalone; from a modeling perspective, it behaves as a satellite attached to the LINE_EXTENSION_ID hub, capturing the language-dependent descriptive attributes of each AP line source.

Key Information Stored

The most significant columns fall into three groups: identification, translated attributes, and audit columns.

• LINE_EXTENSION_ID — surrogate identifier forming the first component of the composite primary key; links each translation row to its base business record.
• LANGUAGE — the installed language code, the second component of the composite primary key.
• SOURCE_LANG — the source language of the translated text, supporting EBS multilanguage semantics.
• SFWT_FLAG — the standard "seed format" indicator used by EBS translation tooling to track translation status.
• INVENTORY_ORG_NAME — translated name of the inventory organization associated with the AP line source.
• INVENTORY_ITEM_NAME — translated name of the inventory item associated with the AP line source.
• STREAM_TYPE_NAME — translated name of the stream type classification for the line source.
• TRANS_LINE_DESCRIPTION — free-form translated description of the transaction line.
• CREATED_BY, CREATION_DATE — standard EBS audit columns for row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns capturing the last modification.

The surrogate primary key components (LINE_EXTENSION_ID, LANGUAGE) may not be directly meaningful to end users, whereas the business-key unique index OKL_EXT_AP_LINE_SRCS_TL_U1 enforces that no two rows share the same line extension and language pair.

Common Use Cases and Queries

This table is most often queried to display translated descriptions for externally sourced AP line records in leasing transactions. A typical reporting pattern joins the translation table to its base table on LINE_EXTENSION_ID and restricts by LANGUAGE.

SELECT t.line_extension_id,
       t.language,
       t.inventory_item_name,
       t.stream_type_name,
       t.trans_line_description
FROM   okl.okl_ext_ap_line_sources_tl t
WHERE  t.language = USERENV('LANG')
AND    t.line_extension_id = :p_line_extension_id;

Common scenarios include multilingual invoice and lease line reporting, resolving descriptive names for inventory items and organizations on AP-sourced lease lines, and auditing translation coverage by comparing SFWT_FLAG values. Analysts frequently aggregate description counts by LANGUAGE to confirm translations exist for every supported language.

Related Objects

The following objects typically reference or depend on OKL_EXT_AP_LINE_SOURCES_TL through the LINE_EXTENSION_ID key.

• OKL_EXT_AP_LINE_SOURCES_B — the base table holding non-translatable attributes; join on LINE_EXTENSION_ID.
• OKL_EXT_AP_LINE_SOURCES_TL_PK — primary key constraint enforcing uniqueness on (LINE_EXTENSION_ID, LANGUAGE).
• OKL_EXT_AP_LINE_SRCS_TL_U1 — unique index reinforcing the business key.
• OKL_TRX_AP_LINES / OKL_AP_LINE_SOURCES — related lease and AP line tables referencing line extensions.
• FND_LANGUAGES — validates the LANGUAGE column values.
• INV_ORG_NAMES / MTL_SYSTEM_ITEMS_TL — source context for the inventory organization and item names carried here.

Direct SQL against this table should be reserved for reporting; transactional maintenance is performed through the OKL Leasing application user interface and its associated APIs.