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
- RECEIVABLE_APPLICATION_ID — unique identifier of the application record.
- AMOUNT_APPLIED / AMOUNT_APPLIED_BASE — cash amount applied in transaction and base currency.
- APPLY_DATE — date the cash was applied to the transaction.
- _LA:APPLICATION_STATUS — decoded status of the application, derived from AR_LOOKUPS.
- CASH_RECEIPT_ID — identifier of the originating receipt.
- APPLIED_CUSTOMER_TRX_ID / APPLIED_PAYMENT_SCHEDULE_ID — the transaction and installment the cash was applied against.
- ACCTD_AMOUNT_APPLIED_TO / ACCTD_AMOUNT_APPLIED_FROM — accounted amounts on the applied-to and applied-from sides.
- TRANS_TO_RECEIPT_RATE / CROSS_CURRENCY_RATE — exchange rate used in cross-currency application.
- EARNED_DISCOUNT_TAKEN / UNEARNED_DISCOUNT_TAKEN — discounts taken, with corresponding line, tax, freight, and charges breakdowns.
- DAYS_LATE — number of days the payment was late at application.
- USSGL_TRANSACTION_CODE — accounting code for public-sector reporting.
- ORG_ID / SET_OF_BOOKS_ID — operating unit and ledger context.
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.
-
View: ARBV_CASH_APPLICATIONS 12.1.1
This shows information about cash applied to customer transactions.
APPS.ARBV_CASH_APPLICATIONS·↳ AR_RECEIVABLE_APPLICATIONS·Explore AR module →
-
View: ARBV_CASH_APPLICATIONS 12.2.2
This shows information about cash applied to customer transactions.
APPS.ARBV_CASH_APPLICATIONS·↳ AR_RECEIVABLE_APPLICATIONS·Explore AR module →