Results for “part_name”
50+ 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
-
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.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_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 →
-
PACKAGE: CTXSYS.CTX_QUERY 12.1.1
-
PACKAGE: CTXSYS.CTX_DDL 12.2.2
-
PACKAGE: CTXSYS.CTX_QUERY 12.2.2
-
PACKAGE BODY: CTXSYS.DRVDISP 12.1.1
-
PACKAGE: CTXSYS.DRVDISP 12.2.2
-
PACKAGE BODY: CTXSYS.CTX_DDL 12.2.2
-
PACKAGE: CTXSYS.CTX_REPORT 12.1.1
-
PACKAGE: CTXSYS.CTX_REPORT 12.2.2
-
TABLE: XDB.XDB$XIDX_PART_TAB 12.2.2
-
PACKAGE: CTXSYS.CTX_DDL 12.1.1
-
TABLE: XDB.XDB$XIDX_PART_TAB 12.1.1
-
PACKAGE: CTXSYS.DRVDISP 12.1.1
-
PACKAGE: CTXSYS.CTX_QUERY 12.2.2
-
PACKAGE: CTXSYS.CTX_QUERY 12.1.1
-
PACKAGE BODY: CTXSYS.CTX_DDL 12.1.1
-
PACKAGE BODY: CTXSYS.DRVDISP 12.2.2
-
PACKAGE: CTXSYS.DRVDML 12.2.2
-
PACKAGE BODY: CTXSYS.DRIDISP 12.2.2
-
PACKAGE: CTXSYS.DRVDML 12.1.1
-
VIEW: IEM.IEM_MSG_PARTS# 12.2.2
-
PACKAGE BODY: CTXSYS.DRVDML 12.1.1
-
VIEW: IEM.IEM_MS_MSGPARTS# 12.2.2
-
PACKAGE BODY: CTXSYS.DRVDML 12.2.2
-
PACKAGE: CTXSYS.DRVDISP 12.1.1
-
PACKAGE: CTXSYS.DRVDISP 12.2.2
-
PACKAGE BODY: CTXSYS.DRIDISP 12.1.1
-
PACKAGE: CTXSYS.DRIDISP 12.1.1
-
PACKAGE: CTXSYS.DRIDISP 12.2.2
-
VIEW: IEM.IEM_MS_MSGPARTS# 12.2.2
-
VIEW: SYS.USER_AW_OBJ 12.2.2
-
VIEW: SYS.DBA_AW_OBJ 12.1.1