Search Results okl_quick_quote_lines_tl




Overview
Explore in AI Chat

Overview

OKL_QUICK_QUOTE_LINES_TL is the translation table for OKL_QUICK_QUOTE_LINES_B within the Oracle Leasing and Finance Management (OKL) module. In Oracle EBS Release 12.1.1 and 12.2.2, the OKL schema implements quote and quick-quote processing for lease and loan origination, and quick-quote line records represent the individual priced components (assets, services, fees, and terms) attached to a quick quote header. This object stores only the language-dependent, translatable attributes of those lines, while the base table OKL_QUICK_QUOTE_LINES_B retains the language-independent business data.

The ETRM documentation describes the object simply as holding translatable data of OKL_QUICK_QUOTE_LINES_B. Its heuristic Data Vault classification is standalone, meaning that the mined foreign-key structure does not associate it with a parent hub or link. From a modeling perspective, this classification suggests treating the table as a satellite-like extension whose grain is the combination of the line identifier and the language code, rather than as an independent hub.

Key Information Stored

  • ID — The surrogate identifier of the parent quick-quote line. Together with LANGUAGE it forms the primary key OKL_QQLT_PK, and it is also the leading column of the unique index OKL_QQLT_UC1.
  • LANGUAGE — The NLS language code for the row, the second component of both the primary key and the unique business-key candidate.
  • SOURCE_LANG — The language in which the source line text was originally entered, supporting the translation workflow.
  • SFWT_FLAG — The standard Oracle Applications "Seed/Force/Whatever/Translate" style flag used by the multi-language support (MLS) infrastructure to control how the row is maintained during language installation and the Translate function.
  • SHORT_DESCRIPTION — The short, translatable label for the quick-quote line as displayed on quote entry and selection screens.
  • DESCRIPTION — The longer, translatable description of the line item presented to users during quote preparation.
  • COMMENTS — Additional free-form translatable text associated with the line.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle Applications audit columns recording who created and last modified the row and when, plus the login identifier of the last updater.

The documented physical schema contains 12 columns in total. The ID is the surrogate reference to the owning line, while the unique index OKL_QQLT_UC1 (ID, LANGUAGE) is the business-key candidate that guarantees one translated row per line per language.

Common Use Cases and Queries

Reporting on quick-quote activity typically joins the base table to this translation table so that descriptive text appears in the session's language. A representative query retrieves the translated line text for a given quote:

  • SELECT b.id, t.short_description, t.description FROM okl.okl_quick_quote_lines_b b, okl.okl_quick_quote_lines_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
  • Filtering by t.language = USERENV('LANG') ensures only one translated row per line is returned, preventing duplication in the result set.
  • Maintenance of translations through the Oracle Applications Translate window updates SOURCE_LANG, SFWT_FLAG, and the text columns rather than the base table.
  • Data-quality and gap analysis reports compare counts between the base and translation tables to identify lines lacking a translation in a given installed language.
  • Audit extracts use CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE to trace when translated descriptions were introduced or changed.

Related Objects

  • OKL_QUICK_QUOTE_LINES_B — The base table holding language-independent line data; joined on ID.
  • OKL_QQLT_PK and OKL_QQLT_UC1 — The primary key and unique index defined on (ID, LANGUAGE) that enforce translation uniqueness.
  • OKL_QUICK_QUOTE_HEADERS_B and OKL_QUICK_QUOTE_HEADERS_TL — Header-level base and translation tables that provide the parent quick-quote context for each line.
  • FND_LANGUAGES — Reference table validating the LANGUAGE and SOURCE_LANG values.
  • FND_USER — Provides names for CREATED_BY and LAST_UPDATED_BY.

Because the table is classified as standalone, no documented foreign keys connect it to other OKL tables; relationships are established logically through the shared ID value with OKL_QUICK_QUOTE_LINES_B.