Results for “okl_ap_payments_ref_vl”

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

Overview

OKL_AP_PAYMENTS_REF_VL is an APPS-owned, VALID database view within the Oracle Lease and Finance Management (OKL) module. Its primary role is to serve as a reporting and integration bridge between Oracle Payables (AP) invoice distributions and the Oracle Lease and Finance Management transaction framework. By joining AP invoice lines and distributions to OKL extension tables, the view exposes lease-specific reference data—such as the contract (KHR) identifier—alongside the standard AP distribution identifier. This allows downstream reports, reconciliation scripts, and integrations to correlate a Payables invoice distribution with its originating lease contract and inventory context.

The view is especially relevant to users who search for "okl_khr_id," because that is one of its central columns. It effectively provides a flattened, denormalized projection of lease contract references that would otherwise require multiple joins across the OKL extension model.

Underlying Base Objects

The view is defined over the following documented base objects (all referenced as APPS synonyms in ETRM 12.2.2):

• AP_INVOICE_DISTRIBUTIONS_ALL — standard AP invoice distribution lines.
• AP_INVOICE_LINES_ALL — standard AP invoice lines.
• OKL_EXT_AP_HEADER_SOURCES_B / _TL — header-level extension sources storing lease header linkage.
• OKL_EXT_AP_LINE_SOURCES_B / _TL — line-level extension sources storing lease line linkage.
• OKL_TXL_AP_INV_LNS_ALL_B — the OKL transaction table that links AP invoice lines to lease transactions.

The joins hinge on two keys: AP_INVOICE_LINES_ALL.APPLICATION_ID = 540 (OKL) with PRODUCT_TABLE = 'OKL_TXL_AP_INV_LNS_ALL_B', and REFERENCE_KEY1 = OKL_TXL_AP_INV_LNS_ALL_B.ID. The OKL extension header and line tables are joined via HEADER_EXTENSION_ID and LINE_EXTENSION_ID respectively, and the translated (_TL) tables are joined on matching LANGUAGE values to return descriptive text.

Key Columns

• OKL_INVOICE_DISTRIBUTION_ID — the AP invoice distribution identifier, enabling traceability back to AP_INVOICE_DISTRIBUTIONS_ALL.
• OKL_KHR_ID — the lease contract (KHR) identifier from the OKL header source. This is the most frequently queried column, tying a Payables distribution to its lease contract.
• LANGUAGE — the language of the translated descriptive columns.
• TEHL_CONTRACT_STATUS — the contract status from the header translation table.
• TELL_INVENTORY_ORG_NAME — inventory organization name, populated only when SCS_CODE = 'LEASE'.
• TEHL_TRANSACTION_TYPE_NAME — the lease transaction type name.
• TELL_INVENTORY_ITEM_NAME — the inventory item name associated with the lease line.

Common Use Cases and Queries

Typical uses include reconciling AP invoice distributions to lease contracts, validating that lease-related payables carry correct contract references, and extracting inventory context for lease transactions. A common query retrieves all lease references for a given KHR id:

• SELECT okl_khr_id, okl_invoice_distribution_id, tehl_contract_status FROM okl_ap_payments_ref_vl WHERE okl_khr_id = :khr_id;

Another pattern joins the view to AP_INVOICE_DISTRIBUTIONS_ALL to obtain invoice amounts alongside lease references:

• SELECT v.okl_khr_id, v.okl_invoice_distribution_id, d.amount FROM okl_ap_payments_ref_vl v, ap_invoice_distributions_all d WHERE v.okl_invoice_distribution_id = d.invoice_distribution_id;

Because the view filters on APPLICATION_ID = 540 and the OKL product table, only lease-sourced Payables activity is returned, making it suitable for focused lease-payables reporting without additional filtering.