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.
-
Consolidated Invoice for Contract
APPS.OKL_BPD_CONTRACT_INVOICES_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ OKC_K_HEADERS_ALL_B·↳ OKL_BILLING_UTIL_PVT·Explore OKL module →
-
View: OKL_BPD_INV_SRCH_V 12.2.2
View for Search page Details -- Context region.
APPS.OKL_BPD_INV_SRCH_V·↳ ARP_ADDR_LABEL_PKG·↳ ARP_ADDR_PKG·↳ AR_ADDRESSES_V·Explore OKL module →
-
APPS.OKL_BPD_RECEIPT_APPLIC_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ FA_ADDITIONS_V·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
APPS.OKL_BPD_RECEIPT_APPLIC_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ FA_ADDITIONS_V·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
Consolidated Invoice for Contract
APPS.OKL_BPD_CONTRACT_INVOICES_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ OKC_K_HEADERS_ALL_B·↳ OKL_BILLING_UTIL_PVT·Explore OKL module →
-
APPS.OKL_BPD_PAYMENT_HISTORY_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ AR_RECEIVABLE_APPLICATIONS_ALL·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
View: OKL_BPD_INV_SRCH_V 12.1.1
View for Search page Details -- Context region.
APPS.OKL_BPD_INV_SRCH_V·↳ ARP_ADDR_LABEL_PKG·↳ ARP_ADDR_PKG·↳ AR_ADDRESSES_V·Explore OKL module →
-
Transaction lines to be included into Receivables invoices
-
Transaction lines to be included into Receivables invoices
-
View: OKL_BPD_AR_INV_LINES_V 12.2.2
View to display Payable Invoice Line details.
APPS.OKL_BPD_AR_INV_LINES_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ OKL_BILLING_UTIL_PVT·↳ OKL_STRM_TYPE_B·Explore OKL module →
-
Lowest level transaction included into consolidated bill
-
View: OKL_TXL_AR_INV_LNS_UV 12.2.2
APPS.OKL_TXL_AR_INV_LNS_UV·↳ OKC_K_LINES_B·↳ OKL_TXL_AR_INV_LNS_B·↳ OKL_TXL_AR_INV_LNS_TL·Explore OKL module →
-
APPS.OKL_BPD_LEASING_PAYMENT_TRX_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKL module →
-
Lowest level transaction included into consolidated bill
-
View: OKL_BPD_AR_INV_LINES_V 12.1.1
View to display Payable Invoice Line details.
APPS.OKL_BPD_AR_INV_LINES_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ OKL_BILLING_UTIL_PVT·↳ OKL_STRM_TYPE_B·Explore OKL module →
-
View: OKL_EXT_SELL_INVS_V 12.1.1
External Transactions Header for Billing records
APPS.OKL_EXT_SELL_INVS_V·↳ OKL_EXT_SELL_INVS_B·↳ OKL_EXT_SELL_INVS_TL·Explore OKL module →
-
View: OKL_TXD_AR_LN_DTLS_V 12.2.2
Transaction line details to be included into Receivables invoices
APPS.OKL_TXD_AR_LN_DTLS_V·↳ OKL_TXD_AR_LN_DTLS_B·↳ OKL_TXD_AR_LN_DTLS_TL·Explore OKL module →
-
View: OKL_TXL_AR_INV_LNS_UV 12.1.1
APPS.OKL_TXL_AR_INV_LNS_UV·↳ OKC_K_LINES_B·↳ OKL_TXL_AR_INV_LNS_B·↳ OKL_TXL_AR_INV_LNS_TL·Explore OKL module →
-
View: OKL_CNSLD_AR_STRMS_V 12.1.1
Lowest level transaction included into consolidated bill
APPS.OKL_CNSLD_AR_STRMS_V·↳ OKL_CNSLD_AR_STRMS_B·↳ OKL_CNSLD_AR_STRMS_TL·Explore OKL module →
-
View: OKL_TXL_AR_INV_LNS_V 12.2.2
Transaction lines to be included into Receivables invoices
APPS.OKL_TXL_AR_INV_LNS_V·↳ OKL_TXL_AR_INV_LNS_B·↳ OKL_TXL_AR_INV_LNS_TL·Explore OKL module →
-
View: OKL_EXT_SELL_INVS_V 12.2.2
External Transactions Header for Billing records
APPS.OKL_EXT_SELL_INVS_V·↳ OKL_EXT_SELL_INVS_B·↳ OKL_EXT_SELL_INVS_TL·Explore OKL module →
-
External transactions header table for Billing records. It stores data ready for AR Interface.
-
View: OKL_CNSLD_AR_STRMS_V 12.2.2
Lowest level transaction included into consolidated bill
APPS.OKL_CNSLD_AR_STRMS_V·↳ OKL_CNSLD_AR_STRMS_B·↳ OKL_CNSLD_AR_STRMS_TL·Explore OKL module →
-
APPS.OKL_BPD_PAYMENT_HISTORY_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ AR_RECEIVABLE_APPLICATIONS_ALL·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
Transaction line details to be included into Receivables invoices
-
APPS.OKL_BPD_LEASING_PAYMENT_TRX_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKL module →
-
View: OKL_TXL_AR_INV_LNS_V 12.1.1
Transaction lines to be included into Receivables invoices
APPS.OKL_TXL_AR_INV_LNS_V·↳ OKL_TXL_AR_INV_LNS_B·↳ OKL_TXL_AR_INV_LNS_TL·Explore OKL module →
-
View: OKL_TXD_AR_LN_DTLS_V 12.1.1
Transaction line details to be included into Receivables invoices
APPS.OKL_TXD_AR_LN_DTLS_V·↳ OKL_TXD_AR_LN_DTLS_B·↳ OKL_TXD_AR_LN_DTLS_TL·Explore OKL module →
-
Transaction line details to be included into Receivables invoices
-
View: OKL_TRX_AR_INVOICES_V 12.1.1
Collection of all OKL transaction which generate Receivables invoices
APPS.OKL_TRX_AR_INVOICES_V·↳ OKL_TRX_AR_INVOICES_B·↳ OKL_TRX_AR_INVOICES_TL·Explore OKL module →
-
External transactions header table for Billing records. It stores data ready for AR Interface.
-
View: OKL_TRX_AR_INVOICES_V 12.2.2
Collection of all OKL transaction which generate Receivables invoices
APPS.OKL_TRX_AR_INVOICES_V·↳ OKL_TRX_AR_INVOICES_B·↳ OKL_TRX_AR_INVOICES_TL·Explore OKL module →
-
Collection of all OKL transaction which generate Receivables invoices
-
Collection of all OKL transaction which generate Receivables invoices