Search Results ce_cp_xti_v




Overview
Explore in AI Chat

Overview

CE_CP_XTI_V is a Cash Management (CE) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description identifies it as the "Cash Positioning source for Discoverer - Treasury Inflow." In practice, the view exposes treasury inflow deal data so that cash positioning reports — historically delivered through Oracle Discoverer workbooks — can reconcile expected cash receipts against bank account balances. The view is therefore a reporting and integration artifact rather than a transactional entity: it does not store data itself, but presents a curated, filtered projection of Treasury (XTR) deal information joined to Cash Management bank account data. Only inflow-relevant records are surfaced, meaning positive cashflow amounts that have not been cancelled and that do not represent multiple-settlement arrangements.

Underlying Base Objects

The view text references three objects. XTR_DEAL_DATE_AMOUNTS (accessed via a synonym, underlying table in the Treasury module) is the primary driver and supplies deal dates, amounts, deal type, and deal subtype information. XTR_PARTY_INFO (also a synonym) supplies the legal entity and party attributes used to associate deals with an owning organization. CE_BANK_ACCTS_GT_V is a Cash Management view supplying bank account identifiers, currency codes, and account numbers. The joins are outer joins on the bank account and party sides (indicated by the (+) operator), ensuring that deal rows are retained even when a matching bank account or party record is absent. The XTR_DEAL_DATE_AMOUNTS alias DDA drives the query, with filters applied to constrain scope.

Key Columns

The documented column list exposes the following fields. REFERENCE_ID maps to the underlying DEAL_DATE_AMOUNT_ID and uniquely identifies each deal date amount row. BANK_ACCOUNT_ID identifies the associated bank account. CASH_ACTIVITY_DATE is derived via NVL(DDA.ACTUAL_SETTLEMENT_DATE, DDA.AMOUNT_DATE), giving the actual settlement date when available and falling back to the scheduled amount date. DEAL_NUMBER carries the treasury deal reference. BASE_AMOUNT corresponds to CASHFLOW_AMOUNT, the inflow value. INDICATIVE_FLAG is computed using a DECODE: it returns 'Y' only when DEAL_TYPE is 'EXP' (export) and DEAL_SUBTYPE is 'INDIC' (indicative), otherwise 'N'. DEAL_TYPE holds the raw deal type code, and RECONCILED_REFERENCE carries the reconciliation reference used by cash positioning and bank reconciliation processes.

Common Use Cases and Queries

Typical usage centers on cash positioning analysis, liquidity forecasting, and reconciliation of treasury inflows against bank statements. A representative query filters inflows for a given date range and bank account:

  • SELECT reference_id, deal_number, cash_activity_date, base_amount, bank_account_id FROM ce_cp_xti_v WHERE cash_activity_date BETWEEN :start_date AND :end_date ORDER BY cash_activity_date;
  • SELECT deal_type, indicative_flag, COUNT(*), SUM(base_amount) FROM ce_cp_xti_v GROUP BY deal_type, indicative_flag; — summarises inflows by type, separating indicative from confirmed amounts.
  • SELECT * FROM ce_cp_xti_v WHERE reconciled_reference IS NOT NULL; — isolates deals already carrying a reconciliation reference.

Because the view applies its own filters internally (non-cancelled status, positive cashflow, single-settlement only), consumers should not expect cancelled or multiple-settlement deals to appear. The outer joins additionally mean bank account or party attributes may be null where no match exists. The view is suitable for read-only reporting and Discoverer workbooks and should not be treated as a maintenance interface. Oracle proprietary and confidential — refer to ETRM documentation for authoritative column-level definitions in each release.