Search Results person_title




Overview
Explore in AI Chat

Overview

The CSC_HZ_PARTIES_INFO_V view is a reporting and integration construct owned by the APPS schema within the CSC (Customer Care) product family of Oracle E-Business Suite, documented and valid in both 12.1.1 and 12.2.2. Its stated purpose is to present party information alongside the corresponding country name. Functionally, it is a denormalized projection of the TCA (Trading Community Architecture) registry: it flattens a party record from HZ_PARTIES and joins the associated territory to FND_TERRITORIES_VL so that the numeric country code carried on the party is resolved to a human-readable territory short name. Applications and concurrent programs in Customer Care, along with custom reports and interfaces, use this view to avoid re-implementing the party-to-territory join and the derived full-address concatenation. The view applies a status filter that excludes merged (M) and inactive/deleted (D) parties, so consumers receive only current, active party rows without needing to add their own predicate.

Underlying Base Objects

The documented base objects referenced by the view are HZ_PARTIES (via a synonym) and FND_TERRITORIES_TL (via a synonym, exposed as FND_TERRITORIES_VL). The definition uses an outer join to the territory object on the condition PARTY.COUNTRY = TERI.TERRITORY_CODE(+), meaning a party whose country code has no matching territory still appears, with a null territory short name. The driving table alias PARTY supplies ROWID, identity, classification, attribute, person-name, address, status, and phonetic columns. Because HZ_PARTIES is the registry master for both organizations and persons, the view is polymorphic: person-specific columns are populated only for records where PARTY_TYPE = 'PERSON'. The view text selects the ROWID of the party, which preserves the ability to map a result row back to its originating registry record.

Key Columns

The identity and classification columns are PARTY_ID, PARTY_NUMBER, PARTY_NAME, PARTY_TYPE, and LAST_UPDATE_DATE. Twenty-four flexfield columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE24) carry descriptive flexfield data. Person-name components include PERSON_PRE_NAME_ADJUNCT, PERSON_FIRST_NAME, PERSON_MIDDLE_NAME, PERSON_LAST_NAME, PERSON_NAME_SUFFIX, and the column most relevant to the search for person_title, PERSON_TITLE, which stores a person's professional or courtesy title (for example, a salutation, honorific, or job title captured on the registry party). Address columns comprise COUNTRY, the derived ADDRESS (a space-delimited concatenation of ADDRESS1 through ADDRESS4), the individual ADDRESS1–ADDRESS4 lines, CITY, POSTAL_CODE, STATE, PROVINCE, COUNTY, and the resolved TERRITORY_SHORT_NAME. Contact and phonetic columns include URL, EMAIL_ADDRESS, ORGANIZATION_NAME_PHONETIC, PERSON_FIRST_NAME_PHONETIC, and PERSON_LAST_NAME_PHONETIC, supporting fuzzy and alternate-script name matching. STATUS is exposed for informational purposes even though merged and deleted rows are already excluded.

Common Use Cases and Queries

Typical uses include customer-care search pages, party reconciliation extracts, and custom reports that require a person's title together with a formatted address and country name.

  • Retrieving person titles for a set of parties: SELECT party_id, party_name, person_title FROM csc_hz_parties_info_v WHERE party_type = 'PERSON' AND person_title IS NOT NULL;
  • Listing active parties with resolved country: SELECT party_number, party_name, city, territory_short_name FROM csc_hz_parties_info_v WHERE territory_short_name = 'US';
  • Reporting on recently changed records: SELECT party_id, party_name, last_update_date FROM csc_hz_parties_info_v WHERE last_update_date >= TRUNC(SYSDATE) - 30;
  • Full address output for correspondence: SELECT party_name, address, city, postal_code, territory_short_name FROM csc_hz_parties_info_v WHERE party_id = :p_party_id;

Because merged and deleted parties are filtered out, queries against this view are safe for operational reporting without additional status predicates.