Search Results okl_transaction_status




Overview
Explore in AI Chat

Overview

APPS.OKL_CS_LC_ACCOUNT_TAB_UV is a consolidated reporting view within the Oracle E-Business Suite Lease and Finance Management (OKL / ETRM) module. It is designed to present a unified list of lease-related accounts — specifically consolidated AR invoices and their associated contract receivables — along with their current transaction status, due date, amount, currency, ledger, and operating unit. The name is derived from the "Lease Contracts Account" tab presented in the OKL user interface, and the view serves as the read-only data source behind that tab as well as for ad-hoc reporting and downstream integrations.

Its defining characteristic is a UNION ALL of two data sets: the first returns consolidated invoice headers from the lease consolidation tables (OKL_CNSLD_AR_HDRS_B), and the second returns individual customer transactions from Oracle Receivables (RA_CUSTOMER_TRX_ALL) that are linked to lease contracts via the OKL_TXL_AR_INV_LNS_B and OKL_TXD_AR_LN_DTLS_B intermediary tables. In both branches, the transaction status code is resolved to a meaningful label using the lookup type OKL_TRANSACTION_STATUS. This is directly relevant to a search on okl_transaction_status, since the view exposes both the raw TRX_STATUS_CODE and the decoded TRX_STATUS meaning.

Underlying Base Objects

The documented base objects are entered through synonyms owned by APPS, and include:

Key Columns

Common Use Cases and Queries

Typical scenarios include identifying all invoices tied to a lease contract and their current status, reconciling consolidated billing against AR, and reporting on receivables by ledger or operating unit.

SELECT consolidated_invoice_number,
       trx_status,
       due_date,
       amount,
       currency_code,
       org_name
FROM   apps.okl_cs_lc_account_tab_uv
WHERE  set_of_books_id = :p_ledger_id
  AND  trx_status = 'Approved'
ORDER  BY 2;

To locate a specific transaction by its status, filter directly on TRX_STATUS (the decoded OKL_TRANSACTION_STATUS meaning) or on TRX_STATUS_CODE for the underlying lookup value. Because the view is read-only and built on a UNION ALL, its results can be sorted only by the second column per the source definition, but it may be embedded freely in custom reports, OAF regions, and business intelligence queries across EBS 12.1.1 and 12.2.2.