Search Results misc_debit




Overview
Explore in AI Chat

Overview

APPS.CE_STATEMENT_LINES_V is a reporting and integration view over the bank statement line entity in Oracle Cash Management. It exposes the detail rows of bank statements previously loaded and stored in CE_STATEMENT_LINES, resolving foreign-key identifiers to their display meanings and pre-computing several derived columns used by Oracle EBS forms, concurrent programs, and reconciliation logic. The view presents each statement line with its transaction date, transaction type and code, amounts, exchange-rate information, and descriptive text fields, alongside a set of descriptive flexfield columns (ATTRIBUTE_CATEGORY through ATTRIBUTE15) and audit columns.

The view’s principal value is that it removes lookup translation work from the caller. Transaction type codes such as MISC_DEBIT, DEBIT, REJECTED, NSF, and SWEEP_OUT are mapped to user-facing meanings, and the view additionally publishes DEBIT_AMOUNT and CREDIT_AMOUNT columns that normalize statement lines into a debit/credit presentation. For users searching on misc_debit, this is the primary location: the string appears in the DECODE expressions that populate these two calculated columns.

Underlying Base Objects

The view is defined over the following documented base objects:

Rows in CE_STATEMENT_LINES are the source of truth; the lookup and conversion-type joins merely decorate those rows for presentation. Because the view calls a PL/SQL package function, it is not purely relational and cannot be used in certain parallel or restricted contexts.

Key Columns

Common Use Cases and Queries

The view is commonly used for bank statement line inquiries, reconciliation reporting, and interfaces that need translated values without re-implementing lookup joins. A typical query isolating miscellaneous debits, the term behind the misc_debit search, is:

  • SELECT statement_line_id, trx_date, trx_type_dsp, amount, debit_amount, credit_amount FROM ce_statement_lines_v WHERE trx_type = 'MISC_DEBIT' AND trx_date BETWEEN :from_date AND :to_date;
  • SELECT statement_header_id, SUM(debit_amount), SUM(credit_amount) FROM ce_statement_lines_v GROUP BY statement_header_id;
  • SELECT statement_line_id, trx_code_id_dsp, status_dsp, reconcile_to_statement_line FROM ce_statement_lines_v WHERE status_dsp = 'Unreconciled';

For high-volume batch processing, direct querying of CE_STATEMENT_LINES with explicit lookup joins is often preferable, since the view invokes a package function per row.