Search Results disp_in_lease_cntr_meaning

Overview

OKL_POOL_HEADER_UV is a UI-support view owned by the APPS schema in Oracle E-Business Suite, belonging to the OKL – Leasing and Finance Management product family. Its documented purpose is to serve as the securitization pool header user-interface view, exposing the header-level attributes of securitization pools for display in the Leasing and Finance Management forms and related inquiry screens. The view is defined as a UNION of two SELECT branches, which allows it to present a unified row shape that combines pool records without an associated contract with pool records that reference a contract header. The redundant columns in each branch are populated with literal NULLs, so the union produces a consistent set of columns regardless of which underlying population a row originates from.

From a reporting and integration standpoint, OKL_POOL_HEADER_UV behaves as a read-only projection over the pool master data and the status and lookup reference data that the application requires. Its most notable structural feature is that the columns AGREEMENT_NUMBER, AGREEMENT_STE_CODE, AGREEMENT_STS_CODE, and AGREEMENT_STATUS are hard-coded to NULL in the first branch and populated from contract header data in the second branch. This design reflects the securitization model in which a pool may exist independently of any lease agreement, or may be tied to one.

Underlying Base Objects

The documented base objects referenced by the view are:

• OKL_POOLS (synonym) – the primary pool master table, aliased POLB in the view text. This supplies the pool identifier, pool number, currency, principal and receivable totals, reconciliation and calculation dates, status code, KHR_ID, descriptive flexfield attributes, and the DISPLAY_IN_LEASE_CENTER and LEGAL_ENTITY_ID columns.
• OKC_STATUSES_TL (synonym) – the translated status codes table, aliased PSTS, joined on POLB.STATUS_CODE = PSTS.CODE with a language filter of USERENV('LANG'), supplying the translated STATUS meaning.
• OKC_STATUSES_B (synonym) – the base status table supporting the translated status definitions.
• OKC_K_HEADERS_ALL_B (synonym) – the contract header base table, used in the union branch that populates AGREEMENT_NUMBER from CONTRACT_NUMBER and related agreement status columns (CHRB).
• FND_LOOKUPS (view) – the standard EBS lookup view, aliased FL, joined on the OKL_YES_NO lookup type to translate the DISPLAY_IN_LEASE_CENTER flag into a meaning.
• FND_GLOBAL (package) – the standard EBS context package, used for session and language resolution.

The joins are effectively outer or literal in nature for the agreement columns, since the first union branch deliberately returns NULL for all agreement-related fields, isolating pool-only records from contract-linked records.

Key Columns

• ID – the pool identifier from OKL_POOLS, the primary key used in downstream joins and drill-downs.
• POOL_NUMBER – the user-facing pool number.
• CURRENCY_CODE – the currency in which pool amounts are denominated.
• TOTAL_PRINCIPAL_AMOUNT / TOTAL_RECEIVABLE_AMOUNT – aggregate principal and receivable amounts for the pool.
• STATUS_CODE / STATUS – the pool status code and its translated meaning.
• AGREEMENT_NUMBER, AGREEMENT_STE_CODE, AGREEMENT_STS_CODE, AGREEMENT_STATUS – contract linkage attributes returned only for pools associated with a contract header; NULL otherwise.
• DATE_CREATED, DATE_LAST_UPDATED, DATE_LAST_RECONCILED, DATE_TOTAL_PRINCIPAL_CALC – lifecycle and calculation timestamps.
• DISPLAY_IN_LEASE_CENTER / DISP_IN_LEASE_CNTR_MEANING – the lease-center display flag and its lookup meaning.
• LEGAL_ENTITY_ID, KHR_ID, DESCRIPTION, SHORT_DESCRIPTION, ATTRIBUTE1–15, LAST_UPDATE_DATE – legal entity, key header reference, descriptive text, descriptive flexfield segments, and audit columns.

Common Use Cases and Queries

Typical use is reporting on securitization pools displayed in the Lease Center, or identifying whether a pool is linked to a lease agreement. To list pools with their translated status and lease-center flag:

SELECT pool_number, currency_code, total_principal_amount,
       total_receivable_amount, status, disp_in_lease_cntr_meaning
FROM   apps.okl_pool_header_uv
WHERE  display_in_lease_center = 'Y';

To find pools that reference a contract (agreement) and return the agreement number, a filter on the union-populated column is required:

SELECT pool_number, agreement_number, agreement_status
FROM   apps.okl_pool_header_uv
WHERE  agreement_number IS NOT NULL;

Because AGREEMENT_NUMBER is NULL for pool-only rows, any query seeking agreement linkage must explicitly exclude NULLs. Supports and view definitions should be reviewed before extending the view, as it is an application-standard object and is expected to remain read-only.