Search Results ar_rx_other_applications_v




Overview
Explore in AI Chat

Overview

The AR_RX_OTHER_APPLICATIONS_V view is a reporting base object owned by the APPS schema within the Oracle Receivables (AR) module. It is documented as the base view for the RXi:Other Applications Report, a standard Oracle EBS report used to present miscellaneous receipt applications that are not tied to standard cash-receipt matching. The view consolidates data from Receivables, Cash Management, General Ledger, and Trading Community Architecture (HZ) tables into a single flat, denormalized projection intended to simplify extraction for reporting.

Its status is VALID and it is a read-only view; it is not a table and therefore should never be used for DML. It functions primarily as a reporting and integration surface, presenting receipt-application detail enriched with customer, bank, and accounting context. Because the view exposes bank information — notably BANK_NAME and BANK_BRANCH_NAME — it is frequently relevant to searches involving banking attributes such as "bank_branch".

Underlying Base Objects

The view is defined over a large join spanning multiple base objects. Documented referenced objects include AR_RECEIVABLE_APPLICATIONS (the driving application detail table), AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY (receipt header and history), AR_PAYMENT_SCHEDULES, AR_RECEIVABLES_TRX, AR_RECEIPT_METHODS, AR_BATCHES, AR_BATCH_SOURCES, and AR_SYSTEM_PARAMETERS. Customer and party data come from HZ_CUST_ACCOUNTS, HZ_PARTIES, and HZ_CUST_SITE_USES. Bank data originates from CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES, and CE_BANK_BRANCHES_V. Accounting and organization context is supplied by GL_SETS_OF_BOOKS, GL_CODE_COMBINATIONS, and the packages ARPT_SQL_FUNC_UTIL, ARP_PROCESS_WRITEOFF, FA_RX_FLEX_PKG, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, XTR_USER_ACCESS, and FND_ACCESS_CONTROL_UTIL.

The join is driven by application records in AR_RECEIVABLE_APPLICATIONS, linked to receipts, schedules, and receipt history, with lookup enrichment via ARPT_SQL_FUNC_UTIL and functionality security enforced through MO_GLOBAL and FND packages.

Key Columns

Common Use Cases and Queries

Typical uses include reconciliation of other applications, tracking receipt applications by bank branch, and feeding downstream reports. A representative query listing applications by branch:

  • SELECT receipt_number, customer_name, bank_name, bank_branch_name, amount_applied FROM ar_rx_other_applications_v WHERE bank_branch_name IS NOT NULL;
  • SELECT set_of_books, receipt_date, currency_code, amount_applied FROM ar_rx_other_applications_v WHERE gl_date BETWEEN :p_from AND :p_to;
  • SELECT customer_number, customer_name, rec_activity_name, amount_applied FROM ar_rx_other_applications_v ORDER BY customer_name;

Because the view references secured objects and functions, query results are filtered by operating unit and responsibility access, ensuring users only see data permitted by their security profile.