Search Results ar_xml_invoice_remit_to_v




Overview
Explore in AI Chat

Overview

The AR_XML_INVOICE_REMIT_TO_V view is an APPS-owned, valid database view within the Oracle Receivables (AR) module of Oracle E-Business Suite. Its purpose is to expose formatted "remit-to" address information in a structure suitable for XML-based invoice generation and electronic document delivery. In EBS, remit-to addresses indicate the payer remittance location associated with a customer account site, as opposed to the bill-to or ship-to addresses used elsewhere in order-to-cash flows. This view consolidates customer account site identifiers, raw location components, and pre-formatted address strings into a single relational projection, allowing XML invoice publishing programs, Oracle Bills Presentment, and Receivables output formatting to retrieve remittance address data without directly navigating the underlying Trading Community Architecture (TCA) model. Functionally, it decouples the physical TCA storage from the presentation logic required by invoice XML templates, and its USER1 through USER5 columns provide extension points implemented through the AR_XML_VIEW_FUNCTIONS package for client-specific address attributes.

Underlying Base Objects

Per the documented ETRM metadata, AR_XML_INVOICE_REMIT_TO_V is defined over the following base objects:

Key Columns

  • CUST_ACCT_SITE_ID — identifier for the customer account site that owns the remit-to address.
  • ADDRESS1–ADDRESS4 — raw address line values from HZ_LOCATIONS.
  • ADDRESS — formatted address returned by ARXTW_FORMAT_ADDRESS, or NULL if the customer account site is null.
  • COMPLETE_ADDRESS — fully formatted address including city, county, state, province, postal code, and territory short name.
  • CITY, COUNTY, STATE, PROVINCE, POSTAL_CODE — individual location components.
  • TERRITORY_SHORT_NAME — country or territory abbreviation from FND_TERRITORIES_VL.
  • USER1–USER5 — configurable attribute columns populated via AR_XML_VIEW_FUNCTIONS for XML remittance requirements.

Common Use Cases and Queries

This view is typically joined to customer and invoice data to supply remit-to blocks in XML invoice templates, in billing extract programs, and in presentation layer queries for statement and invoice output. A representative query retrieves the formatted remittance address for a given account site:

  • SELECT cust_acct_site_id, complete_address FROM ar_xml_invoice_remit_to_v WHERE cust_acct_site_id = :p_site_id;
  • SELECT address, city, state, postal_code, territory_short_name FROM ar_xml_invoice_remit_to_v;
  • SELECT cust_acct_site_id, user1, user2 FROM ar_xml_invoice_remit_to_v WHERE address IS NOT NULL;

Because address formatting is delegated to ARH_ADDR_PKG, results honor the country-specific style defined on the related location. The USER1–USER5 columns permit deterministic tailoring without altering the underlying TCA data model, making the view suitable for both standard Oracle XML invoice output and extension configurations in 12.1.1 and 12.2.2.