Results for “tai_tl”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.OKL_BPD_TLD_AR_LINES_V is a reporting view in the Oracle E-Business Suite (EBS) Enterprise Contracts / Lease Management module (formerly Oracle Lease and Finance Management, OKL). It exposes Accounts Receivable (AR) transaction line details that originate from the billing and invoicing flow of lease contracts, specifically linking the transaction detail staging structures to the corresponding AR customer transaction lines. The view is designed to present a consolidated, human-readable projection of invoiced lease lines, including contract number, stream type, invoice status, amounts, and associated descriptions.
Its role is primarily analytical and integration-oriented: it provides a denormalized result set that joins internal contract transaction tables with AR tables so that billing, revenue, and receivables information can be reported together. The view resolves descriptive text through the translated (language-aware) invoice table, making it suitable for multilingual EBS environments. The presence of the TAI_TL alias and the USERENV('LANG') filter indicates that the view returns description data in the session's current language.
Underlying Base Objects
The view is defined over the following documented base objects:
- OKL_TXD_AR_LN_DTLS_B — the primary transaction line detail (staging/billing) table, aliased as TLD. It supplies the driving key TLD.ID and links to the AR line via INTERFACE_LINE_ATTRIBUTE14.
- RA_CUSTOMER_TRX_LINES_ALL — the AR customer transaction lines table, aliased as RACTRL. The join is established by matching to_char(TLD.ID) to INTERFACE_LINE_ATTRIBUTE14.
- OKL_TXL_AR_INV_LNS_B — the invoice line table, aliased as TIL, joined via TLD.TIL_ID_DETAILS = TIL.ID.
- OKL_TRX_AR_INVOICES_B — the base invoice header table, aliased as TAI, joined via TIL.TAI_ID = TAI.ID.
- OKL_TRX_AR_INVOICES_TL — the translated invoice header table, aliased as TAI_TL, joined on ID and restricted to the user's language.
- OKL_BILLING_UTIL_PVT — a PL/SQL package whose functions INVOICE_LINE_AMOUNT_REMAINING and INVOICE_LINE_AMOUNT_ORIG are called to compute remaining and original amounts due.
Key Columns
- TLD_ID, KHR_ID, STY_ID, SEL_ID, ISL_ID, IBT_ID — internal identifiers linking the detail to contract, style, selected line, and other lease entities.
- CONTRACT_NUMBER — derived from RACTRL.INTERFACE_LINE_ATTRIBUTE6; the lease contract reference.
- STREAM_TYPE — derived from RACTRL.INTERFACE_LINE_ATTRIBUTE9; indicates the billing stream.
- CUSTOMER_TRX_ID / CUSTOMER_TRX_LINE_ID — the AR invoice header and line identifiers.
- TRX_STATUS_CODE, INVOICE_DATE, AMOUNT, DATE_ENTERED — invoice status, invoicing date, line amount, and entry date.
- DESCRIPTION — language-specific description from OKL_TRX_AR_INVOICES_TL.
- TAX_AMOUNT — computed as the sum of EXTENDED_AMOUNT for tax lines linked via LINK_TO_CUST_TRX_LINE_ID.
- LINE_AMOUNT — the extended amount from the AR line.
- AMOUNT_DUE_REMAINING / AMOUNT_DUE_ORIGINAL — calculated through OKL_BILLING_UTIL_PVT functions.
- CONSOLIDATED_INVOICE_NUMBER — from INTERFACE_LINE_ATTRIBUTE1.
Common Use Cases and Queries
This view is typically queried for billing reconciliation, receivables aging, and invoice line reporting tied to lease contracts. A representative query follows:
SELECT contract_number, stream_type, customer_trx_id, trx_status_code, invoice_date, line_amount, tax_amount, amount_due_remaining FROM apps.okl_bpd_tld_ar_lines_v WHERE contract_number = :contract_num;- Aggregating invoiced amounts by stream type to validate billing totals:
SELECT stream_type, SUM(line_amount) FROM apps.okl_bpd_tld_ar_lines_v GROUP BY stream_type; - Identifying open receivables using the computed due amounts:
SELECT customer_trx_id, amount_due_remaining FROM apps.okl_bpd_tld_ar_lines_v WHERE amount_due_remaining > 0;
Because several columns are derived through attribute mappings and package functions, queries against this view may perform less efficiently than direct table access; filtering on indexed keys such as CUSTOMER_TRX_ID or the contract number is advisable for production use.
-
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_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 →