Search Results capital_reduction




Overview
Explore in AI Chat

Overview

OKL_ASSET_ADJUST_UV is a user interface view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL – Leasing and Finance Management module. It is documented as the presentation-layer view behind the Asset Adjustment screen, exposing the asset-level financial adjustment attributes that a leasing user maintains when contracts require capital restructuring, trade-in recognition, or down-payment handling. The view is reported as VALID in ETRM 12.2.2 and remains applicable to 12.1.1, where the same OKL and OKC object model is used.

The view does not store data. It is a join-based projection of the leasing line records against the common contract line and line-style definitions, translated for the runtime language of the session. Because it is an interface view, it typically supports the OAF-based Asset Adjustment page rather than being an end-user reporting object, but it can be queried directly for diagnostics and reconciliation.

Underlying Base Objects

The view is defined over four documented objects, all referenced through APPS synonyms: OKL_K_LINES, OKC_K_LINES_B, OKC_K_LINES_TL, and OKC_LINE_STYLES_B. The core leasing attributes reside in OKL_K_LINES (aliased KLE), which is joined to OKC_K_LINES_B (CLE) on the shared ID column. The translated descriptions come from OKC_K_LINES_TL (CLET), joined on ID and filtered by CLET.LANGUAGE = USERENV('LANG'). The line-style definition is provided by OKC_LINE_STYLES_B (LSE), joined on CLE.LSE_ID = LSE.ID, with the predicate LSE.LTY_CODE = 'FREE_FORM1' restricting the view to free-form line styles used by leasing asset adjustment records.

Key Columns

  • ID — Primary identifier of the leasing line style record; the join key across all four base objects.
  • STS_CODE — Status code of the contract line, used to filter active versus terminated adjustments.
  • DNZ_CHR_ID, CLE_ID, LSE_ID, STY_ID — Foreign keys linking the record to the contract, line, line style, and style definition respectively.
  • ASSET_NUMBER, DESCRIPTION — Translated asset identifier and item description from OKC_K_LINES_TL.
  • CAPITAL_REDUCTION — The reduction applied to the capitalized asset value; this is the column most closely associated with the search term "capital_reduction".
  • TRADEIN_AMOUNT — Value credited for a traded-in asset.
  • CAPITAL_REDUCTION_PERCENT, CAPITAL_AMOUNT — Percentage basis of the reduction and the resulting capitalized amount.
  • OEC — Original equipment cost basis for the leased asset.
  • CAPITALIZE_DOWN_PAYMENT_YN, DOWN_PAYMENT_RECEIVER_CODE — Flags and codes governing whether the down payment is capitalized and which party receives it.

Note that all monetary and percentage columns are wrapped in TO_CHAR in the view text, so values are returned as character strings. Any arithmetic or comparison must therefore apply explicit numeric conversion.

Common Use Cases and Queries

Typical uses include validating asset adjustment entries before contract booking, reconciling capital reduction amounts against finance schedules, and auditing trade-in or down-payment treatment. The following retrieves capital reduction details for a specific asset:

SELECT ID, ASSET_NUMBER, DESCRIPTION,
       CAPITAL_REDUCTION, CAPITAL_REDUCTION_PERCENT,
       CAPITAL_AMOUNT, OEC
FROM   APPS.OKL_ASSET_ADJUST_UV
WHERE  ASSET_NUMBER = :asset_number;

To aggregate the total capital reduction per contract, converting the character columns to numbers:

SELECT DNZ_CHR_ID, SUM(TO_NUMBER(CAPITAL_REDUCTION)) TOTAL_REDUCTION
FROM   APPS.OKL_ASSET_ADJUST_UV
WHERE  STS_CODE = 'ACTIVE'
GROUP  BY DNZ_CHR_ID;

Because the view is language-filtered, joins to additional OKL tables should use ID or CLE_ID, and callers should account for the FREE_FORM1 line-style restriction when interpreting results.