Results for “application_status_code”

2 results




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

Overview

ARBV_CASH_APPLICATIONS is a read-only Oracle EBS view owned by the APPS schema in the Receivables (AR) product. It presents information about cash that has been applied to customer transactions, exposing the subset of receivable application records where the application type is cash. In Oracle EBS 12.1.1 and 12.2.2 the view retains the same definition, status VALID, and read-only behavior, and it is documented in ETRM with the referenced base object AR_RECEIVABLE_APPLICATIONS.

The view is used primarily for reporting and integration. It provides a de-normalized, presentation-ready projection of application activity, including functional and accounted amounts, discounts taken, and descriptive lookup labels, without requiring consumers to filter and decode the base table themselves. Because it is defined WITH READ ONLY, it is safe to query for extracts, reconciliation reports, and downstream interfaces, but it cannot be used as a target for DML.

Underlying Base Objects

The documented base object is AR_RECEIVABLE_APPLICATIONS, accessed in the APPS schema through a synonym. The view selects from this table and filters on APPLICATION_TYPE = 'CASH', so it returns only cash application rows and excludes other application types such as credit memos, adjustments, and unapplied or on-account activity.

The SELECT list maps base columns to view columns, and includes literal decode expressions ('_LA:...') that ETRM uses to describe lookup-based attributes such as payment type meaning and the confirmed flag. A few listed columns, including _LA:APPLICATION_STATUS, TRA, and the base-amount variants, appear in the ETRM column listing; not all of these are present in the excerpted SELECT text, reflecting the documented ETRM presentation rather than a complete DDL capture.

Key Columns

Common Use Cases and Queries

Typical uses include receipt-to-transaction reconciliation, cash application detail reports, discount analysis, and feeds into data warehouses or third-party reconciliation tools.

SELECT receivable_application_id,
       cash_receipt_id,
       applied_customer_trx_id,
       apply_date,
       amount_applied,
       earned_discount_taken,
       days_late
FROM   apps.arbv_cash_applications
WHERE  apply_date BETWEEN :p_from AND :p_to
AND    org_id = :p_org_id;

Because the view is read-only, it should be used strictly for retrieval. Ensure the querying user has appropriate grants on the APPS view and note that the ledger and operating unit context will vary by responsibility.