Search Results ap_invoice_payments_all

Overview

OKL_CS_DISBURSEMENTS_UV is a reporting view owned by the APPS schema within the OKL – Lease and Finance Management product family. It consolidates disbursement activity associated with lease contracts by joining Oracle Payables invoice and payment data to lease contract, asset, and transaction-line structures. The view presents, on a single row per consolidated payables invoice line, the vendor, contract, asset, invoice, and check-level details that a lease administrator requires to reconcile amounts paid against lease obligations.

In Oracle EBS 12.1.1 and 12.2.2, the view serves as a bridge between the OKL lease data model and the AP (Payables) subledger. Because lessees and lessors frequently search for ap_invoice_payments_all when tracing payment records, this view is significant: it internally references AP_INVOICE_PAYMENTS_ALL and AP_CHECKS_ALL, exposing payment method, check number, check date, check amount, and check currency without requiring the user to navigate the raw AP tables. The view is essentially a denormalized disbursement register scoped to lease-related consolidated invoices.

Underlying Base Objects

The view is defined over a union of queries. The documented base objects include:

• OKL_CNSLD_AP_INVS_ALL – consolidated AP invoice headers, supplying vendor invoice number, invoice date, currency, organization, and invoice type.
• OKL_TXL_AP_INV_LNS_ALL_B – transaction-line detail linking consolidated invoices to lease contract lines and contract rights (KHR_ID).
• OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_ITEMS, OKC_LINE_STYLES_B – contract header, line, item, and line-style definitions that identify fixed-asset lease lines.
• FA_ADDITIONS_B – fixed asset additions, providing asset number and asset ID.
• AP_INVOICES_ALL – the source payable invoice, joined by reference key to the consolidated invoice.
• AP_INVOICE_PAYMENTS_ALL and AP_CHECKS_ALL – payment and check records, joined with outer (+) syntax so invoices without payments still appear.
• PO_VENDORS – supplier name lookup.
• OKL_STRM_TYPE_TL – transaction stream type description.
• FND_APPLICATION, FND_LOOKUPS – application and lookup-meaning resolution; FND_GLOBAL supplies the session language via USERENV.

The join is gated by API.PRODUCT_TABLE = 'OKL_CNSLD_AP_INVS_ALL' and FND.APPLICATION_SHORT_NAME = 'OKL', ensuring only lease-originated invoices are returned.

Key Columns

• CONTRACT_NUMBER, ASSET_NUMBER – lease contract and financed asset identifiers.
• VENDOR_NAME, VENDOR_INVOICE_NUMBER, INVOICE_DATE, INVOICE_TYPE_MEANING – supplier and invoice attributes.
• TRANSACTION_TYPE – stream type name describing the disbursement nature.
• DISBURSEMENT_AMOUNT, AMOUNT_PAID – line-level payable amount versus actual amount paid.
• PAYMENT_METHOD, CHECK_NUMBER, CHECK_DATE, CHECK_AMOUNT, CHECK_CURRENCY – payment instrument details sourced from AP_CHECKS_ALL.
• CNSLD_INV_ID, KHR_ID, ASSET_ID, STY_ID, VENDOR_ID, CHECK_ID, ORG_ID – surrogate keys for drill-down and joins.
• CURRENCY_CODE – invoice currency.

Common Use Cases and Queries

Typical scenarios include reconciling lease disbursements to paid checks, auditing unpaid lease invoices, and reporting disbursements by contract or asset. A representative query is:

• SELECT contract_number, asset_number, vendor_name, vendor_invoice_number, check_number, check_amount FROM okl_cs_disbursements_uv WHERE contract_number = :contract;
• SELECT * FROM okl_cs_disbursements_uv WHERE check_id IS NULL; — identifies disbursements with no payment applied.
• SELECT contract_number, SUM(check_amount) FROM okl_cs_disbursements_uv GROUP BY contract_number; — aggregates paid amounts per lease.

Because the view already joins AP_INVOICE_PAYMENTS_ALL, it is generally preferred over querying that table directly when the reporting context is lease and finance management.