Search Results position_src_type

Overview

APPS.CE_CP_DISC_V is a reporting view in the Oracle Cash Management module of Oracle E-Business Suite (available in both 12.1.1 and 12.2.2). The "CP" prefix denotes Cash Positioning, and "DISC" indicates this view consolidates the discrete balance components that feed a cash positioning worksheet. It presents, in a single flattened result set, the opening balance, prior-day balance, individual transaction balances, and the derived net, close, target, and surplus figures for each bank account worksheet.

The view is defined as a join between a header subquery (aliased HEAD) and a data subquery (aliased DATA). The HEAD subquery resolves worksheet headers and descriptive text, joining CE_CP_WS_BA_DISC_V with worksheet line and lookup information. The DATA subquery unions balance rows sourced from the CE_CP_DISC_OPEN_V, CE_CP_DISC_PRIOR_V, CE_CP_DISC_TRX_V, and the CLOSE, NET, TARGET, and SURPLUS component views. Because it exposes both a line-level detail trail and the aggregated position rows, this view is frequently used for cash position reporting, worksheet reconciliation, and downstream integration extracts.

Underlying Base Objects

The documented base objects underlying CE_CP_DISC_V include the component views CE_CP_DISC_OPEN_V, CE_CP_DISC_PRIOR_V, CE_CP_DISC_TRX_V, CE_CP_DISC_CLOSE_V, CE_CP_DISC_NET_V, CE_CP_DISC_TARGET_V, and CE_CP_DISC_SURPLUS_V, which together supply the balance rows. The header side draws on CE_CP_WS_BA_DISC_V, CE_CP_WORKSHEET_HEADERS, and CE_CP_WORKSHEET_LINES (exposed as synonyms), and on CE_LOOKUPS, which supplies the descriptive meanings for the various source types. The view text specifically filters CE_LOOKUPS on lookup_type = 'POSITION_SRC_TYPE'.

The definition relies heavily on the CE_LOOKUPS view to translate lookup codes (OPEN, PRIOR, NET, CLOSE, TARGET, SURPLUS, TRX, IDA) into user-facing descriptions. Security and access objects — FND_GLOBAL, FND_PROFILE, FND_ACCESS_CONTROL_UTIL, MO_GLOBAL, and XTR_USER_ACCESS — support the multi-org and access-control context in which the underlying packages (ARP_CASHBOOK) and component views operate. The view should therefore be treated as a read-only reporting construct layered over the CE cash positioning worksheet tables and their associated analytic views.

Key Columns

The view exposes the following principal columns:

• worksheet_header_id — Identifier of the cash positioning worksheet header that owns the row.
• worksheet_line_id — The originating line identifier; a value of -1 denotes header-level (non-transaction) balance rows such as OPEN, PRIOR, NET, CLOSE, TARGET, and SURPLUS.
• bank_account_id — The bank account to which the worksheet and balance relate.
• balance — The monetary balance for the row, as supplied by the corresponding component view.
• source_type — The classification of the row, decoded against the POSITION_SRC_TYPE lookup (OPEN, PRIOR, NET, CLOSE, TARGET, SURPLUS) or 'TRX'/'IDA' for transaction rows.
• source_description — The lookup meaning associated with the source_type, providing readable context.
• trx_description — Descriptive text for transaction-based lines (null for header-level rows).
• detail — Line-level detail text carried from the transaction component.

The source_type column is the most significant discriminator, allowing consumers to separate transaction detail from position summaries. Since it is resolved through the POSITION_SRC_TYPE lookup, the view honors any user-defined meanings configured for those codes.

Common Use Cases and Queries

The view is most often used to produce a complete cash position picture for a given worksheet or bank account. A typical query retrieving all rows for a worksheet, ordered so that summary rows precede transactions, is:

• SELECT worksheet_header_id, bank_account_id, worksheet_line_id, source_type, source_description, balance FROM ce_cp_disc_v WHERE worksheet_header_id = :p_header_id ORDER BY worksheet_line_id;
• SELECT source_type, source_description, SUM(balance) FROM ce_cp_disc_v WHERE bank_account_id = :p_account GROUP BY source_type, source_description;
• SELECT worksheet_header_id, worksheet_line_id, trx_description, detail, balance FROM ce_cp_disc_v WHERE source_type = 'TRX' AND balance <> 0;

Common scenarios include reconciling the transaction detail against the NET and CLOSE summary rows, extracting position data for treasury dashboards, and validating that the OPEN and PRIOR balances match the bank statement feed. Because the view is built from pre-aggregated component views, it performs well as a reporting source but should not be used for transactional updates. Access is governed by the surrounding multi-org and user-access packages, so results returned will reflect the responsibilities and organization context of the querying session.