Search Results okl_ls_rt_fctr_ents_v




Overview
Explore in AI Chat

Overview

OKL_LS_RT_FCTR_ENTS_V is an APPS-owned database view in the Oracle Lease and Finance Management (OKL) module, valid in Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM metadata, the view is a thin wrapper defined over the base table OKL_LS_RT_FCTR_ENTS. The "LS" prefix associates the object with the Lease origination/servicing data model, while "RT_FCTR_ENTS" denotes rate factor entries — the individual rows that constitute a lease rate factor table. The view therefore presents rate factor entry records used in lease pricing and rate calculation. Because it is a wrapper, it carries no filtering, joining, or aggregation logic; its SELECT list simply projects the base table columns, adding the ROWID pseudo-column as ROW_ID for the first entry. This design gives Oracle a stable, named access point that can be granted to other modules, reports, and integration consumers without exposing direct table privileges. In practice the view serves read-only reporting and integration: external pricing engines, custom reports, and interfaces read rate factor data through OKL_LS_RT_FCTR_ENTS_V rather than referencing the underlying table directly.

Underlying Base Objects

The documented referenced base object is the synonym OKL_LS_RT_FCTR_ENTS, which resolves to the APPS table of the same name. The view text confirms a single-table definition with no joins:

SELECT LRF.ROWID ROW_ID, LRF.ID ID, LRF.OBJECT_VERSION_NUMBER, ... FROM OKL_LS_RT_FCTR_ENTS LRF

Every projected column is qualified by the alias LRF and mapped one-to-one to a base table column. There are no WHERE, GROUP BY, or DISTINCT clauses, so the row set of the view is identical to that of the base table. The relationship is therefore one of encapsulation rather than transformation: the view renames only ROWID to ROW_ID and leaves all other column names unchanged.

Key Columns

  • ID — Primary identifier of the rate factor entry, projected from LRF.ID.
  • OBJECT_VERSION_NUMBER — Optimistic locking version used by the framework for concurrent updates.
  • LRT_ID — Foreign key to the parent lease rate table that owns the entry; groups entries into a rate set.
  • TERM_IN_MONTHS — Lease term, in months, to which the factor row applies.
  • RESIDUAL_VALUE_PERCENT — Residual value percentage associated with the term.
  • INTEREST_RATE — Interest rate for the term.
  • LEASE_RATE_FACTOR — The computed or maintained lease rate factor itself.
  • RATE_SET_VERSION_ID — Identifier of the rate set version to which the entry belongs, supporting versioned rate tables.
  • CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard who-columns for audit and concurrent program bookkeeping.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 … ATTRIBUTE15 — The standard EBS descriptive flexfield columns available to customers for extensibility.

Common Use Cases and Queries

Typical uses include inspecting the factors that back a specific rate table, auditing residual and interest combinations by term, and feeding external pricing or lease quotation systems. A basic query lists entries for a given parent LRT_ID in term order:

SELECT ID, LRT_ID, TERM_IN_MONTHS, RESIDUAL_VALUE_PERCENT, INTEREST_RATE, LEASE_RATE_FACTOR FROM APPS.OKL_LS_RT_FCTR_ENTS_V WHERE LRT_ID = :p_lrt_id ORDER BY TERM_IN_MONTHS;

A lookup to resolve a factor for a specific term and interest rate uses the same view:

SELECT LEASE_RATE_FACTOR FROM APPS.OKL_LS_RT_FCTR_ENTS_V WHERE LRT_ID = :p_lrt_id AND TERM_IN_MONTHS = :p_term AND INTEREST_RATE = :p_rate;

Because the view is a pure projection, queries run with the same cost profile as against the base table, and the ROW_ID column permits row-addressable operations where a DBA chooses to define INSTEAD OF triggers on the view. Reporting queries should always constrain by LRT_ID or RATE_SET_VERSION_ID to avoid full scans of the base table.