Results for “khr_attribute1”

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

Overview

OKL_K_HEADERS_UV is an APPS-owned, VALID database view within the OKL – Leasing and Finance Management product family of Oracle E-Business Suite. It exposes the header-level attributes of leasing and finance contracts, presenting a unified, user-facing projection over the underlying contracts header entity. The "_UV" suffix conventionally denotes a "user view" — a denormalized or joined layer intended for direct querying by reports, concurrent programs, and integration interfaces rather than for transactional DML. In EBS 12.1.1 and 12.2.2 the view resolves against the contract header tables (OKC_K_HEADERS_B, OKC_K_HEADERS_TL) and the leasing extension table (OKL_K_HEADERS), plus supplementary lookups such as HZ_CUST_ACCOUNTS, HZ_PARTIES, OKC_STATUSES_TL, and OKL_PRODUCTS. Because it carries the ROWID of the base header row as ROW_ID, it is a natural driver for APIs and for locating the physical row of a contract header during integration. Note that the alias "khr_row_id" is frequently used in custom SQL to reference this ROW_ID column.

Underlying Base Objects

The view is defined over the following documented base objects:

• OKC_K_HEADERS_B (SYNONYM) – the core contracts header table, providing most of the columns aliased as CHRB.
• OKC_K_HEADERS_TL (SYNONYM) – the translated (language) header table, supplying descriptive columns such as SHORT_DESCRIPTION, COMMENTS, and DESCRIPTION (aliased CHRT).
• OKL_K_HEADERS (SYNONYM) – the OKL leasing extension to the contracts header, contributing leasing-specific attributes.
• OKC_STATUSES_TL, OKL_PRODUCTS – lookups for status and product context.
• HZ_CUST_ACCOUNTS, HZ_PARTIES – trading-partner and party references.
• OKC_UTIL (PACKAGE) – utility package referenced within the view logic.

The view therefore joins the generic contract header (base and translated) to the leasing header extension, giving a single row per contract header that surfaces both standard and leasing-specific data.

Key Columns

The SELECT list exposes a broad set of header attributes. Notable columns include:

• ROW_ID – the ROWID of OKC_K_HEADERS_B, used as the physical row identifier (the column behind the "khr_row_id" alias).
• ID, OBJECT_VERSION_NUMBER – primary key and optimistic locking version.
• CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER – human-readable contract identity.
• STS_CODE, SCS_CODE, QCL_ID – status and quality-control references.
• CURRENCY_CODE, ESTIMATED_AMOUNT, DPAS_RATING – financial and rating attributes.
• BUY_OR_SELL, ISSUE_OR_RECEIVE, CHR_TYPE, RFP_TYPE – directional and type classification.
• START_DATE, END_DATE, DATE_SIGNED, DATE_APPROVED, DATE_TERMINATED, DATE_RENEWED – lifecycle dates.
• ARCHIVED_YN, DELETED_YN, TEMPLATE_YN – flags controlling contract state.
• SHORT_DESCRIPTION, COMMENTS, DESCRIPTION, COGNOMEN – translated textual fields.

Common Use Cases and Queries

This view is typically consumed in reporting and integration to retrieve contract header details without navigating the underlying join. Typical usages include listing active lease headers, resolving a header by contract number, and obtaining the ROW_ID for follow-on API processing.

• Retrieve active headers: SELECT contract_number, sts_code, start_date, end_date FROM okl_k_headers_uv WHERE deleted_yn = 'N';
• Locate a header by number and capture its physical row: SELECT row_id, id FROM okl_k_headers_uv WHERE contract_number = :p_contract_number AND contract_number_modifier IS NULL;
• List leasing contracts by type and direction: SELECT contract_number, chr_type, buy_or_sell, estimated_amount FROM okl_k_headers_uv WHERE chr_type = :p_chr_type AND archived_yn = 'N';

Because the view includes ROW_ID, it is a preferred entry point for custom code that must then call OKC or OKL APIs on the specific header row. Queries should always filter on the NLS-appropriate translated columns and account for the functional currency and operating unit context when used in multi-org environments.