Results for “receivables_invoice_id”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_BPD_CONTRACT_INVOICES_V is a consolidated reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the OKL (Lease and Finance Management) product. It presents consolidated invoice information for lease and finance contracts, bridging the consolidated billing structures held in OKL tables with the corresponding receivables transactions in Oracle Receivables. The view is documented as VALID and is classified as a "Consolidated Invoice for Contract" view, reflecting its purpose of exposing a unified picture of invoices generated against lease contracts.

Because the view carries a RECEIVABLES_INVOICE_ID column, it is frequently interrogated by users and developers searching for receivables_invoice_id when they need to trace a lease contract invoice back to its AR customer transaction (CUSTOMER_TRX_ID). This makes the view a useful reconciliation and reporting bridge between the OKL consolidated billing tables and AR_PAYMENT_SCHEDULES_ALL.

Underlying Base Objects

The view is defined over several documented base objects, combined through a UNION of two query branches. The first branch joins AR_PAYMENT_SCHEDULES_ALL, OKL_CNSLD_AR_STRMS_B, OKL_CNSLD_AR_LINES_B, OKL_CNSLD_AR_HDRS_B, OKL_STRM_TYPE_B, and OKC_K_HEADERS_ALL_B. The second branch joins AR_PAYMENT_SCHEDULES_ALL with the OKL_BPD_AR_INV_LINES_V view, OKL_STRM_TYPE_B, and OKC_K_HEADERS_ALL_B. The OKL_BILLING_UTIL_PVT package is also referenced in the metadata as a related object. AR_PAYMENT_SCHEDULES_ALL supplies the receivable schedule data (due dates, amounts, status, currency), keyed on CLASS in ('INV','CM') and joined to the OKL structures via RECEIVABLES_INVOICE_ID = CUSTOMER_TRX_ID. The consolidated AR header, line, and stream tables (OKL_CNSLD_AR_*_B) provide the consolidated invoice number and grouping, while OKL_STRM_TYPE_B supplies the stream type and revenue recognition basis, and OKC_K_HEADERS_ALL_B identifies the contract.

Key Columns

  • CONSOLIDATED_INVOICE_ID — Identifier of the consolidated invoice header in the first branch; in the second branch it is sourced from the AR invoice line's TXD_ID.
  • CONSOLIDATED_INVOICE_NUMBER — Displayable number of the consolidated invoice or AR invoice number.
  • RECEIVABLES_INVOICE_ID — The AR customer transaction identifier; matches CUSTOMER_TRX_ID in AR_PAYMENT_SCHEDULES_ALL. This is the column most commonly searched.
  • CONTRACT_ID — The lease/finance contract (KHR_ID) associated with the invoice.
  • STREAM_TYPE_ID — The billing stream type identifier.
  • REVENUE_REC_BASIS — Accrual flag indicating the revenue recognition basis.
  • DUE_DATE — The scheduled due date of the receivable installment.
  • CURRENCY_CODE — Currency of the invoice.
  • AMOUNT_DUE_ORIGINAL / AMOUNT_DUE_REMAINING — Original and outstanding amounts from the payment schedule.
  • STATUS — Status of the payment schedule installment.

Common Use Cases and Queries

The view supports reconciliation between lease billing and receivables, tracking outstanding balances by contract and stream type, and identifying the AR invoice that corresponds to a given consolidated lease invoice.

To find invoice details by AR transaction:

  • SELECT contract_id, consolidated_invoice_number, due_date, amount_due_remaining, status FROM okl_bpd_contract_invoices_v WHERE receivables_invoice_id = :p_trx_id;

To list outstanding receivables for a contract:

  • SELECT receivables_invoice_id, consolidated_invoice_number, due_date, amount_due_original, amount_due_remaining FROM okl_bpd_contract_invoices_v WHERE contract_id = :p_contract_id AND amount_due_remaining > 0 ORDER BY due_date;

Because the view joins payment schedules restricted to CLASS 'INV' and 'CM', results reflect invoices and credit memos only, which should be considered when aggregating balances.