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:

Key Columns

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.