Search Results okl_cs_disbursements_uv




Overview
Explore in AI Chat

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:

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

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.