Search Results term_quote_id

Overview

OKL_RCPT_INVOICE_LINES_UV is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL – Leasing and Finance Management module. Its purpose, as documented in the ETRM metadata, is to fetch the open invoice lines for a contract, an investor agreement, a termination quote, or non-OKL invoices. In practice the view acts as a consolidated receivables line source, joining standard Oracle Receivables transaction tables (RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL, AR_PAYMENT_SCHEDULES_ALL) to leasing-specific transaction tables so that invoice lines raised against leased assets, contracts, and quotes can be reported together with their outstanding balances.

The suffix "_UV" indicates a user-facing or "user view" object, typically consumed by Oracle Leasing forms, concurrent programs, and customer-facing inquiries rather than by direct transactional processing. Because it exposes both original and remaining amounts at the line level, it is frequently the starting point for receipt application, aging, and collections reporting within the leasing module. Users who search for RA_CUSTOMER_TRX_LINES_ALL while investigating leasing invoice balances are commonly routed to this view, since it wraps that base table and enriches it with leasing context.

Underlying Base Objects

The view is defined over the following documented base objects, each referenced through an APPS synonym: AR_PAYMENT_SCHEDULES_ALL, OKC_K_HEADERS_ALL_B, OKL_CNSLD_AR_HDRS_ALL_B, OKL_CNSLD_AR_LINES_B, OKL_CNSLD_AR_STRMS_B, OKL_STRM_TYPE_TL, OKL_TRX_AR_INVOICES_B, OKL_TRX_QUOTES_ALL_B, OKL_TXD_AR_LN_DTLS_B, OKL_TXL_AR_INV_LNS_B, RA_CUSTOMER_TRX_ALL, and RA_CUSTOMER_TRX_LINES_ALL.

The core join path links RA_CUSTOMER_TRX_ALL to RA_CUSTOMER_TRX_LINES_ALL on CUSTOMER_TRX_ID, and then to AR_PAYMENT_SCHEDULES_ALL to obtain due dates and terms sequencing. OKL-specific tables supply the leasing dimensions: OKC_K_HEADERS_ALL_B provides the contract number and KHR_ID; OKL_TXD_AR_LN_DTLS_B supplies the KLE_ID, STY_ID, and asset and stream identifiers carried on the receivables interface line attributes; OKL_TRX_QUOTES_ALL_B supplies termination quote identifiers and quote numbers; and OKL_TRX_AR_INVOICES_B with OKL_TXL_AR_INV_LNS_B and the consolidated AR tables (OKL_CNSLD_AR_HDRS_ALL_B, OKL_CNSLD_AR_LINES_B, OKL_CNSLD_AR_STRMS_B) provide the OKL invoice header and stream context used for grouping and investor agreement reporting. The view therefore bridges the AR subledger and the OKL leasing subledger, which is why it is a preferred integration point for leasing invoice extracts.

Key Columns

• INVOICE_NUMBER / INVOICE_ID – Transaction number and CUSTOMER_TRX_ID from RA_CUSTOMER_TRX_ALL, identifying the AR invoice.
• INVOICE_LINE_ID / INVOICE_LINE_NUMBER – CUSTOMER_TRX_LINE_ID and LINE_NUMBER from RA_CUSTOMER_TRX_LINES_ALL, uniquely identifying the invoice line.
• INVOICE_DATE / INVOICE_DUE_DATE / TERMS_SEQUENCE_NUMBER – Transaction date from RA_CUSTOMER_TRX_ALL and the due date and payment terms sequencing from AR_PAYMENT_SCHEDULES_ALL.
• ORG_ID, CURRENCY_CODE, BILL_TO_CUSTOMER_ID – Operating unit, invoice currency, and bill-to customer for multi-org and multi-currency reporting.
• LINE_TYPE – Set to 'LINE' for the primary invoice line; tax lines are aggregated separately.
• AMOUNT_DUE_ORIGINAL – Extended amount of the line plus the sum of any linked lines (for example, associated charges), giving the original open amount.
• AMOUNT_DUE_REMAINING – Remaining balance of the line plus the sum of remaining amounts on linked lines.
• LINE_BALANCE / TAX_BALANCE – Line-level remaining amount and the aggregated remaining amount for linked tax lines (LINE_TYPE = 'TAX').
• CONTRACT_NUMBER, KHR_ID, KLE_ID, STY_ID – Leasing contract, header, line, and stream identifiers from OKL tables.
• ASSET_NUMBER, STREAM_TYPE – Populated from INTERFACE_LINE_ATTRIBUTE7 and INTERFACE_LINE_ATTRIBUTE9 on RA_CUSTOMER_TRX_LINES_ALL.
• TERM_QUOTE_ID / TERM_QUOTE_NUMBER – Termination quote reference from OKL_TRX_QUOTES_ALL_B.
• INVESTOR_AGREEMENT_NUMBER / INVESTOR_AGREEMENT_ID – Reserved for investor agreement reporting and returned as NULL in the documented view text.

Common Use Cases and Queries

Typical uses include open-item aging for leased assets, reconciliation of AR invoice lines to leasing contracts, collection follow-up on termination quotes, and extraction of invoice lines for investor reporting. Because the view already computes remaining balances and tax balances, reports avoid re-deriving these amounts from RA_CUSTOMER_TRX_LINES_ALL.

A representative query retrieving open invoice lines for a contract is shown below.

• SELECT invoice_number, invoice_line_number, contract_number, asset_number, currency_code, amount_due_remaining, line_balance, tax_balance FROM okl_rcpt_invoice_lines_uv WHERE contract_number = :p_contract AND amount_due_remaining > 0 ORDER BY invoice_date, invoice_line_number;
• SELECT invoice_number, invoice_line_id, invoice_due_date, amount_due_original, amount_due_remaining FROM okl_rcpt_invoice_lines_uv WHERE org_id = :p_org_id AND term_quote_number IS NOT NULL ORDER BY invoice_due_date;

When extending such queries, filter on ORG_ID for multi-org security and on LINE_TYPE to separate principal lines from tax aggregates. Joining back to RA_CUSTOMER_TRX_LINES_ALL on INVOICE_LINE_ID allows drill-down to descriptive flexfield and line attribute detail not surfaced by the view itself.