Search Results line_tax_amount

Overview

APPS.OKL_RCPT_INVOICE_LINES_UV is a reporting view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that consolidates Accounts Receivable (AR) invoice and invoice-line data originating from Oracle Lease and Finance Management (OKL) contract and manual receipt transactions. It presents a unified, query-friendly projection of invoice header and line attributes joined to lease contract headers and transaction quotes, allowing downstream reporting, reconciliation, and integration processes to retrieve receipt-related invoice line details without navigating the raw transactional schema directly.

The view is particularly relevant to flows associated with the OKL_MANUAL interface header and line contexts, which represent manually entered lease invoice transactions, alongside the OKL_CONTRACTS context used for contract-generated invoices. By exposing both invoice number and line-level identifiers together with balances, tax amounts, and contract linkage, the view supports reconciliation between AR transactions and the lease management subledger.

Underlying Base Objects

The view is defined over a set of AR and OKL base tables and synonyms, joined on invoice, line, and contract identifiers. The documented objects include:

• AR_PAYMENT_SCHEDULES_ALL — supplies due dates and payment terms sequencing.
• RA_CUSTOMER_TRX_ALL — the AR invoice header.
• RA_CUSTOMER_TRX_LINES_ALL — AR invoice lines, including tax lines.
• OKC_K_HEADERS_ALL_B — contract headers, providing contract number.
• OKL_TXD_AR_LN_DTLS_B — transaction line detail linking AR lines to lease streams.
• OKL_TRX_AR_INVOICES_B and OKL_TXL_AR_INV_LNS_B — OKL AR invoice and line associations.
• OKL_TRX_QUOTES_ALL_B — transaction quote references for line items.
• OKL_STRM_TYPE_TL, OKL_CNSLD_AR_HDRS_ALL_B, OKL_CNSLD_AR_LINES_B, OKL_CNSLD_AR_STRMS_B — supporting consolidated AR stream and type metadata.

Joins are established between RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL on CUSTOMER_TRX_ID, and between the invoice and AR_PAYMENT_SCHEDULES_ALL on the same key. OKL-specific links bridge AR lines back to lease contract and stream detail via KHR_ID, KLE_ID, and STY_ID.

Key Columns

• INVOICE_NUMBER / INVOICE_ID — AR transaction number and identifier.
• INVOICE_LINE_ID / INVOICE_LINE_NUMBER — the specific AR invoice line.
• INVOICE_DATE / INVOICE_DUE_DATE — transaction date and payment due date.
• CURRENCY_CODE, ORG_ID, BILL_TO_CUSTOMER_ID — standard AR context attributes.
• AMOUNT_DUE_ORIGINAL / AMOUNT_DUE_REMAINING — line amounts, inclusive of linked tax line amounts via correlated subqueries.
• LINE_BALANCE / TAX_BALANCE / LINE_TAX_AMOUNT — remaining balance of the principal line and any associated tax lines.
• CONTRACT_NUMBER, KHR_ID, KLE_ID, STY_ID — lease contract and stream linkage.
• ASSET_NUMBER (from interface_line_attribute7) and STREAM_TYPE (from interface_line_attribute9) — lease-specific attributes.
• TERM_QUOTE_ID / TERM_QUOTE_NUMBER — originating quote reference.
• LINE_TYPE — literal 'LINE' identifier.

Common Use Cases and Queries

Typical use cases include reporting on outstanding lease invoice lines, reconciling manually entered (OKL_MANUAL) invoices against contract-generated invoices, and extracting line-level balances for cash application analytics.

• Identify remaining balances by contract: SELECT contract_number, invoice_number, line_balance, tax_balance FROM okl_rcpt_invoice_lines_uv ORDER BY contract_number;
• List invoices tied to a specific customer: SELECT invoice_number, invoice_date, amount_due_remaining FROM okl_rcpt_invoice_lines_uv WHERE bill_to_customer_id = :p_customer_id;
• Reconcile stream-level detail: SELECT invoice_number, stream_type, asset_number FROM okl_rcpt_invoice_lines_uv WHERE sty_id IS NOT NULL;

The view is read-only and can be safely joined to other OKL reporting views for consolidated analysis.