Results for “statement_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_RGW_CASH_MANAGEMENT_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Receivables (AR) product. Its documented description identifies it as a Release 10SC-only construct, and it is catalogued with a status of VALID. The view exposes a reconciliation-oriented projection that links a bank statement header and line to the underlying cash receipt that was reconciled against it. It therefore answers a narrow but recurring question: which receipt was matched to which bank statement line, and on what statement.

The view is significant because the user search term "ce_statement_reconciliations" corresponds directly to one of its base objects. CE_STATEMENT_RECONCILIATIONS is the Cash Management table that stores the association between statement lines and the source transactions reconciled against them. AR_RGW_CASH_MANAGEMENT_V walks that association back to the Receivables cash receipt hierarchy, producing a flattened, join-ready result set for reconciliation reporting and integration extracts. The "RGW" prefix indicates a reporting gateway-style object, typically used by reporting tools, custom concurrent programs, or feeder extracts rather than by application forms.

Underlying Base Objects

The view text joins five documented base objects. CE_STATEMENT_HEADERS supplies the statement identity and date. CE_STATEMENT_LINES supplies the line number and carries the STATEMENT_LINE_ID used as the reconciliation key. CE_STATEMENT_RECONCILIATIONS is the central fact table, filtered to the current reconciliation record (CURRENT_RECORD_FLAG = 'Y') and to matched status (STATUS_FLAG = 'M'). AR_CASH_RECEIPT_HISTORY is joined on REFERENCE_ID when REFERENCE_TYPE = 'RECEIPT', and AR_CASH_RECEIPTS provides the final CASH_RECEIPT_ID.

Documented metadata for 12.2.2 lists the same underlying objects, presented as synonyms in the APPS schema: AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, CE_STATEMENT_HEADERS, CE_STATEMENT_LINES, and CE_STATEMENT_RECONCILIATIONS. The ETRM also records several package references: FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, and XTR_USER_ACCESS. These packages indicate that the deployed 12.2.2 view definition incorporates multi-org and access-control security predicates, an important behavioural difference from the original Release 10SC text shown in the implementation data.

Key Columns

• STATEMENT_NUMBER — the bank statement identifier from CE_STATEMENT_HEADERS, used to group and label reconciliation output.
• STATEMENT_DATE — the statement date from CE_STATEMENT_HEADERS, providing the primary date dimension for period reporting.
• LINE_NUMBER — the statement line number from CE_STATEMENT_LINES, identifying the specific reconciled line.
• CASH_RECEIPT_ID — the Receivables cash receipt identifier, joining the result back to AR_CASH_RECEIPTS for customer, amount, currency, and receipt-method detail.

No amounts, currencies, or customer attributes are exposed by the view itself; those must be obtained by joining to AR_CASH_RECEIPTS or AR_CASH_RECEIPT_HISTORY.

Common Use Cases and Queries

Typical uses include confirming which receipts cleared on a given statement, producing audit evidence of receipt-to-statement matching, and feeding downstream subledger or treasury extracts.

SELECT v.STATEMENT_NUMBER,
       v.STATEMENT_DATE,
       v.LINE_NUMBER,
       v.CASH_RECEIPT_ID,
       r.RECEIPT_NUMBER,
       r.AMOUNT,
       r.CURRENCY_CODE
FROM   APPS.AR_RGW_CASH_MANAGEMENT_V v,
       APPS.AR_CASH_RECEIPTS r
WHERE  v.CASH_RECEIPT_ID = r.CASH_RECEIPT_ID
AND    v.STATEMENT_DATE BETWEEN :p_from_date AND :p_to_date
ORDER BY v.STATEMENT_DATE, v.STATEMENT_NUMBER, v.LINE_NUMBER;

A second pattern inverts the query to locate unreconciled receipts, selecting from AR_CASH_RECEIPTS where CASH_RECEIPT_ID does not appear in the view. Because the view filters STATUS_FLAG = 'M' and CURRENT_RECORD_FLAG = 'Y', it returns only currently matched reconciliations and excludes reversed or superseded matches, which should be considered when reconciling counts against CE_STATEMENT_RECONCILIATIONS directly.