Search Results ce_260_transactions_v




Overview
Explore in AI Chat

Overview

CE_260_TRANSACTIONS_V is a Cash Management (CE) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to present available statement lines for reconciliation. In practice, the view consolidates bank statement line records that have not yet been matched or cleared, together with the descriptive attributes of the bank account, bank, and branch against which those lines were loaded. It provides the transaction-oriented data set consumed by Cash Management reconciliation and statement inquiry functionality, and it is exposed to external reporting and integration layers that require a flat, denormalized projection of pending bank activity.

The view carries the numeric tag 260, reflected in the literal column 260 embedded in its SELECT list, which identifies the report or functional context in which the view is used. Because it is a view rather than a table, it introduces no storage of its own and always returns current data from its underlying statement line and bank account sources.

Underlying Base Objects

The documented base objects for CE_260_TRANSACTIONS_V are:

  • CE_STATEMENT_LINES (SYNONYM) — the primary source of statement line rows, supplying transaction type, amount, currency, dates, status, and reconciliation identifiers.
  • CE_STATEMENT_HEADERS (SYNONYM) — joined to obtain header-level attributes such as GL date and header currency.
  • CE_BANK_ACCTS_GT_V (VIEW) — provides bank account name, number, currency, and asset code combination.
  • CE_BANK_BRANCHES_V (VIEW) — supplies bank name and branch name.
  • CE_LOOKUPS (VIEW) — resolves lookup codes such as transaction type and line status into descriptive meanings.
  • CE_SYSTEM_PARAMETERS (SYNONYM) — provides Cash Management system-level settings.
  • GL_DAILY_CONVERSION_TYPES (SYNONYM) — supplies the user conversion type associated with exchange rate handling.
  • GL_SETS_OF_BOOKS (VIEW) — used to determine the functional (set of books) currency for currency classification logic.

Column aliases in the view text (ABA, ABB, CL, CH, LK, L2, SOB, GLCC) correspond to these aliases for bank accounts, branches, statement lines, statement headers, lookups, sets of books, and conversion types respectively.

Key Columns

Common Use Cases and Queries

The view is typically queried to list unreconciled bank statement lines for a given bank account, to feed reconciliation workbenches, or to drive custom aging and cash-position reporting. A simple filtered query follows:

  • SELECT statement_line_id, bank_account_num, bank_name, bank_trx_number, trx_type, amount, currency_code, trx_date, status FROM ce_260_transactions_v WHERE bank_account_id = :p_account_id ORDER BY trx_date;
  • SELECT bank_account_name, currency_code, COUNT(*) pending_lines, SUM(amount) pending_amount FROM ce_260_transactions_v GROUP BY bank_account_name, currency_code;

Analysts should note that, because the view resolves many values through lookups, bank account views, and sets of books, joins can affect performance, and filtering should be applied on indexed identifiers such as BANK_ACCOUNT_ID and STATEMENT_LINE_ID wherever possible.