Results for “address3_db”

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

Overview

AR_ACTIVE_REMIT_TO_ADDRESSES_V is an Oracle E-Business Suite Receivables (AR) view owned by the APPS schema. It exposes the set of remit-to addresses that are currently active for a customer account, so that receipts, automatic receipt creation, and remittance advice processing can resolve a valid mailing address. The view is documented in ETRM as Release 11.5-only content, yet the object remains valid in Oracle EBS 12.1.1 and 12.2.2, where the underlying data model has been migrated to the Oracle Trading Community Architecture (TCA) tables HZ_CUST_ACCT_SITES, HZ_PARTY_SITES, and HZ_LOCATIONS. Rather than exposing raw address attributes alone, the view also derives a formatted, concatenated address and a mailing-oriented city/state/postal line, making it directly usable in reports, interfaces, and concurrent programs that print or transmit customer remit-to information.

Underlying Base Objects

The view is defined over the following documented base objects:

• HZ_CUST_ACCT_SITES (synonym) — customer account sites; provides CUST_ACCT_SITE_ID and STATUS.
• HZ_PARTY_SITES (synonym) — links party sites to locations; joined on PARTY_SITE_ID.
• HZ_LOCATIONS (synonym) — the physical address attributes (ADDRESS1…ADDRESS4, CITY, COUNTY, STATE, PROVINCE, POSTAL_CODE, ADDRESS_STYLE, COUNTRY).
• RA_REMIT_TOS (synonym) — remit-to definitions; restricts results to active remit-to addresses via a subquery on ADDRESS_ID where STATUS = 'A'.
• FND_TERRITORIES_VL (view) — supplies TERRITORY_SHORT_NAME, joined on LOC.COUNTRY = T.TERRITORY_CODE.
• ARH_ADDR_PKG (package) — its ARXTW_FORMAT_ADDRESS function renders the concatenated address using the location's ADDRESS_STYLE.

The joins therefore flow from customer account site to party site to location, with the territory view providing the country short name and the remit-to subquery filtering to active records only.

Key Columns

• ADDRESS_ID — the CUST_ACCT_SITE_ID, used as the identifier for the remit-to address.
• CONCATENATED_ADDRESS — the formatted address returned by ARH_ADDR_PKG.ARXTW_FORMAT_ADDRESS; null when the account site ID is null.
• ADDRESS1, ADDRESS2 — raw address line attributes from HZ_LOCATIONS.
• ADDRESS3_DB — the raw LOC.ADDRESS3 column, retained in the database without transformation. This is the column most frequently referenced by the search term “address3_db”.
• ADDRESS3 — a derived concatenation of CITY, a comma and space, STATE or PROVINCE, POSTAL_CODE, and the territory short name; note this differs semantically from ADDRESS3_DB.
• CITY, COUNTY, STATE, PROVINCE, POSTAL_CODE — individual address components.
• STATE_OR_PROVINCE — NVL(STATE, PROVINCE), a normalized state/province value.
• COUNTRY — the territory short name.

Common Use Cases and Queries

Typical uses include remittance advice printing, receipt header address display, and integration extracts that require an active remit-to address per customer account. A minimal query retrieving the formatted and raw address lines is:

• SELECT address_id, concatenated_address, address1, address2, address3_db, city, state_or_province, postal_code, country FROM ar_active_remit_to_addresses_v WHERE address_id = :p_cust_acct_site_id;

To list all active remit-to addresses for reporting:

• SELECT address_id, concatenated_address, address3_db FROM ar_active_remit_to_addresses_v ORDER BY country, city;

Because the view is filtered to active account sites and active remit-to records, it is generally safe to query without additional status predicates; consumers should nevertheless be aware that ADDRESS3 and ADDRESS3_DB carry different meanings and must not be used interchangeably.