Results for “okl_invc_line_types_tl_u1”

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

Overview

OKL.OKL_INVC_LINE_TYPES_TL is the translation (MLS) table for Oracle Lease and Finance Management (OKL) invoice line types in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the language-dependent descriptive attributes—specifically the NAME and DESCRIPTION of each invoice line type—while the language-independent attributes reside in the base table OKL_INVC_LINE_TYPES_B. The "_TL" suffix follows Oracle's standard Multi-Language Support convention, where each logical row in the base table is represented by one or more rows in the translation table, one per installed language. The table is owned by the OKL schema, has FND Design Data registered as OKL.OKL_INVC_LINE_TYPES_TL, and carries a VALID status. Because the table has no foreign key relationships to other database objects and is not referenced by any dependent objects, the heuristic Data Vault classification is standalone; in modeling terms it may be treated as a satellite-like descriptive table hanging off the OKL_INVC_LINE_TYPES_B hub.

Key Information Stored

The table contains eleven documented columns. The most significant are:

• ID (NUMBER) — Part of the surrogate primary key and the join key back to the base table OKL_INVC_LINE_TYPES_B. It identifies the invoice line type regardless of language.
• LANGUAGE (VARCHAR2(12)) — The language of the translated row; combined with ID, it forms the primary key OKL_INVC_LINE_TYPES_TL_PK and the unique index OKL_INVC_LINE_TYPES_TL_U1.
• SOURCE_LANG (VARCHAR2(12)) — The source language from which the translation was derived, used by MLS to track which language the base record was originally created in.
• NAME (VARCHAR2(150)) — The translated display name of the invoice line type; this is the business-key candidate reflected in the non-unique index OKL_INVC_LINE_TYPES_TL_U2 (NAME, LANGUAGE).
• DESCRIPTION (VARCHAR2(1995)) — The translated, user-entered description of the line type.
• SFWT_FLAG (VARCHAR2) — The flag column used by the translation batch program (a standard MLS seed/translation control column).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle WHO columns that provide audit and concurrency information for each translated row.

The surrogate primary key is ID plus LANGUAGE, while NAME plus LANGUAGE serves as the documented business-key candidate via the unique index pattern OKL_INVC_LINE_TYPES_TL_U2.

Common Use Cases and Queries

Reporting and inquiry on invoice line types in a specific language is the most common use case. A typical query joins the translation table to the base table and filters by LANGUAGE:

• Retrieve translated name and description for a given line type: SELECT tl.NAME, tl.DESCRIPTION FROM OKL.OKL_INVC_LINE_TYPES_TL tl, OKL.OKL_INVC_LINE_TYPES_B b WHERE tl.ID = b.ID AND tl.LANGUAGE = USERENV('LANG');
• List all languages available for a line type: SELECT ID, LANGUAGE, NAME FROM OKL.OKL_INVC_LINE_TYPES_TL WHERE ID = :line_type_id;
• Seed or audit translations: Query rows where SFWT_FLAG indicates an untranslated or seeded state, usually in conjunction with the MLS translation batch program.
• Resolve line type names in reports: Join through OKL_INVC_LINE_TYPES_B to invoice line fact tables so that user-facing labels respect the session language.

Because the table is standalone, no cascading joins are required beyond the base table link.

Related Objects

The documented dependencies for this object are limited; it does not reference any database object, and the only listed dependent is the APPS synonym OKL_INVC_LINE_TYPES_TL. The most significant related objects, anchored by the documented join column ID, are:

• OKL.OKL_INVC_LINE_TYPES_B — The base table holding language-independent invoice line type attributes; joined on ID. The translation columns are described as "translatable columns from OKL_INVC_LINE_TYPES_B, per MLS standards."
• APPS.OKL_INVC_LINE_TYPES_TL — The APPS synonym through which application code and concurrent programs access the table.
• OKL_INVC_LINE_TYPES_TL_U1 — The unique index on (ID, LANGUAGE) that enforces the MLS primary key and drives efficient lookup by line type and language.
• OKL_INVC_LINE_TYPES_TL_U2 — The non-unique index on (NAME, LANGUAGE) supporting name-based search and the documented business-key candidate.
• Invoice line transaction tables in the OKL schema — Tables such as invoice line headers and lines reference the line type ID, which resolves to this translation table for display names.

Consult the base table and the OKL invoice line type setup forms to obtain the complete functional context for this translation object.