Results for “okl_lav_u1”

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

Overview

The OKL.OKL_LEASEAPP_TEMPL_VERSIONS_B table stores version records for Oracle Lease and Finance Management (OKL) lease application templates. Each row represents a discrete version of a lease application template, capturing the template identifier, the version number, validity dates, and lifecycle status of that version. In Oracle EBS 12.1.1 and 12.2.2, this table underpins the Oracle Lease Management (OLM) module's ability to maintain multiple concurrent or historical template versions, allowing originators to define, stage, and activate lease application templates without destroying prior definitions.

From a Data Vault modeling perspective, the mined FK structure classifies this object heuristically as a standalone entity rather than a classic hub, link, or satellite. In practice, its attributes (version number, validity window, status, checklist reference) suggest a satellite-like role keyed to its parent lease application template, with the surrogate ID serving as the technical key.

Key Information Stored

The most significant columns documented in the ETRM metadata are:

• ID — Surrogate primary key (PK OKL_LAV_PK), enforced by the unique index OKL_LAV_U1. This is the technical row identifier, not a user-visible business key.
• LEASEAPP_TEMPLATE_ID — Foreign key to OKL_LEASEAPP_TEMPLATES, tying each version row to its parent template. This is the principal business relationship column.
• VERSION_NUMBER — The human-readable version label assigned to this template revision.
• VERSION_STATUS — Status code from lookup type OKL_LEASE_TEMPLATE_STATUS; indexed non-uniquely (OKL_LEASEAPP_TEMPL_VERS_B_N1) because it drives frequent status-based filtering.
• VALID_FROM / VALID_TO — Effective date window governing when the version is usable.
• CHECKLIST_ID — FK to PER_CHECKLISTS, binding a checklist to the version.
• CONTRACT_TEMPLATE_ID — Reference to the associated contract template.
• OBJECT_VERSION_NUMBER — Optimistic locking column used during concurrent updates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) columns for client-specific extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

The dominant use cases are template version resolution and status reporting. A typical query resolves the currently active version of a template:

SELECT v.id, v.version_number, v.version_status, v.valid_from, v.valid_to FROM okl.okl_leaseapp_templ_versions_b v WHERE v.leaseapp_template_id = :template_id AND v.version_status = 'ACTIVE' AND SYSDATE BETWEEN v.valid_from AND NVL(v.valid_to, SYSDATE);

Status summarization across templates supports administrative dashboards:

SELECT leaseapp_template_id, version_status, COUNT(*) FROM okl.okl_leaseapp_templ_versions_b GROUP BY leaseapp_template_id, version_status;

Because columns are suffixed with _B, this table functions as the base table in an entity-attribute translation pattern; translated (_T) or language-specific rows are typically resolved through the corresponding translation table for descriptive text. Reporting on DFF attributes requires joining FND_DFF metadata if client extensions are populated.

Related Objects

The most significant related objects, grounded in the documented relationships, are:

• OKL.OKL_LEASEAPP_TEMPLATES — Parent entity; joined on LEASEAPP_TEMPLATE_ID (versions reference templates).
• PER_CHECKLISTS — Referenced by CHECKLIST_ID; provides the checklist definition attached to a template version.
• OKL.OKL_LEASEAPP_TEMPL_VERSIONS_TL — Translation table for language-dependent template version text, keyed by ID.
• OKL.OKL_LEASEAPP_TEMPLATES_TL — Translation partner for the parent template.
• FND_LOOKUP_VALUES — Supplies the OKL_LEASE_TEMPLATE_STATUS lookup values used by VERSION_STATUS.
• OKL_LEASEAPP_TEMPLATE_VERSIONS_V — Alternate view layers over the base table used by OLM APIs and forms.
• FND_DESCR_FLEX_COL_USAGE — Metadata source for the ATTRIBUTE_CATEGORY/ATTRIBUTE1–15 DFF columns.