Search Results jtf_parties_v




Overview
Explore in AI Chat

Overview

JTF_PARTIES_V is a CRM Foundation (JTF) view owned by the APPS schema that consolidates party and relationship information for Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its documented purpose is to present "Party (Organization or Group or Person) and relationship information," joining the core party registry to the person, organization, contact, and relationship extensions that describe each party in richer detail.

Functionally, the view resolves three distinct party perspectives into a single row: the party itself (PARTY), the party acting as a contact or subordinate within a relationship (SUB_PARTY), and the object party at the far end of that relationship (OBJ_PARTY). This tri-partite structure allows consumers to report on relationships without writing multi-way joins against the underlying HZ tables. It is used primarily by CRM applications, Oracle Forms-based setups, and custom reporting layers that need a denormalized, read-only presentation of the TCA (Trading Community Architecture) party model.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects, all exposed through APPS-level synonyms:

Each HZ_PARTIES instance is aliased multiple times (PARTY, SUB_PARTY, OBJ_PARTY), and the profile and contact tables are similarly aliased (PERSON_PROFILE_SUB, ORG_PROFILE, ORG_CONT) to correlate the appropriate profile with the correct party alias. The view is therefore a union of joins rather than a simple projection, and its row cardinality is driven by the combination of relationship and party-type conditions.

Key Columns

The column list falls into several logical groupings:

Common Use Cases and Queries

Because the view encapsulates relationship and profile joins, it is commonly queried to identify the parties associated with a given contact relationship, to enumerate the organization profile attributes for a party, or to drive CRM party-search screens.

SELECT PARTY_ID, PARTY_NUMBER, PARTY_NAME, PARTY_TYPE,
       SUB_PARTY.PARTY_ID, SUB_PARTY.PARTY_NUMBER,
       OBJ_PARTY.PARTY_NAME, PARTY_RELATIONSHIP_TYPE
FROM   APPS.JTF_PARTIES_V
WHERE  PARTY_RELATIONSHIP_TYPE = :p_rel_type
AND    PARTY_ID = :p_party_id;

SELECT PARTY_NAME, ORGANIZATION_NAME, DUNS_NUMBER, JGZZ_FISCAL_CODE
FROM   APPS.JTF_PARTIES_V
WHERE  PARTY_TYPE = 'ORGANIZATION'
AND    PARTY_ID = :p_org_party_id;

Note that the view exposes ROWID for the base PARTY row, which supports updatable contexts where the framework permits. Because JTF_PARTIES_V is a read-only compatibility view defined over the HZ schema, Oracle direction for new development favors querying the underlying HZ_PARTIES, HZ_RELATIONSHIPS, and profile tables directly; existing CRM code continues to reference the view. Queries should filter strongly by PARTY_ID or PARTY_RELATIONSHIP_ID to avoid the cartesian effects inherent in the multi-alias join structure.