Results for “fnd_type”

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

Overview

APPS.OKL_CS_DISBURSEMENTS_UV is a union-based reporting view within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module, part of the Enterprise Contracts and Transactional Management (ETRM) product family. It exposes consolidated disbursement information tied to lease and finance contracts, joining AP invoice, payment, contract, and fixed asset data into a single denormalized structure. The view's primary role is to support operational and analytical reporting on disbursements against contract lines — particularly those linked to fixed assets — and to provide visibility into the payable invoice type assigned to each consolidated invoice.

The _UV suffix (User View) indicates a reporting-oriented view surfaced to end users and integrators rather than a transactional base table. It is not intended for direct DML; it serves read-only queries in reports, concurrent programs, and downstream integrations such as Oracle Financials reconciliation and asset accounting.

Underlying Base Objects

The view is defined over a substantial join across the OKL (Lease Management), OKC (Contracts Core), FA (Fixed Assets), AP (Payables), and FND (Application Object Library) schemas. The documented referenced base objects include:

• OKL_CNSLD_AP_INVS_ALL — Consolidated AP invoices, the driving table (CIN), supplying invoice type, vendor invoice number, and org context.
• OKL_TXL_AP_INV_LNS_ALL_B — Invoice transaction lines (TPL), providing disbursement amounts and contract line (kle_id) linkage.
• OKL_STRM_TYPE_TL — Stream/transaction type translatable names (STYT) for the transaction type description.
• OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_K_LINES_V, OKC_K_ITEMS, OKC_LINE_STYLES_B, OKL_K_HEADERS — Contract header, line, item, and line-style structures that connect disbursements to contract lines, including the lty_code = 'FIXED_ASSET' filter.
• FA_ADDITIONS_B — Fixed asset master (FAA), linking contract items (via jtot_object1_code = 'OKX_ASSET') to asset_id and asset_number.
• AP_INVOICES_ALL, AP_INVOICE_PAYMENTS_ALL, AP_CHECKS_ALL — Payables invoice, payment, and check/payment records supplying amount paid, payment method, check number, check date, check amount, and currencies.
• PO_VENDORS — Vendor master providing vendor_name and vendor_id.
• FND_APPLICATION, FND_LOOKUPS — The FND_LOOKUPS join resolves CIN.INVOICE_TYPE against lookup type OKL_PAYABLES_INVOICE_TYPE to produce INVOICE_TYPE_MEANING. The FND_APPLICATION join restricts to application_short_name = 'OKL' with product_table = 'OKL_CNSLD_AP_INVS_ALL'.

Most OKL, OKC, and AP objects are referenced via synonyms. A UNION combines a fixed-asset-linked branch with a second branch returning NULL asset_number, broadening coverage to disbursements not tied to fixed assets.

Key Columns

• CONTRACT_NUMBER — Contract identifier from OKC_K_HEADERS_B.
• ASSET_NUMBER, ASSET_ID — Fixed asset identifiers from FA_ADDITIONS_B.
• VENDOR_NAME, VENDOR_ID — Payee vendor from PO_VENDORS.
• TRANSACTION_TYPE — Stream type name from OKL_STRM_TYPE_TL.
• VENDOR_INVOICE_NUMBER, INVOICE_DATE, CNSLD_INV_ID — AP invoice reference and consolidated invoice key.
• DISBURSEMENT_AMOUNT — Amount from the transaction line (TPL.AMOUNT).
• AMOUNT_PAID — Paid amount from AP_INVOICES_ALL.
• PAYMENT_METHOD, CHECK_NUMBER, CHECK_DATE, CHECK_AMOUNT, CHECK_CURRENCY, CHECK_ID — Payment/check detail from AP_CHECKS_ALL.
• KHR_ID, STY_ID, ORG_ID, CURRENCY_CODE — Contract header, stream type, operating unit, and invoice currency.
• INVOICE_TYPE_MEANING — Decoded meaning of OKL_PAYABLES_INVOICE_TYPE, the specific lookup the user searched for.

Common Use Cases and Queries

Typical uses include reconciling lease disbursements to AP payments, reporting fixed-asset-linked disbursements, and validating invoice type classification.

• Disbursement-to-payment reconciliation by contract and vendor.
• Invoice type breakdown using INVOICE_TYPE_MEANING.
• Asset-linked disbursement audit for fixed-asset contract lines.

Sample query:

SELECT contract_number, vendor_name, invoice_type_meaning, disbursement_amount, amount_paid, check_number, check_date FROM apps.okl_cs_disbursements_uv WHERE invoice_type_meaning = '<type>' AND org_id = :p_org_id;