Search Results dist_party_id

Overview

APPS.AR_DISTRIBUTIONS_L_V is a reporting and integration view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that consolidates Receivables accounting distributions into a single, uniform column layout aligned with the Subledger Accounting (XLA) extract model. It unites distribution rows from AR_DISTRIBUTIONS_ALL and AR_CASH_BASIS_DISTS_ALL against the AR_XLA_LINES_EXTRACT table, presenting each distribution as a row keyed by the originating accounting event (event_id). Because the columns follow the XLA distribution template (dist_ prefixed attributes such as dist_line_id, dist_code_combination_id, dist_party_id, and dist_party_type), the view is the primary source for feeding Receivables transaction and receipt distributions into downstream reporting, reconciliation, and integration routines.

The view is not a stored object; it is defined by a UNION of two branches, one for standard AR distributions and one for cash-basis distributions. Both branches join the extract lines to their distribution table on source_id, source_table, and line_id, and both restrict retrieval to leaf-level, non-additional-entry lines.

Underlying Base Objects

Per the documented metadata, the view references the following objects:

• AR_DISTRIBUTIONS_ALL (synonym) — transaction and receipt accounting distributions.
• AR_CASH_BASIS_DISTS_ALL (synonym) — cash-basis distribution rows unioned into the same layout.
• AR_XLA_LINES_EXTRACT (synonym) — the XLA extract lines that supply event_id, line_number, language, ledger_id, and paired_ccid.
• ARP_XLA_EXTRACT_MAIN_PKG (package) — the extract population program that populates AR_XLA_LINES_EXTRACT.
• AR_CASH_RECEIPTS_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, RA_CUSTOMER_TRX_ALL, RA_CUST_TRX_TYPES_ALL (synonyms) — supporting AR source tables resolved through the underlying distribution and extract joins.

The view depends on the extract being populated for the relevant ledger and event, which is why the hint INDEX(l ar_xla_lines_extract_n1) forces the extract index to drive the plan.

Key Columns

• event_id — the XLA accounting event identifier; the primary join key to the subledger journal.
• dist_line_id — the distribution line identifier (line_id from the source distribution table).
• distribution_type — literal 'AR_DISTRIBUTIONS_ALL', identifying the distribution family.
• dist_code_combination_id / dist_paired_ccid — the accounting flexfield combination and its paired (intercompany) combination.
• dist_source_id, dist_source_table, dist_source_type (and _secondary variants) — the origin of the distribution line.
• dist_ent_amt / dist_ent_amt_from, dist_currency_code / dist_currency_code_from — entered amount (computed as amount_cr minus amount_dr) and currency.
• dist_party_type / dist_party_id / dist_party_site_id — customer (third-party) identification. dist_party_id returns third_party_id; dist_party_type is hard-coded to 'C' when the party is present, otherwise NULL; dist_party_site_id is derived from third_party_sub_id.
• dist_tax_link_id, dist_ref_dist_ccid, line_number, language, ledger_id — tax linkage, reference distribution combination, extract line, language, and ledger context.

Common Use Cases and Queries

The most frequent driver for accessing this view is the column dist_party_id, which users search when reconciling Receivables distributions to customers. A typical query:

• SELECT event_id, dist_line_id, dist_party_id, dist_party_type, dist_code_combination_id, dist_ent_amt, dist_currency_code FROM apps.ar_distributions_l_v WHERE dist_party_id = :party_id;
• Filtering by ledger_id and event_id to assemble all distribution lines for a single accounting event for drill-down reporting.
• Joining to AR_XLA_LINES_EXTRACT or XLA_AE_LINES on event_id to reconcile subledger journal amounts against source distributions.

Because the view restricts to leaf-level extract rows, it should be queried with selective predicates on ledger_id, event_id, or dist_party_id to leverage the ar_xla_lines_extract_n1 index and avoid full scans of the distribution tables.