Search Results bill_to_party




Overview
Explore in AI Chat

Overview

APPS.AR_TRX_REP_ITF_V is an Oracle E-Business Suite receivables reporting view that exposes transaction interface data in a fully denormalized, human-readable form. It is defined over the AR_TRANSACTIONS_REP_ITF synonym and joins to a set of Oracle Receivables and Trading Community Architecture (TCA) base objects to resolve internal identifiers into descriptive names. The view is primarily intended to support the Receivables transaction interface reporting process, where interface rows staged for import must be presented with customer, site, currency, accounting, payment term, and document sequence context.

In Oracle EBS 12.1.1 and 12.2.2, the view is owned by APPS and is commonly referenced by concurrent program reports, diagnostics, and custom SQL that reconcile transaction interface staging data against the expected customer and accounting attributes. Because the user searched for bill_to_party, the relevant portion of this view is the BILL_TO_CUSTOMER_NAME, BILL_TO_CUSTOMER_NAME_PHONETIC, BILL_TO_CUSTOMER_NUMBER, and BILL_TO_CUSTOMER_SITE columns, which are derived from TCA party, account, and site use entities.

Underlying Base Objects

The view's FROM clause references AR_TRANSACTIONS_REP as its primary source, aliased RX, and resolves descriptive attributes through the following documented base objects:

Key Columns

The most significant columns exposed by the view include:

Common Use Cases and Queries

The view is typically queried to validate staged transaction interface data before import, to diagnose import failures, and to report on bill-to and ship-to customer attributes. A representative query filtering on the bill-to party name is:

  • SELECT trx_number, trx_date, bill_to_customer_name, bill_to_customer_number, bill_to_customer_site, trx_amount, trx_currency FROM apps.ar_trx_rep_itf_v WHERE bill_to_customer_name LIKE :party_name;
  • SELECT trx_class, trx_type, COUNT(*) FROM apps.ar_trx_rep_itf_v GROUP BY trx_class, trx_type;
  • SELECT batch_name, batch_source, trx_number, receivables_gl_date, rec_account FROM apps.ar_trx_rep_itf_v WHERE batch_source = :source_name;

Because the view exposes ROW_ID (the ROWID of the underlying interface row) along with audit columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE, it also supports reconciliation and audit reporting on when interface records were staged and last modified. All access should be granted through the APPS schema or an appropriate synonym, and queries should account for the 50-byte truncation applied to party name columns when matching on customer names.