Results for “ce_stat_hdrs_inf_v”

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

Overview

CE_STAT_HDRS_INF_V is an Oracle E-Business Suite view owned by the APPS schema within the Cash Management (CE) product module. It presents bank statement header information maintained in the Cash Management statement interface, exposing both the raw interface record and a set of derived analytical balances. The view is documented as "Retrofitted," indicating that it was carried forward across release boundaries and is available in both 12.1.1 and 12.2.2. Its primary role is to provide a reporting and inquiry layer over statement interface data without requiring direct access to the underlying interface table, while simultaneously resolving lookup meanings and enforcing bank account access restrictions.

Because the view joins to lookup and access-control constructs, it is well suited for use in custom concurrent programs, Oracle Reports, BI Publisher data templates, and ad hoc SQL executed through the EBS application schema. The user query "average_close_available_ytd" corresponds directly to a column exposed by this view, AVERAGE_CLOSE_AVAILABLE_YTD, which is one of the statement-level analytical balances surfaced for cash positioning and trend analysis.

Underlying Base Objects

The view is defined over the following documented base objects:

• CE_STATEMENT_HEADERS_INT (referenced via synonym) — the statement header interface table and the principal source of all column data. Each row of the view corresponds to one interface statement header record.
• CE_LOOKUPS (view) — joined on LOOKUP_TYPE = 'HEADER_INTERFACE_STATUS' to translate the RECORD_STATUS_FLAG into a display value.
• CE_BANK_ACCOUNTS_V (view) — used in a subquery that restricts returned rows to bank account numbers visible through the bank accounts view, providing account-level access filtering.
• FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, XTR_USER_ACCESS (packages) — referenced by the view and its dependencies to support multi-org and access-control behavior at runtime.

The join to CE_LOOKUPS is an outer join (L.LOOKUP_CODE(+) = NVL(I.RECORD_STATUS_FLAG, 'N')), so rows with a null status flag are not lost. The RECORD_STATUS_DSP column is produced by a DECODE that returns NULL when the status flag itself is NULL.

Key Columns

• STATEMENT_NUMBER, BANK_NAME, BANK_BRANCH_NAME, BANK_ACCOUNT_NUM, STATEMENT_DATE — statement identification and banking context.
• CONTROL_BEGIN_BALANCE, CONTROL_END_BALANCE, CONTROL_TOTAL_DR, CONTROL_TOTAL_CR — control totals supplied with the statement header.
• CONTROL_DR_LINE_COUNT, CONTROL_CR_LINE_COUNT, CONTROL_LINE_COUNT — line counts asserted by the statement.
• RECORD_STATUS_FLAG and RECORD_STATUS_DSP — the interface status code and its decoded meaning.
• CURRENCY_CODE — statement currency.
• CASHFLOW_BALANCE, INT_CALC_BALANCE, INTRA_DAY_FLAG, ONE_DAY_FLOAT, TWO_DAY_FLOAT — derived cash position and float measures.
• AVERAGE_CLOSE_LEDGER_MTD, AVERAGE_CLOSE_LEDGER_YTD — average closing ledger balances for month-to-date and year-to-date.
• AVERAGE_CLOSE_AVAILABLE_MTD, AVERAGE_CLOSE_AVAILABLE_YTD — average closing available balances for month-to-date and year-to-date. The YTD column is the field most commonly targeted by cash managers analyzing liquidity trends across the fiscal year.
• CHECK_DIGITS, SUBSIDIARY_FLAG, ATTRIBUTE_CATEGORY, ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield and miscellaneous attributes.
• ROW_ID and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) — row identity and audit information.

Common Use Cases and Queries

Typical scenarios include reconciling interface statement headers before import, monitoring interface record status, and analyzing average available balances for treasury reporting.

To retrieve average closing available balances for the year to date:

• SELECT statement_number, bank_account_num, statement_date, currency_code, average_close_available_ytd FROM apps.ce_stat_hdrs_inf_v WHERE average_close_available_ytd IS NOT NULL ORDER BY statement_date DESC;

To review interface status distribution:

• SELECT record_status_dsp, COUNT(*) FROM apps.ce_stat_hdrs_inf_v GROUP BY record_status_dsp;

To compare control totals against MTD and YTD averages for a specific account:

• SELECT statement_number, control_end_balance, average_close_ledger_mtd, average_close_ledger_ytd, average_close_available_mtd, average_close_available_ytd FROM apps.ce_stat_hdrs_inf_v WHERE bank_account_num = :account_num;

Because access is filtered through CE_BANK_ACCOUNTS_V and related access-control packages, results are automatically scoped to the bank accounts the querying responsibility is permitted to see. Queries should always qualify the view with the APPS schema to ensure consistent resolution of the underlying synonym and lookup joins.