Results for “residual_value”

50+ results




Overview
Explore in AI Chat

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

Overview

OKL_NEW_LOAN_ASSETS_UV is a user interface view owned by the APPS schema in Oracle E-Business Suite, defined within the OKL - Lease and Finance Management product family. Its documented purpose is to serve as the asset summary page view — the queryable data source that backs the asset summary region presented to users when they review the loan or lease asset structure of a contract. Although the object is classified as a VIEW and therefore read-only, it functions as the integration and reporting surface through which asset-level attributes are projected up from the underlying contract and asset tables.

The view is exposed in both EBS 12.1.1 and 12.2.2. In the ETRM 12.2.2 metadata it carries a status of VALID and depends on nine referenced base objects. The catalogued columns include ASSET_NUMBER, YEAR_MANUFACTURED, MANUFACTURER_NAME, DESCRIPTION, and CURRENT_UNITS, with additional columns visible in the view text such as OEC, VENDOR_NAME, RESIDUAL_VALUE, START_DATE, END_DATE, DATE_TERMINATED, STS_CODE, PARENT_LINE_ID, DNZ_CHR_ID, and ASSET_STATUS_CODE.

Underlying Base Objects

The view is defined over the following documented base objects: OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_K_PARTY_ROLES_B, OKC_LINE_STYLES_B, OKC_STATUSES_V, OKL_K_LINES, and PO_VENDORS. All except OKC_STATUSES_V and PO_VENDORS are referenced as synonyms; these two are themselves views.

Structurally, the view joins contract headers (OKC_K_HEADERS_B) to contract lines (OKC_K_LINES_B, aliased multiple times as CLE_FIN, CLE_ML, and CLE_FA) discriminated by line styles from OKC_LINE_STYLES_B. Three line-style regimes drive the result: LTY_CODE 'FREE_FORM1' identifies the financing line, 'ITEM' identifies the item line, and 'FIXED_ASSET' identifies the associated asset line. OKC_K_LINES_TL supplies the language-specific asset number and description, filtered on USERENV('LANG'). OKL_K_LINES supplies the OKL-specific extension attributes such as YEAR_BUILT, OEC, and RESIDUAL_VALUE. OKC_K_ITEMS provides unit counts, and OKC_K_PARTY_ROLES_B is outer-joined to resolve the vendor role, which resolves to PO_VENDORS for VENDOR_NAME. OKC_STATUSES_V translates STS_CODE into a readable MEANING.

Key Columns

  • ASSET_NUMBER — the language-specific asset identifier sourced from OKC_K_LINES_TL.NAME.
  • YEAR_MANUFACTURED — the year built, from OKL_K_LINES.YEAR_BUILT.
  • DESCRIPTION — the asset item description from OKC_K_LINES_TL.ITEM_DESCRIPTION.
  • CURRENT_UNITS — the number of items, from OKC_K_ITEMS.NUMBER_OF_ITEMS.
  • OEC, RESIDUAL_VALUE — OKL financial attributes of the financed line.
  • START_DATE, END_DATE, DATE_TERMINATED — asset-line date attributes from OKC_K_LINES_B.
  • STS_CODE, ASSET_STATUS_CODE — the readable status meaning and the underlying status code for the asset line.
  • VENDOR_NAME — the manufacturer/vendor name resolved via the OKL_VENDOR party role and PO_VENDORS.
  • PARENT_LINE_ID, DNZ_CHR_ID — the parent line identifier and the contract header identifier for navigation and linkage.

Common Use Cases and Queries

The view is typically queried to produce asset summary listings for a contract, or to extract asset detail for reconciliation and downstream reporting. A representative query filters by the contract header identifier:

  • SELECT asset_number, description, current_units, oec, residual_value, vendor_name, sts_code FROM okl_new_loan_assets_uv WHERE dnz_chr_id = :p_chr_id;
  • SELECT asset_number, year_manufactured, start_date, end_date, date_terminated FROM okl_new_loan_assets_uv WHERE asset_status_code = 'ACTIVE';
  • SELECT vendor_name, COUNT(*) FROM okl_new_loan_assets_uv GROUP BY vendor_name ORDER BY 2 DESC;

Because the predicate on CLT_FIN.LANGUAGE restricts rows to the session language, results are language-sensitive and should be run in a session with the expected USERENV('LANG') value.