Search Results ce_cp_disc_ceo_v




Overview
Explore in AI Chat

Overview

CE_CP_DISC_CEO_V is an Oracle E-Business Suite Cash Management (CE) view owned by the APPS schema. Its documented purpose is to serve as a Cash Positioning Discoverer View for Cash Management outflows. In practice, it functions as a reporting and integration layer that exposes cash positioning worksheet data — specifically manual cash outflow entries, identified by the SOURCE_TYPE value 'CEO' — in a shape suited to Oracle Discoverer workbooks, ad hoc queries, and downstream reconciliation extracts. It is a read-only view with VALID status in both 12.1.1 and 12.2.2, and it carries no direct storage of its own; all content is derived from Cash Management base objects at query time.

The view is significant because it isolates the manual outflow portion of a cash positioning worksheet, applying the inclusion and clearing logic that Cash Management uses when computing a bank account's projected position. This makes it a convenient source for building outflow-only reports without re-implementing the worksheet filter rules.

Underlying Base Objects

The view's SELECT statement joins three primary source objects and indirectly depends on several security and access packages documented in ETRM 12.2.2 metadata.

  • CE_CASHFLOWS — the core cash flow fact table holding individual expected and actual cash movements, including direction, status, amount, and currency.
  • CE_CP_WORKSHEET_LINES — the cash positioning worksheet lines that group cash flows into a worksheet, carrying the source type, include flag, cleared flag, and transaction subtype association.
  • CE_BANK_ACCOUNTS_V — the bank account view used to compare the cash flow currency against the bank account's functional currency.
  • FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, XTR_USER_ACCESS — supporting packages that underlie the security and access context applied to Cash Management data (notably MO/ORG and access control filtering).

The join predicates enforce worksheet membership (WORKSHEET_LINE_ID to CASHFLOW_BANK_ACCOUNT_ID via the bank account), and the WHERE clause restricts the result to source type 'CEO', included lines, and payment-direction cash flows.

Key Columns

ColumnMeaning
WORKSHEET_HEADER_IDIdentifier of the parent cash positioning worksheet.
BANK_ACCOUNT_IDBank account associated with the cash flow (CASHFLOW_BANK_ACCOUNT_ID).
WORKSHEET_LINE_IDThe worksheet line that selected this cash flow.
DESCRIPTIONFree-text description of the worksheet line.
DETAILConverted cash flow ID (TO_CHAR of CASHFLOW_ID).
BALANCESigned outflow amount — negated via DECODE, using cash flow amount when the currency matches the bank account currency, otherwise the base amount.
REFERENCE_IDThe underlying CE_CASHFLOWS.CASHFLOW_ID, used for drill-back.

Common Use Cases and Queries

The view is typically used to report projected manual outflows for a bank account or worksheet, to feed reconciliation extracts, or to drive Discoverer-based cash positioning dashboards. A representative query follows.

  • Outflows by worksheet: SELECT worksheet_header_id, bank_account_id, SUM(balance) FROM ce_cp_disc_ceo_v WHERE worksheet_header_id = :p_id GROUP BY worksheet_header_id, bank_account_id;
  • Drill-back to cash flows: SELECT v.*, cf.* FROM ce_cp_disc_ceo_v v, ce_cashflows cf WHERE v.reference_id = cf.cashflow_id;
  • Discoverer workbook source: the view is exposed as a Discoverer folder, with BALANCE as the measure and DESCRIPTION/REFERENCE_ID as dimensions.