Results for “arfv_app_dists_alc_v”

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

Overview

The APPS.ARFV_APP_DISTS_ALC_V view is a Receivables (AR) reporting object that exposes alternate currency information for cash receipt applications that have been transferred to Subledger Accounting (SLA). The suffix "ALC" denotes Alternate Ledger Currency, and the view is specifically filtered by the ledger category code ALC in the underlying GL_LEDGERS_PUBLIC_V join. Its purpose is to present rounded, alternate-currency accounted debit and credit amounts for application, earned discount, and unearned discount distributions that have been processed through the SLA engine and linked back to the AR distributions table.

Because Subledger Accounting creates accounting entries (XLA_AE_HEADERS and XLA_AE_LINES) that are linked to the originating AR distributions through XLA_DISTRIBUTION_LINKS, this view serves as a bridge between the SLA accounting model and the AR transactional model. It is primarily consumed by diagnostics, reconciliation, and customs reporting where users need to audit the alternate currency balances generated when a receipt application is accounted in a ledger whose currency differs from the receipt currency.

Underlying Base Objects

The view is defined over six documented base objects, all owned by APPS:

• XLA_AE_HEADERS — SLA accounting event headers. The view filters on APPLICATION_ID = 222 (Receivables application identifier) and joins to the ledger.
• XLA_AE_LINES — Individual SLA accounting lines, carrying the accounting_class_code that drives the decode logic (EDISC, UNEDISC, EXCH_GAIN, EXCH_LOSS, and others).
• XLA_DISTRIBUTION_LINKS — The linkage table joining SLA lines to the originating AR distributions, using AE_HEADER_ID and AE_LINE_NUM. The join includes the filter LNK.AE_HEADER_ID = LNK.REF_AE_HEADER_ID to exclude reversal links.
• AR_DISTRIBUTIONS_ALL — The AR distributions table, joined on a decoded source type derived from the SLA accounting class code.
• GL_LEDGERS_PUBLIC_V — The public ledger view, restricted to ledger category code ALC.
• FND_CURRENCIES — The currency definition table, supplying precision and minimum accountable unit for rounding.

Key Columns

• ACCOUNTED_DR / ACCOUNTED_CR — Rounded alternate-currency debit and credit amounts. Rounding is applied using NVL of MINIMUM_ACCOUNTABLE_UNIT or POWER(10, -PRECISION) from FND_CURRENCIES.
• ACCOUNT_TYPE (decoded) — A lookup-encoded value decoded through AR_LOOKUPS, returning the meaning for EDISC, UEDISC, EXCH_GAIN, EXCH_LOSS, or the receivable status (UNAPP, REC, UNID, ACC).
• GL_TRANSFER_STATUS (decoded) — Indicates whether the header has been transferred to General Ledger, presented as a Yes/No lookup.
• NAME / LEDGER_ID — The ledger name and identifier from GL_LEDGERS_PUBLIC_V, restricted to ALC category ledgers.
• SOURCE_ID — The AR distribution source identifier linking the SLA line back to AR_DISTRIBUTIONS_ALL.
• ACCOUNTING_CLASS_CODE — The raw SLA accounting class code driving the decode logic.

Common Use Cases and Queries

Typical scenarios include reconciling alternate currency application amounts against AR distributions, auditing exchange gain/loss postings, and validating SLA-to-GL transfer status for ALC ledgers. A representative query follows:

SELECT accounted_dr, accounted_cred, account_type, name,
       source_id, accounting_class_code
  FROM apps.arfv_app_dists_alc_v
 WHERE gl_transfer_status_code = 'Y'
   AND accounting_class_code IN ('EDISC','UNEDISC','EXCH_GAIN','EXCH_LOSS');

Note that the decoded lookup columns are rendered through AR_LOOKUPS and may require joining to FND_LOOKUP_VALUES for user-visible meanings. Because the view performs DISTINCT and rounding, results are suitable for direct reporting but not for high-volume joins against transaction detail tables.