Results for “header_attribute1”

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

Overview

The CE_INTRA_STMT_HDRS_LINES_V view is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Cash Management (CE) module. It consolidates intra-day bank statement header and line information into a single flattened structure, joining statement-level control attributes with the individual transaction lines they contain. The view is primarily consumed by the Cash Positioning functionality, where treasury and cash management users require a near-real-time picture of bank statement activity prior to formal reconciliation.

Because it combines both header and line data, the view allows downstream reports, concurrent programs, and custom integrations to retrieve statement context—such as bank account, statement number, statement date, and beginning/ending control balances—alongside each line's transaction details without performing separate lookups against the underlying header and line tables. The view remains VALID in both EBS 12.1.1 and 12.2.2 and is referenced in the ETRM (E-Business Suite Technical Reference Manual) metadata for the Cash Management product. Its exposure of the LINE_CURRENCY_CODE attribute, surfaced through the line-level CURRENCY_CODE column, is a frequent point of interest for users searching for currency handling on intra-day statement lines.

Underlying Base Objects

The view is defined over several documented base objects. The header portion draws from CE_INTRA_STMT_HEADERS (SYNONYM), which stores the statement control record, and the line portion draws from CE_INTRA_STMT_LINES (SYNONYM), which stores individual transaction entries. These two synonyms represent the core intra-day statement tables.

• CE_INTRA_STMT_HEADERS — provides statement header columns such as STATEMENT_HEADER_ID, STATEMENT_NUMBER, STATEMENT_DATE, CONTROL_BEGIN_BALANCE, CONTROL_END_BALANCE, and the header CURRENCY_CODE.
• CE_INTRA_STMT_LINES — provides line-level columns including STATEMENT_LINE_ID, LINE_NUMBER, TRX_DATE, TRX_TYPE, AMOUNT, STATUS, and the line CURRENCY_CODE (line_currency_code).
• CE_BANK_ACCOUNTS — supplies bank account context via BANK_ACCOUNT_ID.
• CE_BANK_BRANCHES_V — supports bank and branch descriptive information.
• CE_TRANSACTION_CODES — maps TRX_CODE_ID to transaction code descriptions.
• CE_LOOKUPS — resolves lookup meanings for coded columns such as status and transaction type.

The view is essentially an equijoin between the header and line objects on the statement identifier, enriched with lookup and bank account reference data.

Key Columns

The view exposes a wide column set. Header-side columns include STATEMENT_HEADER_ID, BANK_ACCOUNT_ID, STATEMENT_NUMBER, STATEMENT_DATE, GL_DATE, CONTROL_BEGIN_BALANCE, CONTROL_TOTAL_DR, CONTROL_TOTAL_CR, CONTROL_END_BALANCE, CONTROL_DR_LINE_COUNT, CONTROL_CR_LINE_COUNT, CURRENCY_CODE, STATEMENT_COMPLETE_FLAG, CHECK_DIGITS, CASHFLOW_BALANCE, and INT_CALC_BALANCE. Line-side columns include STATEMENT_LINE_ID, LINE_NUMBER, TRX_DATE, TRX_TYPE, AMOUNT, STATUS, TRX_CODE_ID, EFFECTIVE_DATE, BANK_TRX_NUMBER, TRX_TEXT, CUSTOMER_TEXT, INVOICE_TEXT, BANK_ACCOUNT_TEXT, CURRENCY_CODE (the line_currency_code), EXCHANGE_RATE_TYPE, EXCHANGE_RATE, EXCHANGE_RATE_DATE, ORIGINAL_AMOUNT, CHARGES_AMOUNT, and RECONCILE_TO_STATEMENT_FLAG.

A notable computed column applies a DECODE to AMOUNT based on TRX_TYPE, so that DEBIT, MISC_DEBIT, NSF, and REJECTED lines are presented as negative values while CREDIT, MISC_CREDIT, and STOP lines remain positive. This signed amount supports net cash position calculations. The line-level CURRENCY_CODE column is the primary attribute users seek when searching for "line_currency_code," as it identifies the currency in which the individual statement line is denominated, which may differ from the statement header currency where multi-currency bank accounts are in use.

Common Use Cases and Queries

Typical uses include intra-day cash positioning reports, bank statement dashboards, and reconciliation staging. A representative query to retrieve line currency alongside signed amounts is:

• SELECT statement_number, line_number, trx_date, trx_type, currency_code AS line_currency_code, amount FROM ce_intra_stmt_hdrs_lines_v WHERE bank_account_id = :p_bank_account_id AND trx_date >= :p_start_date;
• Aggregating net position by currency: SELECT currency_code, SUM(amount) net_amount FROM ce_intra_stmt_hdrs_lines_v GROUP BY currency_code;
• Filtering unreconciled lines: SELECT * FROM ce_intra_stmt_hdrs_lines_v WHERE reconcile_to_statement_flag = 'N' AND status = 'UNRECONCILED';

Because the view is defined in the APPS schema, custom reports and interfaces should reference it with the APPS prefix or via a synonym in a custom schema, and should be validated against the specific EBS release (12.1.1 or 12.2.2) in use, as column availability may vary between patch levels.