Results for “okl_transaction_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• OKL_CNSLD_AR_HDRS_B, OKL_CNSLD_AR_LINES_B, OKL_CNSLD_AR_STRMS_B — lease consolidation AR header, line, and stream tables used in the first UNION branch.
• OKL_TRX_AR_INVOICES_B, OKL_TXL_AR_INV_LNS_B, OKL_TXD_AR_LN_DTLS_B — lease-to-AR invoice linkage tables used in the second branch.
• RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL — the Oracle Receivables transaction header and line tables.
• AR_PAYMENT_SCHEDULES_ALL — provides due dates and original amounts due for both branches.
• FND_LOOKUPS — the lookup view that resolves the transaction status code into a user-facing meaning.
• GL_LEDGERS_PUBLIC_V — returns the ledger (set of books) name.
• HR_ALL_ORGANIZATION_UNITS — used in an outer join (org_id = organization_id(+)) to resolve the operating unit name.

Key Columns

• ID — the transaction identifier; from OKL_CNSLD_AR_HDRS_B in branch one, or the AR CUSTOMER_TRX_ID in branch two.
• CONSOLIDATED_INVOICE_NUMBER — populated with the AR TRX_NUMBER in the second branch.
• TRX_STATUS_CODE / TRX_STATUS — the raw status and its decoded meaning from lookup type OKL_TRANSACTION_STATUS.
• DUE_DATE, DATE_CONSOLIDATED — scheduled due date and the original transaction/consolidation date.
• AMOUNT, CURRENCY_CODE — the monetary amount and invoice currency.
• SET_OF_BOOKS / SET_OF_BOOKS_ID — the GL ledger name and identifier.
• ORG_NAME / ORG_ID — operating unit name and identifier.
• INVOICE_PULL_YN — indicates whether the invoice has been pulled into the consolidated billing cycle.

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.