Search Results okl_cs_asset_lines_v




Overview
Explore in AI Chat

Overview

OKL_CS_ASSET_LINES_V is a reporting view owned by the APPS schema within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It exposes the fixed asset lines associated with Oracle Contracts for Lease, specifically contracts of type LEASE, and additionally surfaces the fixed assets linked to loan-type contracts. In Oracle Lease and Finance Management, a fixed asset line in OKL serves as the contractual link to a corresponding asset recorded in Oracle Fixed Assets, referenced through the asset_id. This view consolidates that relationship into a single denormalized structure, allowing the contract line, the lease or loan header context, and the underlying asset attributes from Oracle FA to be queried together without manually joining across the OKC and FA schemas.

The view carries a VALID status and is intended for operational reporting and integration use. Because it joins contract data to asset master and book information, it is well suited to reconciliation and visibility requirements where asset identity, depreciation attributes, and contract linkage must be presented side by side.

Underlying Base Objects

The view is defined primarily over contract structures and fixed asset tables. The documented references include OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_LINES_TL, and OKC_LINE_STYLES_B, which supply the contract header, item, line, and line-style context from Oracle Contracts. OKL_K_HEADERS and OKL_K_LINES provide the Lease and Finance Management-specific header and line records. The asset link is established through OKL_TXL_ASSETS_B, which ties the contract line to an asset identifier. On the asset side, the view draws from FA_ADDITIONS_B and FA_ADDITIONS_TL for asset master and descriptive data, FA_BOOKS for depreciation book attributes, and FA_BOOK_CONTROLS for the book and organization context. OKC_STATUSES_V supplies status derivation logic. These objects are referenced through synonyms in the APPS schema.

Key Columns

Common Use Cases and Queries

A typical use case is listing all active asset lines for lease contracts along with their asset numbers and book costs. For example:

  • SELECT ID1, ASSET_NUMBER, ASSET_ID, LSE_TYPE, STATUS, ORIGINAL_COST FROM OKL_CS_ASSET_LINES_V WHERE STATUS = 'A';
  • Reconciling contract lines to Oracle FA assets: SELECT CHR_ID, PARENT_LINE_ID, ASSET_NUMBER, CORPORATE_BOOK, ADJUSTED_COST FROM OKL_CS_ASSET_LINES_V WHERE LTY_CODE = 'LEASE';
  • Reviewing depreciation exposure for assets tied to loan contracts by filtering on LSE_TYPE and selecting DEPRN_METHOD_CODE, LIFE_IN_MONTHS, and SALVAGE_VALUE.

Because the view spans both the contract and asset schemas, it is commonly used in custom reports, reconciliation extracts, and integration interfaces where a unified contract-to-asset record is required.