Results for “tcl_type”

50+ results




Overview
Explore in AI Chat

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

Overview

OKL_CMN_EXTRACT_LINE_V is a reporting and integration view owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment. It belongs to the OKL product family, Leasing and Finance Management, and is documented as a "line extract object with commonly shared sources across event classes." In practice, the view provides a consolidated, denormalized projection of lease and finance transaction lines drawn from transaction contract lines, transaction accounting distributions, and transaction extensions. Its purpose is to supply a stable, uniformly named interface for downstream extraction routines, feeder programs, and external reporting, so consumers do not need to reconcile the individual base tables or the accounting event model themselves. Because it surfaces distribution-level attributes alongside contract-line and extension attributes, it is particularly useful where accounting detail must be joined to the originating lease line.

Underlying Base Objects

The view is defined over three documented base objects, each exposed through a public synonym in the APPS schema:

The join logic is significant. TCL is joined to DIST on the condition that TCL.ID equals DIST.SOURCE_ID and DIST.SOURCE_TABLE equals the literal 'OKL_TXL_CNTRCT_LNS', meaning distributions are restricted to those originating from contract lines. TEL is joined to TCL with an outer join on both ID and SOURCE_TABLE, so lines that have no extension record are still returned. The DIST_TYPE column is hard-coded to the literal 'OKL_TRNS_ACC_DSTRS', confirming that the distribution branch is the authoritative driver of the extract row.

Key Columns

The view exposes twenty-seven columns. The identifiers EVENT_ID, LINE_NUMBER, DIST_ID, TCL_ID, TEL_LINE_EXTENSION_ID, TCL_TAX_LINE_ID, and TCL_STY_ID establish the linkage hierarchy among accounting events, distributions, contract lines, tax lines, and transaction types. Accounting amounts appear as DIST_ACCOUNTED_AMOUNT, DIST_ENTERED_AMOUNT, and TCL_AMOUNT. The user's search term, DIST_CODE_COMBINATION_ID, is the code combination of the distribution and is the column that resolves to the accounting flexfield, making it the primary key for joining to GL_CODE_COMBINATIONS. Related accounting columns include DIST_AE_LINE_TYPE_CODE, DIST_CR_DR_FLAG, DIST_GL_DATE, DIST_POST_TO_GL_FLAG, DIST_ORIGINAL_DISTRIBUTION_ID, DIST_ACCOUNTING_TEMPLATE_NAME, and LEDGER_ID (sourced from SET_OF_BOOKS_ID). Remaining columns carry contract-line and extension context, such as TCL_CURRENCY_CODE, TCL_DESCRIPTION, TCL_TCN_ID, TCL_TYPE, TCL_STREAM_TYPE_CODE, TCL_STREAM_TYPE_PURPOSE, TEL_MEMO_FLAG, and TEL_INVENTORY_ORG_CODE.

Common Use Cases and Queries

Typical use cases include reconciling lease accounting distributions to the general ledger, extracting posted and unposted entries by ledger, and reporting on memo lines or stream type allocations. The code combination column is frequently joined to the accounting flexfield for a human-readable account.

  • Extracting posted distributions for a ledger: SELECT DIST_ID, DIST_GL_DATE, DIST_ENTERED_AMOUNT, DIST_CODE_COMBINATION_ID FROM OKL_CMN_EXTRACT_LINE_V WHERE LEDGER_ID = :p_ledger AND DIST_POST_TO_GL_FLAG = 'Y';
  • Resolving account descriptions: SELECT v.DIST_ID, gcc.concatenated_segments, v.DIST_ENTERED_AMOUNT FROM OKL_CMN_EXTRACT_LINE_V v, GL_CODE_COMBINATIONS_KFV gcc WHERE v.DIST_CODE_COMBINATION_ID = gcc.code_combination_id;
  • Identifying memo lines: SELECT TCL_ID, TCL_DESCRIPTION, TCL_AMOUNT FROM OKL_CMN_EXTRACT_LINE_V WHERE TEL_MEMO_FLAG = 'Y';
  • Listing debit and credit activity: SELECT DIST_CR_DR_FLAG, SUM(DIST_ACCOUNTED_AMOUNT) FROM OKL_CMN_EXTRACT_LINE_V GROUP BY DIST_CR_DR_FLAG;

Consumers should observe that the extract is driven by contract-line distributions; entries with other source tables are excluded by the join predicate.