Search Results ar_receipt_method_accounts




Overview
Explore in AI Chat

Overview

The APPS.JL_BR_AR_RCT_MTHD_2_V view is a Brazilian localization (JL_BR) object within Oracle E-Business Suite Release 12.1.1 and 12.2.2. It resolves a denormalized, reporting-friendly representation of Receivables receipt method configurations that are tied to remittance bank accounts. The view answers the question of which receipt methods are associated with which bank account uses, and it additionally surfaces the receipt class creation method code, enabling downstream logic to distinguish manual, automatic, and quick-payment creation behavior.

This view is particularly relevant to implementers who search under the term ar_receipt_method_accounts, since that base table is one of its five constituent objects. The view effectively joins the receipt method definition to its bank account assignments, making it suitable for reporting on bank account usage per receipt method without requiring the consumer to reconstruct the multi-table join. In Brazilian localization contexts, this is often used for bank remittance, collection, and reconciliation reporting.

Underlying Base Objects

The view is defined over five base objects, all referenced through APPS SYNONYMs:

The joins are driven by RECEIPT_METHOD_ID between the receipt method tables and the receipt method accounts table, by RECEIPT_CLASS_ID between the receipt method and the receipt class, and by BANK_ACCT_USE_ID between the receipt method accounts and the bank account uses table. A SELECT DISTINCT is applied, which deduplicates the result set that would otherwise repeat when multiple customer or account use rows match.

Key Columns

The view exposes three columns:

  • NAME — the receipt method name from AR_RECEIPT_METHODS.NAME. This is the human-readable identifier used in reports and setup screens.
  • RECEIPT_METHOD_ID — the primary identifier from AR_RECEIPT_METHODS.RECEIPT_METHOD_ID, enabling joins back to standard Receivables tables.
  • CREATION_METHOD_CODE — from AR_RECEIPT_CLASSES.CREATION_METHOD_CODE, indicating whether receipts under the class are created manually, automatically, or by quick payment.

Common Use Cases and Queries

Typical usage includes validating bank account assignments for a receipt method, and generating bank-specific collection reports where the creation method must be known.

SELECT name, receipt_method_id, creation_method_code
FROM   apps.jl_br_ar_rct_mthd_2_v
ORDER BY name;

To filter for a specific receipt method:

SELECT name, creation_method_code
FROM   apps.jl_br_ar_rct_mthd_2_v
WHERE  receipt_method_id = :p_receipt_method_id;

Because the view joins through AR_RECEIPT_METHOD_ACCOUNTS, it is useful for identifying which receipt methods actually have remittance bank accounts configured—a frequent reconciliation test in Brazilian localization implementations.