Results for “dqcust_acct_site_id”

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

Overview

HZ_DQM_AC_CS_V is a dictionary-defined view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) product family and is registered as VALID in the ETRM repository. The view is part of the party and customer data-quality model exposed through the Trading Community Architecture (TCA). Its naming convention - the HZ_ prefix for TCA objects, the DQM_ token for "data quality management," and the AC_CS suffix denoting "account/customer site" - indicates that it is a denormalized presentation layer over the customer account site entity.

The view provides a flattened, report-friendly read of customer account sites, joining the base site record to its party site, physical location, and territory definitions. Rather than returning raw surrogate identifiers and status codes, it emits prefixed DQ columns together with display-ready addressing and a decoded status meaning. This makes it suitable for data-quality dashboards, deduplication and cleansing routines, and extracts that feed master data governance processes. Because it is a view rather than a table, it stores no data of its own and always reflects the current state of the underlying TCA tables.

Underlying Base Objects

The view text is defined over four joined data sources and one PL/SQL utility package:

• HZ_CUST_ACCT_SITES_ALL - the primary source, aliased A, supplying the customer account site identifiers, status, party site reference, and operating unit.
• HZ_PARTY_SITES - aliased B, supplying the party site and party identifiers.
• HZ_LOCATIONS - aliased C, supplying address attributes such as address lines, city, state, postal code, province, county, and country code.
• FND_TERRITORIES_VL - aliased T, supplying the territory short name used as the country display value. This join is outer (+), so records are not dropped when no territory match exists.
• ARPT_SQL_FUNC_UTIL - a PL/SQL package whose GET_LOOKUP_MEANING function decodes the registry status into a user-facing meaning.

The joins are driven from the account site: A.PARTY_SITE_ID equals B.PARTY_SITE_ID, B.LOCATION_ID equals C.LOCATION_ID, and C.COUNTRY equals T.TERRITORY_CODE. The driving filter excludes sites whose status is 'M', treating a null status as 'A' via NVL. No ORG_ID restriction is applied inside the view, so callers must supply their own operating unit predicate where multi-org security is required.

Key Columns

• DQCUST_ACCOUNT_ID - the customer account identifier; this is the column associated with the user search term "dqcust_account_id" and is the principal key for account-level grouping.
• DQCUST_ACCT_SITE_ID - the customer account site identifier, unique per site.
• DQSTATUS - the raw registry status code from the account site record.
• DQSTATUSM - the decoded status meaning returned by ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING for the REGISTRY_STATUS lookup, falling back to the raw code.
• DQPARTY_SITE_ID / DQPARTY_ID - the party site and party identifiers, linking the record back to the TCA party model.
• DQADDRESS - address line 1 concatenated with line 2 using a hyphen separator when line 2 exists.
• DQCITY, DQSTATE, DQPOSTAL_CODE, DQPROVINCE, DQCOUNTY - individual location attributes for address validation and cleansing.
• DQCOUNTRY - the territory short name, the reporting-friendly equivalent of the country code.
• DQORG_ID - the operating unit identifier, used for multi-org filtering.

Common Use Cases and Queries

Typical uses include customer master data-quality reports, address completeness audits, duplicate-site detection, and feeding external CRM or MDM systems. A common pattern groups by account to list all sites for a given customer:

• SELECT dqcust_account_id, dqcust_acct_site_id, dqstatusm, dqaddress, dqcity, dqcountry FROM hz_dqm_ac_cs_v WHERE dqcust_account_id = :p_account_id;
• SELECT dqorg_id, dqcountry, COUNT(*) FROM hz_dqm_ac_cs_v GROUP BY dqorg_id, dqcountry;
• SELECT * FROM hz_dqm_ac_cs_v WHERE dqstatus = 'A' AND dqpostal_code IS NULL;

Because the view performs string concatenation and a function-based lookup decode, performance-sensitive extracts should filter on DQORG_ID and DQCUST_ACCOUNT_ID to limit the driving set. All access should be granted through the APPS schema or a synonym, consistent with standard EBS customization practice.