Results for “tld_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_BPD_AR_INV_LN_DTLS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL – Leasing and Finance Management product family. Its documented purpose is to support the Oracle Lease Management "Search Invoice" page, presenting invoice line detail that combines lease contract structure, consolidated receivables streams, and Oracle Receivables payment schedules into a single denormalized result set. The view acts as the integration point between the leasing data model (contract, stream, consolidated AR line) and the Receivables data model (transaction, payment schedule, application), allowing the billing and invoice inquiry UI to display receivables balances and applied amounts without requiring the calling form to join across both schemas directly.
Because it is a view rather than a table, it holds no data of its own and reflects the current state of the underlying tables at query time. In 12.1.1 and 12.2.2 it remains VALID and is referenced by the OKL billing/AR invoice pages and by any custom report or interface that needs lease-level receivables detail.
Underlying Base Objects
The view is defined over a mixture of OKL leasing tables and Receivables tables, joined primarily through RECEIVABLES_INVOICE_ID / CUSTOMER_TRX_ID linkage:
- OKL_CNSLD_AR_HDRS_B, OKL_CNSLD_AR_LINES_B, OKL_CNSLD_AR_STRMS_B – consolidated AR header, line, and stream tables that anchor the lease billing structure.
- AR_PAYMENT_SCHEDULES_ALL (PS) – the primary receivables source, restricted to CLASS in ('INV','CM').
- AR_RECEIVABLE_APPLICATIONS_ALL – used in correlated subqueries to compute cash and credit memo applications.
- OKC_K_HEADERS_B – the contract header, outer-joined via CN.ID (+) = ST.KHR_ID, supplying CONTRACT_NUMBER.
- OKL_INVC_LINE_TYPES_V, OKL_STRM_TYPE_V, FND_LOOKUPS – lookup and stream type descriptive sources.
- RA_CUSTOMER_TRX_LINES_ALL, HZ_CUST_ACCOUNTS – transaction line and customer account context.
- OKL_BPD_AR_INV_LINES_V plus packages OKL_ACCOUNTING_UTIL, OKL_BILLING_UTIL_PVT, and FND_GLOBAL are also documented as referenced.
Key Columns
- CONTRACT_NUMBER / CONTRACT_LINE_ID – lease contract header and contract line identity.
- CONSOLIDATED_LINE_NUMBER, LINE_NAME – consolidated line sequencing and invoice line type name.
- AMOUNT_DUE_ORIGINAL, AMOUNT_PAID, BALANCE – summing PS.AMOUNT_DUE_ORIGINAL and AMOUNT_DUE_REMAINING to derive invoiced, paid, and outstanding values.
- AMOUNT_APPLIED, AMOUNT_CREDITED – correlated subquery sums over AR_RECEIVABLE_APPLICATIONS_ALL filtered by APPLICATION_TYPE 'CASH' and 'CM' respectively.
- TAX_AMOUNT, CURRENCY_CODE – tax and currency context.
- RECEIVABLES_INVOICE_NUMBER, CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID – Receivables transaction linkage.
- STREAM_TYPE, STREAM_PURPOSE_MEANING – lease stream classification and purpose.
- TXN_LINE_TYPE – exposed as a literal NULL; retained as a placeholder column for the invoice search page and not populated from a base attribute.
Common Use Cases and Queries
Typical uses include invoice search page back-ends, lease receivables aging reports, and reconciliation extracts feeding downstream systems. A representative query retrieves invoice line balances for a contract:
- Filter by contract: SELECT CONTRACT_NUMBER, CONSOLIDATED_LINE_NUMBER, RECEIVABLES_INVOICE_NUMBER, AMOUNT_DUE_ORIGINAL, AMOUNT_PAID, BALANCE FROM OKL_BPD_AR_INV_LN_DTLS_V WHERE CONTRACT_NUMBER = :p_contract.
- Open-item analysis: SELECT CUSTOMER_TRX_ID, SUM(BALANCE) FROM OKL_BPD_AR_INV_LN_DTLS_V GROUP BY CUSTOMER_TRX_ID HAVING SUM(BALANCE) > 0.
- Cash versus credit memo split: SELECT STREAM_TYPE, STREAM_PURPOSE_MEANING, AMOUNT_APPLIED, AMOUNT_CREDITED FROM OKL_BPD_AR_INV_LN_DTLS_V WHERE ORG_ID = :p_org_id.
Because of the correlated subqueries and multi-table join, queries should be constrained by ORG_ID, CONTRACT_NUMBER, or CUSTOMER_TRX_ID to avoid full-scan performance degradation on large lease portfolios.
-
View for Search invoice Page Details.
APPS.OKL_BPD_AR_INV_LN_DTLS_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ AR_RECEIVABLE_APPLICATIONS_ALL·↳ FND_GLOBAL·Explore OKL module →
-
The transaction table for "bill" type transactions, where cash receipts are expected
-
View: OKL_XTL_SELL_INVS_V 12.2.2
The transaction table for "bill" type transactions, where cash receipts are expected
APPS.OKL_XTL_SELL_INVS_V·↳ OKL_XTL_SELL_INVS_B·↳ OKL_XTL_SELL_INVS_TL·Explore OKL module →
-
View: OKL_BPD_TLD_AR_LINES_V 12.1.1
View on TLD and receivables lines for variable rate and bill status API and remarketing view.
APPS.OKL_BPD_TLD_AR_LINES_V·↳ OKL_BILLING_UTIL_PVT·↳ OKL_TRX_AR_INVOICES_B·↳ OKL_TRX_AR_INVOICES_TL·Explore OKL module →
-
The transaction table for "bill" type transactions, where cash receipts are expected
-
Transaction lines to be included into Payables invoices
-
View for Search invoice Page Details.
APPS.OKL_BPD_AR_INV_LN_DTLS_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ AR_RECEIVABLE_APPLICATIONS_ALL·↳ FND_GLOBAL·Explore OKL module →
-
Investor payout summary
-
View: OKL_TXL_ADJSTS_LNS_V 12.1.1
Application of OKL writeoffs to AR invoices
APPS.OKL_TXL_ADJSTS_LNS_V·↳ OKL_TXL_ADJSTS_LNS_B·↳ OKL_TXL_ADJSTS_LNS_TL·Explore OKL module →
-
View: OKL_BPD_TLD_AR_LINES_V 12.2.2
View on TLD and receivables lines for variable rate and bill status API and remarketing view.
APPS.OKL_BPD_TLD_AR_LINES_V·↳ OKL_BILLING_UTIL_PVT·↳ OKL_TRX_AR_INVOICES_B·↳ OKL_TRX_AR_INVOICES_TL·Explore OKL module →
-
View: OKL_XTL_SELL_INVS_V 12.1.1
The transaction table for "bill" type transactions, where cash receipts are expected
APPS.OKL_XTL_SELL_INVS_V·↳ OKL_XTL_SELL_INVS_B·↳ OKL_XTL_SELL_INVS_TL·Explore OKL module →
-
Application of OKL writeoffs to AR invoices
-
View: OKL_TXL_ADJSTS_LNS_V 12.2.2
Application of OKL writeoffs to AR invoices
APPS.OKL_TXL_ADJSTS_LNS_V·↳ OKL_TXL_ADJSTS_LNS_B·↳ OKL_TXL_ADJSTS_LNS_TL·Explore OKL module →
-
Investor payout summary
-
View: OKL_TXL_AP_INV_LNS_V 12.1.1
Transaction lines to be included into Payables invoices
APPS.OKL_TXL_AP_INV_LNS_V·↳ OKL_TXL_AP_INV_LNS_B·↳ OKL_TXL_AP_INV_LNS_TL·Explore OKL module →
-
View: OKL_TXL_AP_INV_LNS_V 12.2.2
Transaction lines to be included into Payables invoices
APPS.OKL_TXL_AP_INV_LNS_V·↳ OKL_TXL_AP_INV_LNS_B·↳ OKL_TXL_AP_INV_LNS_TL·Explore OKL module →
-
This view displays Tax Summary for Invoice or Credit Memo.
APPS.OKL_CS_INVCM_TAX_SUM_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
This view displays Tax Summary for Invoice or Credit Memo.
APPS.OKL_CS_INVCM_TAX_SUM_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
Application of OKL writeoffs to AR invoices
-
Transaction lines to be included into Payables invoices
-
View for creating cure refunds
APPS.OKL_CURE_REFUNDS_DTLS_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ AR_RECEIVABLE_APPLICATIONS_ALL·↳ FND_GLOBAL·Explore OKL module →
-
View for creating cure refunds
APPS.OKL_CURE_REFUNDS_DTLS_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ AR_RECEIVABLE_APPLICATIONS_ALL·↳ FND_GLOBAL·Explore OKL module →