Results for “damage_description”
44 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_ASSET_CNDTN_LNS_TL is the translation table for asset condition lines within the Oracle Lease and Finance Management (OKL) module. In Oracle EBS 12.1.1 and 12.2.2, it exists to satisfy Multi-Lingual Support (MLS) standards by holding the language-specific, translatable text associated with records stored in the base table OKL_ASSET_CNDTN_LNS_B. Only descriptive text columns are translated; the transactional and structural attributes remain in the base table.
The table resides in the OKL schema and is documented as a standalone object with respect to the mined foreign key structure. Applying Data Vault modeling heuristics, a standalone classification suggests this object is best treated as a satellite — it stores descriptive, attribute-level context (the translated narrative fields) that hangs off the base entity rather than introducing independent hub or link relationships. This is a modeling suggestion derived from the FK profile, not a mandated physical design.
Its primary key, OKL_ASSET_CNDTN_LNS_TL_PK, is composed of ID and LANGUAGE, which together uniquely identify each translated row for a given condition line in a given installed language.
Key Information Stored
The 13 documented columns fall into three functional groups: key identifiers, MLS control columns, and translated business text.
- ID — Surrogate identifier that ties the translated row back to the corresponding record in
OKL_ASSET_CNDTN_LNS_B. It is the first component of the composite primary key and the primary join column to the base table. - LANGUAGE — The installed Oracle language code for the translation. Together with
ID, it forms the primary keyOKL_ASSET_CNDTN_LNS_TL_PKand the unique indexOKL_ASSET_CNDTN_LNS_TL_U1 (ID, LANGUAGE), which is the documented business-key candidate. - SOURCE_LANG — Records the language of the source text from which the translation was derived, supporting MLS lineage.
- SFWT_FLAG — The standard MLS "seed from a translated source" or translation-status flag used to control how the row behaves in the translation workflow.
- DAMAGE_DESCRIPTION, CLAIM_DESCRIPTION, RECOMMENDED_REPAIR, PART_NAME — The translatable business columns. These carry the user-facing condition text describing damage, the associated claim narrative, recommended repair actions, and the affected part name.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns providing audit and concurrency information for each translated record.
The distinction is important: ID and LANGUAGE together form the true business-key candidate via the unique index, while the primary key constraint enforces the same combination. The remaining columns carry descriptive or audit data with no independent uniqueness.
Common Use Cases and Queries
Because translated text must be resolved against the base table, the most common pattern is a join restricted to the session language. Standard MLS practice uses NLS_TERRITORY/LANGUAGE filtering, but a direct join on ID and LANGUAGE is typical for reporting.
A representative query retrieving condition text in a specific language:
SELECT b.id, t.damage_description, t.claim_description, t.recommended_repair, t.part_nameFROM okl_asset_cndtn_lns_b b, okl_asset_cndtn_lns_tl tWHERE b.id = t.id AND t.language = USERENV('LANG')
Reporting use cases include asset condition assessments, damage and claim analysis for leased equipment, repair recommendation reports, and multi-language user interfaces where the condition narrative must be rendered in the operator's language. A typical multilingual audit query groups translated rows by LANGUAGE to verify coverage across installed languages.
Related Objects
- OKL_ASSET_CNDTN_LNS_B — The base table holding the non-translatable columns. Joined on
ID = ID; this is the primary parent for the translation satellite. - OKL_ASSET_CNDTN_LNS_TL_PK / OKL_ASSET_CNDTN_LNS_TL_U1 — The primary key constraint and unique index enforcing uniqueness on
(ID, LANGUAGE). - FND_LANGUAGES — Provides valid installed language codes referenced by
LANGUAGE. - OKL_ASSET_CNDTN_HDRS / related OKL asset condition header objects — Logically related condition entities within the OKL condition framework that share the asset condition context.
- FND_USER — Resolves
CREATED_BY,LAST_UPDATED_BY, andLAST_UPDATE_LOGINaudit references.
Because the table is classified as standalone, no direct foreign keys to other transactional entities are documented; relationships are primarily logical joins to the base table and language reference data.
-
Translatable columns from OKL_ASSET_CNDTN_LNS_B, per MLS standards
-
View: OKL_ASSET_CNDTN_LNS_V 12.2.2
The line of a condition report detailing the item description and damage
APPS.OKL_ASSET_CNDTN_LNS_V·↳ OKL_ASSET_CNDTN_LNS_B·↳ OKL_ASSET_CNDTN_LNS_TL·Explore OKL module →
-
APPS.OKL_INS_CLAIM_ASSETS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_LINES_B·Explore OKL module →
-
APPS.OKL_INS_CLAIM_ASSETS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_LINES_B·Explore OKL module →
-
Translatable columns from OKL_ASSET_CNDTN_LNS_B, per MLS standards
-
APPS.OKL_AM_ASSET_CNDTN_LNS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_ASSET_CNDTNS·Explore OKL module →
-
View: OKL_ASSET_CNDTN_LNS_V 12.1.1
The line of a condition report detailing the item description and damage
APPS.OKL_ASSET_CNDTN_LNS_V·↳ OKL_ASSET_CNDTN_LNS_B·↳ OKL_ASSET_CNDTN_LNS_TL·Explore OKL module →
-
APPS.OKL_AM_ASSET_CNDTN_LNS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_ASSET_CNDTNS·Explore OKL module →
-
VIEW: SYS.V_$HM_FINDING 12.2.2
-
VIEW: SYS.V_$HM_FINDING 12.1.1
-
VIEW: SYS.GV_$HM_FINDING 12.1.1
-
VIEW: SYS.V_$HM_FINDING 12.1.1
-
VIEW: SYS.GV_$HM_FINDING 12.1.1
-
VIEW: SYS.GV_$HM_FINDING 12.2.2
-
VIEW: SYS.V_$HM_FINDING 12.2.2
-
VIEW: SYS.GV_$HM_FINDING 12.2.2
-
PACKAGE: APPS.OKL_ACN_PVT 12.1.1
-
PACKAGE: APPS.OKL_ACN_PVT 12.2.2
-
eTRM - OKL Tables and Views 12.1.1
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
eTRM - OKL Tables and Views 12.2.2
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards