Search Results cnsld_inv_id

Overview

OKL_CS_DISBURSEMENTS_UV is a read-only consolidated view owned by the APPS schema in Oracle EBS Release 12.1.1 and 12.2.2. It belongs to the OKL (Leasing and Finance Management) product family and exposes the disbursement side of leasing contracts — specifically the linkage between consolidated Oracle Payables invoices raised against a lease contract, the corresponding invoice lines tied to fixed assets, and the resulting payment and check activity. In practice it answers the question: for a given lease contract and its booked asset, which vendor invoices were disbursed, by what payment method, on which check, and for what amount.

The view is an operational reporting and integration object. It is typically consumed by dashboards, extracts, or downstream processes that need payables visibility without navigating the normalized OKL and AP schemas directly. Note the user search term ap_invoice_payments_all: this view is the OKL-specific bridge that joins AP payment data (through AP_INVOICE_PAYMENTS_ALL and AP_CHECKS_ALL) back to lease contract and asset context, which is not available in the AP tables alone.

Underlying Base Objects

The documented base objects are a mix of synonyms and views resolving to core tables:

• OKL_CNSLD_AP_INVS_ALL — the consolidated AP invoice header for leasing; supplies vendor invoice number, invoice date, invoice type, org, and currency.
• OKL_TXL_AP_INV_LNS_ALL_B — the transaction line table; provides disbursement amount, the contract line reference (KLE_ID), stream type, and KHR_ID.
• OKC_K_HEADERS_B / OKC_K_LINES_B / OKC_K_ITEMS / OKC_LINE_STYLES_B — the OKC contract header, line, item, and line-style structures used to restrict lines to fixed-asset styled contracts and link to the asset.
• FA_ADDITIONS_B — asset master; supplies asset number and asset ID.
• AP_INVOICES_ALL, AP_INVOICE_PAYMENTS_ALL, AP_CHECKS_ALL — Payables invoice, payment, and check tables supplying amount paid, payment method, check number/date/amount/currency.
• PO_VENDORS — vendor name and vendor ID.
• OKL_STRM_TYPE_TL, FND_APPLICATION, FND_LOOKUPS, FND_GLOBAL, OKC_K_LINES_V, OKL_K_HEADERS — supporting lookups, translations, and language contexts.

Joins are driven by CIN.CNSLD_AP_INV_ID = TPL.CNSLD_AP_INV_ID, with the AP invoice identified through API.REFERENCE_KEY1 and PRODUCT_TABLE = 'OKL_CNSLD_AP_INVS_ALL'. Contract lines are constrained to line style FIXED_ASSET, and items to JTOT_OBJECT1_CODE = 'OKX_ASSET'.

Key Columns

• CONTRACT_NUMBER, ASSET_NUMBER — lease contract and financed asset identity.
• VENDOR_NAME, VENDOR_ID — supplier on the disbursement.
• VENDOR_INVOICE_NUMBER, INVOICE_DATE, INVOICE_TYPE_MEANING — AP invoice descriptors.
• DISBURSEMENT_AMOUNT, AMOUNT_PAID, CHECK_AMOUNT, CHECK_CURRENCY — monetary values spanning the transaction line through to the payment.
• PAYMENT_METHOD, CHECK_NUMBER, CHECK_DATE, CHECK_ID — payment/check detail from AP.
• CNSLD_INV_ID, KHR_ID, ASSET_ID, STY_ID, ORG_ID, CURRENCY_CODE — key identifiers enabling joins back to source entities.

Common Use Cases and Queries

Typical uses include reconciliation of lease disbursements to AP payments, reporting on outstanding versus paid lease invoices, and asset-level spend analysis.

SELECT CONTRACT_NUMBER, ASSET_NUMBER, VENDOR_NAME,
       VENDOR_INVOICE_NUMBER, DISBURSEMENT_AMOUNT,
       AMOUNT_PAID, PAYMENT_METHOD, CHECK_NUMBER, CHECK_DATE
FROM   APPS.OKL_CS_DISBURSEMENTS_UV
WHERE  CONTRACT_NUMBER = :p_contract_number;

A second pattern identifies unpaid or partially paid disbursements:

SELECT CONTRACT_NUMBER, VENDOR_INVOICE_NUMBER,
       DISBURSEMENT_AMOUNT, NVL(AMOUNT_PAID,0) AMOUNT_PAID
FROM   APPS.OKL_CS_DISBURSEMENTS_UV
WHERE  NVL(AMOUNT_PAID,0) < DISBURSEMENT_AMOUNT
AND    ORG_ID = :p_org_id;

Because several joins are outer (notably to STYT, APP, and APC), rows may appear with NULL payment attributes where a disbursement has been recorded but not yet paid — a behavior callers should account for when interpreting results.