Search Results tcl_asset_attribute_category




Overview
Explore in AI Chat

Overview

The OKL_ASSET_DFF_EXTRACT_LINE_V view is a line-level extraction object delivered in the APPS schema as part of the Oracle Lease and Finance Management (OKL) module. Its documented purpose is to serve as the line extract object for asset-related descriptive flexfields (DFF). In the Oracle E-Business Suite 12.1.1 and 12.2.2 releases, this view forms part of the ETRM (Enterprise Transaction and Reporting Model) extraction layer, providing a denormalized, reporting-friendly projection of contract line descriptive flexfield data.

The view's principal design characteristic is that it conditionally exposes the descriptive flexfield (DFF) context and attribute columns from the contract line table only when the associated line type is FREE_FORM1. For all other contract line types, the DFF columns are returned as NULL. This conditional projection allows downstream extraction and integration programs to consume asset-related DFF data in a consistent shape without regard to the mix of line types present on a contract.

The view status is VALID and it is owned by APPS, which is consistent with the standard EBS practice of exposing OKL extraction objects through the APPS schema for use by concurrent programs, reports, and interface logic.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through synonyms:

  • OKL_TXL_CNTRCT_LNS_ALL — the contract lines table, aliased as TCL. This is the driving table and supplies the line identifier (TCL.ID) and the twenty source DFF columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15).
  • OKL_TXL_EXTENSION_B — the extension table, aliased as TEL. This table is joined externally (outer join) and supplies the CONTRACT_LINE_TYPE value used by the DECODE logic.

The join is expressed as TCL.ID = TEL.SOURCE_ID(+) combined with TEL.SOURCE_TABLE(+) = 'OKL_TXL_CNTRCT_LNS'. The outer-join syntax ensures that contract lines without a corresponding extension row are still returned; in those cases the CONTRACT_LINE_TYPE is NULL and every DFF column evaluates to NULL.

Key Columns

The view exposes the following columns:

  • TCL_ID — the contract line identifier, sourced from TCL.ID. This is the primary correlating key back to OKL_TXL_CNTRCT_LNS_ALL.
  • TCL_ASSET_ATTRIBUTE_CATEGORY — the DFF context value, returned only when the line type is FREE_FORM1.
  • TCL_ASSET_ATTRIBUTE1 through TCL_ASSET_ATTRIBUTE15 — the fifteen descriptive flexfield attribute segments, each individually wrapped in a DECODE on TEL.CONTRACT_LINE_TYPE so that the value is surfaced only for FREE_FORM1 lines and NULL otherwise.

The user search term tcl_asset_attribute15 corresponds directly to the TCL_ASSET_ATTRIBUTE15 column, the fifteenth and final attribute segment projected by the view.

Common Use Cases and Queries

The view is typically used in asset DFF extraction routines, reporting queries, and outbound interface mappings where asset-level flexfield values must be isolated from contract line records. A representative query to retrieve the DFF values for a specific contract line follows:

  • SELECT TCL_ID, TCL_ASSET_ATTRIBUTE_CATEGORY, TCL_ASSET_ATTRIBUTE15
  • FROM APPS.OKL_ASSET_DFF_EXTRACT_LINE_V
  • WHERE TCL_ID = :p_line_id;

To identify only those lines that actually carry asset DFF data, filtering on a non-null context is appropriate. Because the join to OKL_TXL_EXTENSION_B is an outer join, lines lacking extension rows appear with null DFF columns and should be filtered out where DFF values are required. The view is read-only and should be consumed by extraction and reporting processes rather than used as a target for DML.