Search Results ce_cp_disc_xti_v




Overview
Explore in AI Chat

Overview

CE_CP_DISC_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 ETRM description identifies it as the "Cash Positioning Discoverer View for Treasury Inflow." The view is registered as VALID and is intended primarily as a reporting object surfaced through Oracle Discoverer (and, by extension, other BI or extraction tools that query the EBS database directly) for the Cash Positioning workbook. It exposes the inflow side of treasury cash flows — specifically external treasury transactions (deal type "XTI") that are candidates for inclusion in a daily cash position.

The view does not store data. It is a runtime projection that joins worksheet line configuration from Cash Positioning to current-day cash flow records, applying a fixed set of business filters so that only relevant inflow rows are presented to the report consumer.

Underlying Base Objects

Per the documented metadata, the view text joins two referenced objects:

  • CE_XTR_CASHFLOWS_V — a Cash Management view supplying external treasury cash flow data (deal number, amount, transaction date, bank account, reconciliation reference, DDA deal type and subtype).
  • CE_CP_WORKSHEET_LINES (referenced via a SYNONYM) — the Cash Positioning worksheet line definition, supplying the worksheet header/line identifiers, description, source type, include flag, cleared transaction flag, and indicative flag.

The join is implicit (comma-separated FROM clause) and is driven by the row filters rather than an explicit join key on the posting side; the worksheet line attributes act as the control mechanism that determines which cash flow rows surface.

Key Columns

  • WORKSHEET_HEADER_ID — Identifier of the parent Cash Positioning worksheet, used to group results by worksheet.
  • WORKSHEET_LINE_ID — Identifier of the configured worksheet line that governs inclusion.
  • BANK_ACCOUNT_ID — The bank account to which the treasury inflow is associated.
  • DESCRIPTION — Descriptive text carried from the worksheet line definition.
  • DETAIL — Displays the deal number (the view selects TO_CHAR(XTI.DEAL_NUMBER) under this alias/position).
  • BALANCE — The inflow amount (XTI.AMOUNT), restricted to values greater than or equal to zero.
  • REFERENCE_ID — Reference identifier from the cash flow source, typically used to relate the row back to its originating transaction.

Common Use Cases and Queries

The view supports daily cash positioning and treasury liquidity reporting. Because its filters hard-code XTI.TRX_DATE = TO_DATE(SYSDATE,'YYYY/MM/DD'), it returns only current-day inflows; historic analysis requires querying the underlying objects directly. It also enforces WSL.INCLUDE_FLAG = 'Y', WSL.SOURCE_TYPE = 'XTI', non-negative amounts, and reconciliation/indicative rules (excluding "EXP/INDIC" deal combinations unless flagged indicative).

A typical query groups inflows by bank account and worksheet:

  • SELECT bank_account_id, worksheet_header_id, SUM(balance) total_inflow FROM apps.ce_cp_disc_xti_v GROUP BY bank_account_id, worksheet_header_id;
  • SELECT worksheet_line_id, description, detail, balance FROM apps.ce_cp_disc_xti_v ORDER BY bank_account_id;

These queries suit Discoverer worksheet definitions, custom concurrent programs, and ad-hoc treasury extracts. Users should note that results are session-date sensitive and depend on correct worksheet line configuration (include, cleared, and indicative flags) to surface expected rows.