Search Results trx_code

Overview

XTR_INTRADAY_STATEMENTS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the XTR (Treasury) product. Its purpose is to expose intraday bank statement header and line information by joining the Cash Management view CE_INTRA_STMT_HDRS_LINES_V with the Treasury configuration objects XTR_BANK_ACCOUNTS, XTR_COMPANY_AUTHORITIES, and XTR_DEALER_CODES. The view therefore presents a consolidated, Treasury-enriched perspective on intraday statement activity: not merely the raw Cash Management statement header and line data, but the same data augmented with the bank account and authority context held by Treasury.

The view is read-only and functions as a query surface for reporting, reconciliation analysis, and downstream integration. Because it joins two product areas, it is particularly useful when a report must present statement line detail alongside bank account naming and Treasury authorization attributes without requiring the consumer to perform those joins independently.

Underlying Base Objects

The documented base objects referenced by the view are:

• CE_INTRA_STMT_HDRS_LINES_V (VIEW) — the Cash Management intraday statement header and lines view, supplying the statement header, line, amount, currency, and transaction attributes.
• XTR_BANK_ACCOUNTS (SYNONYM) — the Treasury bank account definition, supplying bank account number and name columns surfaced by the view.
• XTR_COMPANY_AUTHORITIES (SYNONYM) — the Treasury company authority definitions used to constrain or enrich the rows returned.
• XTR_DEALER_CODES (SYNONYM) — the Treasury dealer code definitions referenced by the view's join logic.
• FND_GLOBAL (PACKAGE) — the standard Oracle Application Object Library package, typically invoked for session and responsibility context (for example, user or responsibility identifiers) within multi-org or security predicates.

The three XTR synonyms resolve to their underlying Treasury tables. The join to XTR_BANK_ACCOUNTS is the principal enrichment documented in the object description, which states that the view "joins the cash management view CE_INTRA_STMT_HDRS_LINES_V with treasury table XTR_BANK_ACCOUNTS and thus provides CE, XTR details."

Key Columns

The view exposes the full column list of CE_INTRA_STMT_HDRS_LINES_V, prefixed by source area in the underlying text. Notable columns include:

• STATEMENT_HEADER_ID and STATEMENT_LINE_ID — primary identifiers for the statement header and line.
• BANK_ACCOUNT_ID — the internal identifier linking to the Treasury bank account; the join key to XTR_BANK_ACCOUNTS.
• BANK_ACCOUNT_NUM and BANK_ACCOUNT_NAME — the Treasury-sourced account number and name.
• STATEMENT_NUMBER, STATEMENT_DATE, GL_DATE, STATEMENT_COMPLETE_FLAG — header-level identification and status.
• CONTROL_BEGIN_BALANCE, CONTROL_TOTAL_DR, CONTROL_TOTAL_CR, CONTROL_END_BALANCE, CONTROL_DR_LINE_COUNT, CONTROL_CR_LINE_COUNT — statement control totals.
• LINE_NUMBER, TRX_DATE, TRX_TYPE, TRX_CODE_ID — line identification and transaction classification.
• AMOUNT, SIGNED_AMOUNT, ORIGINAL_AMOUNT, CHARGES_AMOUNT, EXCHANGE_RATE, LINE_CURRENCY_CODE — monetary values and currency conversion.
• BANK_TRX_NUMBER, TRX_TEXT, CUSTOMER_TEXT, INVOICE_TEXT, BANK_ACCOUNT_TEXT — free-text references from the bank feed.
• STATUS, RECONCILE_TO_STATEMENT_FLAG — reconciliation state of the line.
• CASHFLOW_BALANCE, INT_CALC_BALANCE — calculated Treasury balances.
• Standard WHO and descriptive flexfield columns (ATTRIBUTE1–15, ATTRIBUTE_CATEGORY) at both header and line level.

Common Use Cases and Queries

The view supports intraday liquidity monitoring, statement reconciliation reporting, and reconciliation to Treasury cash positions. A typical query filters by date and bank account:

• List unreconciled intraday lines for a bank account over a date range, ordered by TRX_DATE and LINE_NUMBER.
• Aggregate signed amounts by TRX_TYPE or TRX_CODE_ID to summarise intraday activity by transaction classification.
• Compare CONTROL_END_BALANCE to the sum of SIGNED_AMOUNT per statement header to validate feed completeness.

Sample SQL:

SELECT bank_account_num, bank_account_name, statement_number, statement_date, line_number, trx_date, trx_type, trx_code_id, signed_amount, line_currency_code, status FROM apps.xtr_intraday_statements_v WHERE bank_account_id = :p_bank_account_id AND trx_date BETWEEN :p_from AND :p_to ORDER BY statement_date, line_number;

Because the view is not indexed in its own right, performance depends on the underlying CE_INTRA_STMT_HDRS_LINES_V and Treasury tables; filtering on BANK_ACCOUNT_ID and TRX_DATE is recommended to constrain the access path.