Search Results display_in_lease_center

Overview

OKL_SEC_INVESTOR_DTLS_UV is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, delivered as part of the OKL — Leasing and Finance Management product family. The view is documented as the "Investor Agreement Investor Details View" and is listed with a status of VALID. It presents a consolidated, reporting-oriented projection of investor agreements, their associated pools, and the stream types linked to those pools. Its design allows Oracle Leasing and Finance Management users to identify investor agreements together with the securitization or syndication vehicles under which lease streams have been pooled.

The metadata explicitly references a column named DISPLAY_IN_LEASE_CENTER in the documented view text, which directly explains the user search term "display_in_lease_center." This column is sourced from OKL_POOLS and is exposed so that downstream consumers, such as the Lease Center UI and related reporting layers, can filter or flag pools intended for display in that operational workspace. The view therefore acts as a bridge between contract header data, pool membership, and the display governance flag used by the Lease Center.

Underlying Base Objects

The documented base objects underlying OKL_SEC_INVESTOR_DTLS_UV are:

• FND_GLOBAL (PACKAGE) — supplies session context, notably USERENV('LANG'), used to restrict status translations to the current language.
• FND_LOOKUPS (VIEW) — provides lookup meanings for investor agreement type, stream type subclass, and stream type purpose.
• OKC_K_HEADERS_ALL_B (SYNONYM) — the contract headers table, joined twice as CHRA (the pooled contract) and CHRB (the investor agreement identified by SCS_CODE = 'INVESTOR').
• OKC_STATUSES_TL (SYNONYM) — supplies translated status meanings for investor agreements.
• OKL_K_HEADERS (SYNONYM) — the leasing contract header, providing SECURITIZATION_TYPE used to decode into investor agreement type.
• OKL_POOLS (SYNONYM) — the pool definition, contributing POOL_NUMBER and DISPLAY_IN_LEASE_CENTER.
• OKL_POOL_CONTENTS (SYNONYM) — the association between pools and contract headers, linking pooled contracts to pools.
• OKL_STRM_TYPE_B (SYNONYM) — the stream type definition, filtered to RENT and RESIDUAL subclasses.

The view is implemented as a UNION ALL of two branches, combining rows where an investor agreement header exists with rows where only pool and stream type information is available.

Key Columns

• KHR_ID — the contract header identifier of the pooled contract.
• INVESTOR_AGRMNT_NUMBER — the contract number of the investor agreement (CHRB.CONTRACT_NUMBER); null in the second UNION branch.
• INVESTOR_AGRMNT_STATUS — translated status meaning of the investor agreement.
• INVESTOR_AGRMNT_TYPE — derived meaning from OKL_SECURITIZATION_TYPE, decoding SALE and LOAN into SECURITIZATION/SYNDICATION groupings.
• STRM_TYPE_SUBCLASS — stream type subclass meaning, restricted to RENT or RESIDUAL.
• STRM_TYPE_PURPOSE — stream type purpose meaning from FND_LOOKUPS.
• POOL_NUMBER — the pool identifier from OKL_POOLS.
• DISPLAY_IN_LEASE_CENTER — the pool flag governing whether the pool appears in the Lease Center workspace.

Common Use Cases and Queries

Typical usage includes identifying pools flagged for Lease Center display, reporting investor agreement coverage across securitization and syndication structures, and enumerating rent or residual streams associated with investor pools.

SELECT pool_number, display_in_lease_center
FROM   apps.okl_sec_investor_dtls_uv
WHERE  display_in_lease_center = 'Y';

SELECT investor_agrmnt_number, investor_agrmnt_type,
       strm_type_subclass, pool_number
FROM   apps.okl_sec_investor_dtls_uv
WHERE  investor_agrmnt_status = 'ACTIVE';

Because the view performs DISTINCT operations across multiple joins and a UNION ALL, queries should be constrained by pool, contract, or display flag predicates to avoid unnecessary full scans.