Search Results line_applied




Overview
Explore in AI Chat

Overview

OKL_RECEIPT_APPLICATIONS_UV is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It belongs to the OKL – Leasing and Finance Management product and serves as a unified reporting and integration interface that joins Oracle Receivables receipt and application data with Oracle Lease Management (OKL) contract line attributes. The view presents, at the individual application-line grain, how cash receipts have been applied against lease invoices, exposing both the principal applied and the tax applied for each application. It is primarily consumed by lease reporting, reconciliation, and downstream integration programs that need to reconcile AR cash application activity back to OKL contract streams, assets, and consolidated receivable lines.

The view is especially relevant when the search term is tax_applied: it explicitly exposes a TAX_APPLIED column (ARL.TAX) plus a derived LINE_TAX_APPLIED column (ARL.AMOUNT + ARL.TAX), and a TAX_BALANCE figure summed from tax lines linked to the customer transaction line.

Underlying Base Objects

The view is defined over the following documented base objects (all referenced as APPS synonyms):

Joins are anchored on CASH_RECEIPT_ID, APPLIED_CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, and LINK_TO_CUST_TRX_LINE_ID, producing a flattened application-level record.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciling lease receipts to applied invoices, auditing tax application against tax balances, and feeding downstream lease accounting integrations.

To list tax applied per receipt:

  • SELECT RECEIPT_NUMBER, INVOICE_NUMBER, LINE_APPLIED, TAX_APPLIED, LINE_TAX_APPLIED FROM APPS.OKL_RECEIPT_APPLICATIONS_UV WHERE TAX_APPLIED > 0;

To compare applied tax against remaining tax balance by contract:

  • SELECT CONTRACT_NUMBER, ASSET_NUMBER, STREAM_TYPE, SUM(TAX_APPLIED) APPLIED, SUM(TAX_BALANCE) REMAINING FROM APPS.OKL_RECEIPT_APPLICATIONS_UV GROUP BY CONTRACT_NUMBER, ASSET_NUMBER, STREAM_TYPE;

To trace applications by currency and date:

  • SELECT RECEIPT_NUMBER, APPLY_DATE, INVOICE_CURRENCY_CODE, (LINE_APPLIED + TAX_APPLIED) TOTAL_APPLIED FROM APPS.OKL_RECEIPT_APPLICATIONS_UV WHERE APPLY_DATE BETWEEN :p_from AND :p_to;