Search Results ce_cp_disc_cei_v




Overview
Explore in AI Chat

Overview

CE_CP_DISC_CEI_V is an Oracle E-Business Suite view owned by the APPS schema and classified as VALID. It belongs to the Cash Management (CE) product family and is documented as a "Cash Positioning Discoverer View for Cash management inflows." The view is designed to expose a purpose-built, reporting-friendly projection of cash positioning data, specifically filtered to external cash inflows originating from the Cash Management interface (CEI). It is intended for consumption by Oracle Business Intelligence Discoverer workbooks and other ad hoc reporting tools used by treasury and cash management personnel to review expected and actual receipts against bank accounts.

The view draws its data from the Cash Positioning Worksheet framework, joining worksheet lines to underlying cashflows and bank account definitions. Its principal role is to present worksheet-scoped receipt cashflows in a single flat structure, enriched with worksheet identifiers, descriptions, and reporting labels, so that Discoverer users can build cash positioning reports without writing complex multi-table joins themselves.

Underlying Base Objects

The view is defined over several documented base objects. CE_CASHFLOWS (accessed as a synonym) supplies the transaction-level cashflow records. CE_CP_WORKSHEET_LINES (synonym) provides the Cash Positioning Worksheet line context, linking each cashflow to a worksheet and header. CE_BANK_ACCOUNTS_V is a view supplying bank account and functional currency information, used here primarily to determine whether a cashflow amount must be converted to the base currency. The remaining referenced objects — FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, and XTR_USER_ACCESS — are security and multi-org packages invoked through subqueries or function calls embedded in the view definition to enforce access control, organization context, and user data restrictions.

The defining join restricts rows to worksheet lines with SOURCE_TYPE = 'CEI' and INCLUDE_FLAG = 'Y', matches the cashflow's bank account to the bank accounts view, and requires that the worksheet line be cleared or that the cashflow carry a status of CREATED. A subtype match condition further refines which cashflows qualify. Only RECEIPT direction cashflows are returned, and CANCELED cashflows are excluded. This filtering makes the view a targeted instrument for inflow analysis rather than a general cashflow extract.

Key Columns

  • WORKSHEET_HEADER_ID — Identifier of the cash positioning worksheet header to which the line belongs; useful for grouping a report by worksheet.
  • CASHFLOW_BANK_ACCOUNT_ID — The bank account associated with the cashflow; aliased in the column listing as BANK_ACCOUNT_ID.
  • WORKSHEET_LINE_ID — Unique identifier of the worksheet line, providing line-level granularity.
  • DESCRIPTION — Descriptive text carried on the worksheet line, typically explaining the nature of the expected inflow.
  • DETAIL — The cashflow amount, resolved through a DECODE: where the cashflow currency equals the bank account currency, the raw CASHFLOW_AMOUNT is returned; otherwise the BASE_AMOUNT is used, ensuring consistent monetary reporting.
  • BALANCE — Corresponds to the cashflow identifier rendered as a character value, presented for reporting balance or reference purposes.
  • REFERENCE_ID — The numeric CASHFLOW_ID, retained as the join key back to CE_CASHFLOWS for drill-down.

Common Use Cases and Queries

Typical usage centers on treasury reporting: enumerating expected receipts per bank account, reconciling worksheet lines against created cashflows, and producing Discoverer-based cash positioning summaries. A representative query is:

  • SELECT worksheet_header_id, bank_account_id, description, detail FROM ce_cp_disc_cei_v WHERE bank_account_id = :p_account_id;
  • SELECT worksheet_header_id, SUM(detail) FROM ce_cp_disc_cei_v GROUP BY worksheet_header_id;
  • SELECT a.description, r.reference_id FROM ce_cp_disc_cei_v r, ce_cashflows a WHERE a.cashflow_id = r.reference_id;

Because the view enforces access control packages, results are automatically scoped to the operating units and responsibilities available to the querying user. Consumers should treat the view as read-only and expect its contents to reflect only CEI-sourced, non-canceled receipt flows included on active worksheets.