Search Results okl_la_headers_uv




Overview
Explore in AI Chat

Overview

OKL_LA_HEADERS_UV is a user interface view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is delivered as part of the OKL – Leasing and Finance Management product family and exposes lease contract header information held within Oracle Contracts (OKC). The view presents a denormalized, presentation-layer projection of lease headers, combining core contract header attributes with status descriptions, product definitions, program descriptions, and legal entity context.

Its primary role is to support the Leasing and Finance Management user interface and any reporting or integration layer that requires a concise, single-row-per-lease representation of contract headers. Rather than joining OKC and OKL base tables directly, developers and report authors can query OKL_LA_HEADERS_UV, which encapsulates the necessary joins and language-dependent lookups. The view is documented as VALID, and it is listed among the Oracle Contracts for Lease header sources. Because the view is a read-only projection over transactional base tables, it should be used for query and reporting purposes rather than for direct DML.

Underlying Base Objects

The view is defined over five documented base objects, each referenced through a synonym in the APPS schema:

  • OKC_K_HEADERS_B — the base contract header table, supplying core attributes such as ID, contract number, dates, status code, authoring organization, and inventory organization.
  • OKC_K_HEADERS_TL — the language-dependent translation table for contract headers, supplying the short description, and also aliased as PROG for the program description.
  • OKC_STATUSES_TL — the language-dependent status lookup, supplying the status meaning.
  • OKL_K_HEADERS — the leasing-specific extension of the contract header, supplying the legal entity and product reference.
  • OKL_PRODUCTS — the leasing product definition, supplying product name and description.

The join predicates link TL.ID to CHR.ID (header description), STL.CODE to CHR.STS_CODE (status meaning), and KHR.ID to CHR.ID (lease extension). Product and program joins are outer joins (KLP.ID(+) = KHR.PDT_ID and PROG.ID(+) = KHR.KHR_ID), so a lease header is returned even when no product or program is assigned. The language columns TL.LANGUAGE and STL.LANGUAGE are filtered against USERENV('LANG') to return session-appropriate translated text. The user's search term, okc_k_headers_tl, corresponds directly to this view's language table, OKC_K_HEADERS_TL.

Key Columns

  • ID — the contract header identifier; the primary key linking to OKC and OKL detail entities.
  • CONTRACT_NUMBER — the user-facing contract number.
  • SHORT_DESCRIPTION — the translated contract header description from OKC_K_HEADERS_TL.
  • STS_CODE and MEANING — the raw status code and its translated meaning from OKC_STATUSES_TL.
  • START_DATE and END_DATE — the contract effective start and end dates.
  • AUTHORING_ORG_ID and INV_ORG_ID — the authoring organization and inventory organization identifiers.
  • LEGAL_ENTITY_ID — the legal entity associated with the lease header.
  • PDT_ID, PRODUCT_NAME, and PRODUCT_DESCRIPTION — the leasing product identifier and descriptive attributes.
  • PROGRAM_NAME — the program description sourced from the aliased OKC_K_HEADERS_TL join.

Common Use Cases and Queries

Typical usage includes lease header listings, status-driven dashboards, and integration extracts feeding downstream finance systems. A representative query follows:

SELECT contract_number, short_description, meaning, start_date, end_date, product_name, legal_entity_id FROM okl_la_headers_uv WHERE sts_code = 'ACTIVE' ORDER BY contract_number;

Another common pattern filters by legal entity or authoring organization for reporting by business unit, or restricts rows to those with an assigned product using product_name IS NOT NULL. Because language filtering relies on USERENV('LANG'), queries executed from different sessions may return descriptions in the session's native language.