Search Results line_tax_applied

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):

• AR_CASH_RECEIPTS_ALL — source of CASH_RECEIPT_ID and RECEIPT_NUMBER.
• AR_RECEIVABLE_APPLICATIONS_ALL — source of the application amounts (AMOUNT, TAX), GL_DATE, APPLY_DATE, RECEIVABLE_APPLICATION_ID, and the applied transaction reference.
• AR_PAYMENT_SCHEDULES_ALL — source of invoice number, transaction date, due date, and invoice currency.
• RA_CUSTOMER_TRX_ALL — header-level transaction context used to resolve the receivables invoice ID.
• RA_CUSTOMER_TRX_LINES_ALL — line-level source of AMOUNT_DUE_REMAINING, LINE_TYPE, LINE_NUMBER, INTERFACE_LINE_CONTEXT, and INTERFACE_LINE_ATTRIBUTE1/6/7/9; also the join target for the TAX_BALANCE subquery.
• OKL_CNSLD_AR_LINES_B and OKL_CNSLD_AR_STRMS_B — OKL consolidated receivables line and stream tables, used to derive the lease stream sequence number (LINE_NUMBER).

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

• TAX_APPLIED — the tax portion of the amount applied on the line, sourced from ARL.TAX.
• LINE_APPLIED — the principal applied (ARL.AMOUNT).
• LINE_TAX_APPLIED — ARL.AMOUNT + ARL.TAX, the total applied including tax.
• TAX_BALANCE — sum of AMOUNT_DUE_REMAINING across tax lines linked to the customer transaction line.
• LINE_BALANCE — remaining amount due on the line.
• INVOICE_NUMBER — derived via DECODE on INTERFACE_LINE_CONTEXT ('OKL_CONTRACTS' path uses INTERFACE_LINE_ATTRIBUTE1 as fallback).
• ASSET_NUMBER, STREAM_TYPE, CONTRACT_NUMBER — extracted from INTERFACE_LINE_ATTRIBUTE7, 9, and 6 respectively when the line context is 'OKL_CONTRACTS' or 'OKL_MANUAL'.
• TRANS_TO_RECEIPT_RATE — currency conversion rate, defaulted to 1 via NVL.
• Other columns include RECEIPT_NUMBER, APPLY_DATE, GL_DATE, INVOICE_DATE, DUE_DATE, INVOICE_CURRENCY_CODE, LINE_TYPE, LINE_NUMBER, and RECEIVABLE_APPLICATION_ID.

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;