Search Results ra_customer_trx_lines_all




Overview
Explore in AI Chat

Overview

OKL_RCPT_INVOICE_LINES_UV is a PL/SQL-view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2, delivered as part of the OKL — Lease and Finance Management product family. Its purpose, per Oracle's ETRM documentation, is to fetch the open invoice lines for a contract, an investor agreement, a termination quote, or non-OKL invoices. In practice the view consolidates Accounts Receivable transaction lines with lease-specific contract, asset, stream, and termination-quote attributes so that receipts application, cash matching, and lease accounting processes can present a single, unified list of invoice lines that still carry a balance.

Because the user query referenced ra_customer_trx_lines_all, it is worth clarifying that OKL_RCPT_INVOICE_LINES_UV is not a replacement for that table. Rather, the view reads RA_CUSTOMER_TRX_LINES_ALL together with RA_CUSTOMER_TRX_ALL and AR_PAYMENT_SCHEDULES_ALL and enriches each row with lease contract context. It therefore bridges the core Receivables data model and the OKL lease sub-ledger, which is why it is heavily used in lease receipt and invoice reporting rather than in standard AR reporting.

Underlying Base Objects

The documented view text joins AR_PAYMENT_SCHEDULES_ALL, RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL, OKL_TXD_AR_LN_DTLS_B, OKC_K_HEADERS_ALL_B, OKL_TRX_QUOTES_ALL_B, OKL_TRX_AR_INVOICES_B, and OKL_TXL_AR_INV_LNS_B. The ETRM 12.2.2 metadata additionally lists OKL_CNSLD_AR_HDRS_ALL_B, OKL_CNSLD_AR_LINES_B, OKL_CNSLD_AR_STRMS_B, and OKL_STRM_TYPE_TL among the referenced objects, all accessed through APPS synonyms.

  • RA_CUSTOMER_TRX_ALL / RA_CUSTOMER_TRX_LINES_ALL — supply the invoice header, line number, currency, extended amount, and amount_due_remaining.
  • AR_PAYMENT_SCHEDULES_ALL — supplies due dates and terms sequence numbers for each installment.
  • OKC_K_HEADERS_ALL_B — the contract header, providing contract number and KHR identifier.
  • OKL_TXD_AR_LN_DTLS_B — the OKL transaction detail link, giving KLE identifier and stream type identifier (STY_ID).
  • OKL_TRX_QUOTES_ALL_B — termination quote header information (quote number and ID).
  • OKL_TRX_AR_INVOICES_B / OKL_TXL_AR_INV_LNS_B — OKL invoice and line staging tables used to relate AR lines back to lease invoices.

Key Columns

The projection exposes identifiers plus computed monetary balances. Notable columns include:

Common Use Cases and Queries

Typical scenarios include displaying open lease invoice lines during receipt application, reconciling termination quote balances, and reporting outstanding tax balances on lease invoices. A basic query to list open lines for a contract would be:

SELECT INVOICE_NUMBER, INVOICE_LINE_NUMBER, INVOICE_DUE_DATE,
       AMOUNT_DUE_REMAINING, LINE_BALANCE, TAX_BALANCE,
       CURRENCY_CODE, CONTRACT_NUMBER, ASSET_NUMBER
FROM   APPS.OKL_RCPT_INVOICE_LINES_UV
WHERE  AMOUNT_DUE_REMAINING > 0
AND    CONTRACT_NUMBER = :p_contract_number
ORDER  BY INVOICE_DUE_DATE, INVOICE_LINE_NUMBER;

For investor agreement or termination quote review, filtering on TERM_QUOTE_NUMBER or ORG_ID narrows results to the relevant operating unit. Because the view computes balances with correlated subqueries against RA_CUSTOMER_TRX_LINES_ALL, queries should restrict ORG_ID and date ranges to avoid full scans and should avoid joining the view back to its own base tables.