Search Results ref_ae_header_id

Overview

The ARFV_REVENUE_DISTS_ALC_V view is an Oracle E-Business Suite dictionary object owned by the APPS schema, delivered with the Receivables (AR) product. In release 12.1.1 and 12.2.2 it presents alternate-currency (ALC) information for revenue amounts that have been transferred to Subledger Accounting (SLA). It sits on the reporting and reconciliation boundary between Receivables transaction distributions and the accounting entries generated by the SLA engine, allowing the balances carried in the primary ledger currency to be re-expressed in the reporting currency of an alternate ledger.

The view is bound to ledgers whose LEDGER_CATEGORY_CODE equals ALC, so it exposes only alternate-currency ledger accounting rather than primary-ledger accounting. Its rows represent the accounted debit and credit amounts for revenue distribution lines, after currency rounding has been applied in accordance with the currency's precision and minimum accountable unit. The inclusion of a hidden value-set lookup column keyed on the GL transfer status means the view can distinguish entries that have been transferred to General Ledger from those still pending.

Underlying Base Objects

The view is defined over a join of the following documented base objects:

FND_CURRENCIES (synonym) — provides the currency code, precision and minimum accountable unit used for rounding; joined to the ledger currency code.
GL_LEDGERS_PUBLIC_V (view) — supplies ledger name, ledger identifier and ledger category; filtered to the alternate-currency ledger category.
XLA_AE_HEADERS (synonym) — the SLA accounting event header, restricted to APPLICATION_ID = 222 (Receivables).
XLA_AE_LINES (synonym) — the SLA accounting lines, joined on header and line number with the distribution links, and filtered by accounting class.
XLA_DISTRIBUTION_LINKS (synonym) — maps SLA header/line combinations back to their source transaction distributions. The view applies reversal-elimination logic using REF_AE_HEADER_ID, REF_TEMP_LINE_NUM and a NOT EXISTS subquery so that reversed and reversing links are excluded.
RA_CUST_TRX_LINE_GL_DIST_ALL (synonym) — the Receivables revenue distribution lines, matched on distribution identifier and account class.
RA_CUSTOMER_TRX_ALL (synonym) — the parent transaction, supplying the transaction number and joining the distribution to its transaction.

Key Columns

Although the outer projection exposes a compact column list, the internal query produces the following meaningful values:

ACCOUNTED_DR / ACCOUNTED_CR — accounted debit and credit amounts for the revenue distribution, computed by rounding UNROUNDED_ACCOUNTED_DR and UNROUNDED_ACCOUNTED_CR to the currency's minimum accountable unit.
NAME — ledger name from GL_LEDGERS_PUBLIC_V.
TRX_NUMBER — the Receivables transaction number from RA_CUSTOMER_TRX_ALL.
CUST_TRX_LINE_GL_DIST_ID — identifier of the source revenue distribution line, the key linkage back to Receivables.
LEDGER_ID — identifier of the alternate-currency ledger.
CUSTOMER_TRX_ID — identifier of the parent transaction.
GL_TRANSFER_STATUS_CODE — exposed through a lookup expression, yielding Y/N meaning values for transfer status.

The query's join predicate LNK.AE_HEADER_ID = LNK.REF_AE_HEADER_ID is the anchor referenced by the search term ref_ae_header_id: it retains only those distribution links whose referenced header matches their own, thereby filtering out reversal links before the reversal-exclusion subquery is applied.

Common Use Cases and Queries

Typical scenarios include reconciling Receivables revenue distributions to SLA accounting in an alternate currency ledger, validating rounding behaviour on low-precision currencies, and confirming GL transfer status for revenue lines.

Revenue-to-SLA reconciliation in the ALC ledger:

SELECT trx_number, cust_trx_line_gl_dist_id, ledger_id,
       accounted_dr, accounted_credit
FROM   apps.arfv_revenue_dists_alc_v
WHERE  ledger_id = :p_ledger_id
ORDER  BY trx_number;

Locating SLA accounting for a specific transaction:

SELECT a.trx_number, a.cust_trx_line_gl_dist_id,
       a.accounted_dr, a.accounted_credit
FROM   apps.arfv_revenue_dists_alc_v a
WHERE  a.customer_trx_id = :p_customer_trx_id;

View: ARFV_REVENUE_DISTS_ALC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_REVENUE_DISTS_ALC_V, object_name:ARFV_REVENUE_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about revenue amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_REVENUE_DISTS_ALC_V ,
View: ARFV_UNREV_DISTS_ALC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_UNREV_DISTS_ALC_V, object_name:ARFV_UNREV_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about unearned revenue amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_UNREV_DISTS_ALC_V ,
View: ARFV_CASH_DISTS_ALC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_CASH_DISTS_ALC_V, object_name:ARFV_CASH_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about cash amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_CASH_DISTS_ALC_V ,
View: ARFV_TAX_DISTS_ALC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_TAX_DISTS_ALC_V, object_name:ARFV_TAX_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about tax amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_TAX_DISTS_ALC_V ,
View: ARFV_TAX_DISTS_ALC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_TAX_DISTS_ALC_V, object_name:ARFV_TAX_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about tax amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_TAX_DISTS_ALC_V ,
View: ARFV_FREIGHT_DISTS_ALC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_FREIGHT_DISTS_ALC_V, object_name:ARFV_FREIGHT_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about freight amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_FREIGHT_DISTS_ALC_V ,
View: ARFV_CASH_DISTS_ALC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_CASH_DISTS_ALC_V, object_name:ARFV_CASH_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about cash amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_CASH_DISTS_ALC_V ,
View: ARFV_UNREC_DISTS_ALC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_UNREC_DISTS_ALC_V, object_name:ARFV_UNREC_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about unbilled receivables amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_UNREC_DISTS_ALC_V ,
View: ARFV_UNREC_DISTS_ALC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_UNREC_DISTS_ALC_V, object_name:ARFV_UNREC_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about unbilled receivables amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_UNREC_DISTS_ALC_V ,
View: ARFV_ADJ_DISTS_ALC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_ADJ_DISTS_ALC_V, object_name:ARFV_ADJ_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about adjustment amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_ADJ_DISTS_ALC_V ,
View: ARFV_REVENUE_DISTS_ALC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_REVENUE_DISTS_ALC_V, object_name:ARFV_REVENUE_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about revenue amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_REVENUE_DISTS_ALC_V ,
View: ARFV_FREIGHT_DISTS_ALC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_FREIGHT_DISTS_ALC_V, object_name:ARFV_FREIGHT_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about freight amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_FREIGHT_DISTS_ALC_V ,
View: ARFV_ADJ_DISTS_ALC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_ADJ_DISTS_ALC_V, object_name:ARFV_ADJ_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about adjustment amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_ADJ_DISTS_ALC_V ,
View: ARFV_UNREV_DISTS_ALC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_UNREV_DISTS_ALC_V, object_name:ARFV_UNREV_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about unearned revenue amounts transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_UNREV_DISTS_ALC_V ,
View: ARFV_APP_DISTS_ALC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_APP_DISTS_ALC_V, object_name:ARFV_APP_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about cash receipt applications transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_APP_DISTS_ALC_V ,
View: ARFV_APP_DISTS_ALC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_APP_DISTS_ALC_V, object_name:ARFV_APP_DISTS_ALC_V, status:VALID, product: AR - Receivables , description: This shows Alternate Currencies information about cash receipt applications transferred to the Subledger Accounting. , implementation_dba_data: APPS.ARFV_APP_DISTS_ALC_V ,