Search Results amount_line_items_original




Overview
Explore in AI Chat

Overview

The APPS.OKL_CS_BILLINGTRX_UV view is a reporting construct within the Oracle E-Business Suite (EBS) Lease and Financial Management modules, specifically part of the ETRM (Enterprise Transaction and Reporting Model) family. It exposes billing transaction details for contracts managed by Oracle Lease Management (OKL) and Oracle Contracts (OKC), consolidating invoice lines, payment schedule data, asset information, and contract header attributes into a single denormalized result set. Its name follows the common EBS convention of a "_UV" suffix, indicating it is a user-facing view intended for ad-hoc queries, extracts, and integration lookups rather than direct transactional processing.

The view is relevant to both 12.1.1 and 12.2.2 releases; underlying metadata is consistent with the ETRM 12.2.2 documentation. Because it synthesizes data across lease contracts, AR invoices, and fixed assets, it is typically consumed by reporting tools, custom concurrent programs, and OBIEE/BI Publisher data models.

Underlying Base Objects

The view is defined over a UNION ALL of two principal query branches. The first branch joins OKL_CS_BPD_INV_DTL_V (the core billing transaction detail view) to the following documented base objects:

The second UNION ALL branch invokes OKL_CS_LC_CONTRACT_PVT, OKL_BILLING_UTIL_PVT, and FND_GLOBAL to cover lease-contract scenarios not captured by the fixed-asset branch. These package calls broaden the view's applicability across contract subtypes.

Key Columns

Several columns are particularly relevant to users searching for billing amount data, including the alias AMOUNT_LINE_ITEMS_ORIGINAL:

Common Use Cases and Queries

Typical uses include reconciling lease billing lines to AR invoices, reporting original versus remaining amounts by asset or contract, and feeding downstream analytics. A representative query targeting the searched column is:

SELECT contract_number,
       invoice_number,
       transaction_type,
       amount_line_items_original,
       amount_line_items_remaining,
       currency_code
FROM   apps.okl_cs_billingtrx_uv
WHERE  contract_number = :p_contract_number
ORDER  BY invoice_date;

To aggregate original line amounts per asset:

SELECT asset_number,
       SUM(amount_line_items_original) AS total_original
FROM   apps.okl_cs_billingtrx_uv
GROUP  BY asset_number;

Because the view relies on USERENV('LANG') and session context through FND_GLOBAL, results should be retrieved within a properly initialized EBS session (for example, through a concurrent program or OA Framework page) to ensure accurate transaction type names and organization context.