Results for “obj_party_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CSD_HZ_REL_V is an APPS-owned database view in Oracle E-Business Suite Release 12.1.1 and 12.2.2, delivered as part of the CSD (Depot Repair) product family. Its documented purpose is to present the details of Related, Subject, and Object parties — the three-party relationship construct used by the Oracle Trading Community Architecture (TCA) — for consumption within the Depot Repair Workbench. The view flattens the relational model of HZ_RELATIONSHIPS and the party attributes held in HZ_PARTIES into a single, wide result set, so that depot repair forms, LOVs, and workbench regions can retrieve relationship and address information without issuing multiple joins of their own.
The view is reported as VALID in the ETRM metadata repository. Because it is a view rather than a table, it stores no data; it is a read-only projection over the TCA entities. Column names carry a REL_ prefix for the related party and a SUB_ prefix for the subject party, allowing a consumer to distinguish the two sides of a relationship in one row. The user search term "rel_address" maps directly to the REL_ADDRESS column, which is a concatenated, single-line rendering of the related party's address elements.
Underlying Base Objects
The ETRM 12.2.2 metadata documents three referenced base objects: HZ_PARTIES (SYNONYM), HZ_RELATIONSHIPS (SYNONYM), and AR_LOOKUPS (VIEW). HZ_PARTIES is the master TCA party entity holding PARTY_ID, PARTY_NUMBER, PARTY_NAME, PARTY_TYPE, person name components, status, and language. HZ_RELATIONSHIPS supplies the association between the subject party, the object party, and the related party, together with the relationship code and direction. AR_LOOKUPS provides the seeded lookup values used to decode relationship types and other reference codes surfaced by the workbench. The view is therefore a join-driven projection, not a materialized or denormalized store.
The published view text confirms this construction: party attributes are drawn from the party source and aliased with REL_ and SUB_ prefixes. Address columns are taken directly (ADDRESS1 through ADDRESS4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY), and REL_ADDRESS is generated by concatenating ADDRESS1 with semicolon-delimited DECODE branches for ADDRESS2, ADDRESS3, and ADDRESS4, suppressing NULL elements.
Key Columns
- REL_PARTY_ID / REL_PARTY_NUMBER / REL_PARTY_NAME / REL_PARTY_TYPE — identity and classification of the related party.
- REL_PERSON_* columns — pre-name adjunct, first, middle, last name, and suffix for person-type related parties.
- REL_ADDRESS1–REL_ADDRESS4, REL_CITY, REL_STATE, REL_PROVINCE, REL_POSTAL_CODE, REL_COUNTY, REL_COUNTRY — structured address attributes.
- REL_ADDRESS — derived concatenation of the address lines, providing a single display string for the depot repair workbench.
- REL_STATUS, REL_EMAIL_ADDRESS, REL_LANGUAGE_NAME, REL_LAST_UPDATE_DATE — party status, contact e-mail, language, and audit timestamp.
- SUB_* columns — the equivalent attribute set for the subject party, mirroring the REL_ columns.
Common Use Cases and Queries
The view supports depot repair workbench display of customer and contact relationships, validation of the subject party on a repair order, and reporting on related-party address data. A typical query retrieves the related party and its formatted address for a given subject party.
SELECT rel_party_id, rel_party_name, rel_party_type, rel_address
FROM apps.csd_hz_rel_v
WHERE sub_party_id = :p_sub_party_id;
To search by address fragment, the concatenated REL_ADDRESS column can be filtered directly: WHERE UPPER(rel_address) LIKE '%'||UPPER(:p_address)||'%'. Join the view to the depot repair order tables on REL_PARTY_ID to enrich workbench enquiries. Because the view is read-only and defined over TCA synonyms, it should be queried through the APPS schema or a synonym, and never updated directly.
-
View: CSD_HZ_REL_V 12.1.1
View for details of Related, Subject, Object party. Used in the Depot Repair Workbench.
APPS.CSD_HZ_REL_V·↳ AR_LOOKUPS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CSD module →
-
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_ORG_ADV_V·↳ AR_LOOKUPS·↳ CSC_GS_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_PER_V 12.1.1
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_PER_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CSC module →
-
View: CSD_HZ_REL_V 12.2.2
View for details of Related, Subject, Object party. Used in the Depot Repair Workbench.
APPS.CSD_HZ_REL_V·↳ AR_LOOKUPS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CSD module →
-
View of HZ_PARTIES, HZ_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self party relationship details (Fetches data from the new Relationships model)
APPS.CSC_HZ_PARTIES_SELF_NEW_V·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CSC module →
-
View of HZ_RELATIONSHIPS. View is used to get party relationship details.
APPS.CSC_HZ_PARTY_RELATIONSHIPS_V·↳ AR_LOOKUPS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore CSC module →
-
View of HZ_RELATIONSHIPS. View is used to get party relationship details.
APPS.CSC_HZ_PARTY_RELATIONSHIPS_V·↳ AR_LOOKUPS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore CSC module →
-
This view has been specifically designed for Contact Center Search window. Gives Customer Party, Contact Party and Relationship Party information.
APPS.CSC_HZ_PARTIES_CONT_PTS_REL_V·↳ AR_LOOKUPS·↳ FND_TERRITORIES_VL·↳ HZ_CONTACT_POINTS·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_GRP_V 12.1.1
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_GRP_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_ORG_V 12.1.1
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_ORG_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_GRP_V 12.2.2
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_GRP_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CSC module →
-
View for details of Related, Subject, Object party.
APPS.CS_SR_HZ_RELATIONSHIPS_V·↳ AR_LOOKUPS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CS module →
-
This view has been specifically designed for Contact Center Search window. Gives Customer Party, Contact Party and Relationship Party information.
APPS.CSC_HZ_PARTIES_SRCH_REL_V·↳ AR_LOOKUPS·↳ FND_TERRITORIES_TL·↳ HZ_PARTIES·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_ORG_V 12.2.2
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_ORG_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_GEN_V 12.1.1
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_GEN_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_PER_V 12.2.2
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_PER_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_GEN_V 12.2.2
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_GEN_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CSC module →
-
View: CSC_HZ_PARTIES_SELF_V 12.2.2
View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self party relationship details
APPS.CSC_HZ_PARTIES_SELF_V·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CSC module →
-
View for details of Related, Subject, Object party.
APPS.CS_SR_HZ_RELATIONSHIPS_V·↳ AR_LOOKUPS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CS module →
-
Contains Relationship information, Subject (Caller) and Object (Person/Group/Organization) information
APPS.CSC_CUSTOMER_RESPONSE_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore CSC module →
-
This view has been specifically designed for Contact Center Search window. Gives Customer Party, Contact Party and Relationship Party information.
APPS.CSC_HZ_PARTIES_CONT_PTS_REL_V·↳ AR_LOOKUPS·↳ FND_TERRITORIES_VL·↳ HZ_CONTACT_POINTS·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_V 12.1.1
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_V·↳ AR_LOOKUPS·↳ CSC_GS_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·Explore CSC module →
-
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_PER_ADV_V·↳ AR_LOOKUPS·↳ CSC_GS_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·Explore CSC module →
-
View: CSC_GS_CUSTOMERS_V 12.2.2
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_V·↳ AR_LOOKUPS·↳ CSC_GS_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·Explore CSC module →
-
View: CSC_HZ_PARTIES_V 12.2.2
View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used to get party relationships details
APPS.CSC_HZ_PARTIES_V·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CSC module →
-
View: CSC_HZ_PARTIES_V 12.1.1
View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used to get party relationships details
APPS.CSC_HZ_PARTIES_V·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CSC module →
-
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_PER_ADV_V·↳ AR_LOOKUPS·↳ CSC_GS_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·Explore CSC module →
-
View used to perform search operation on customer information in the contact center form.
APPS.CSC_GS_CUSTOMERS_ORG_ADV_V·↳ AR_LOOKUPS·↳ CSC_GS_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·Explore CSC module →
-
This view has been specifically designed for Contact Center Search window. Gives Customer Party, Contact Party and Relationship Party information.
APPS.CSC_HZ_PARTIES_SRCH_REL_V·↳ AR_LOOKUPS·↳ FND_TERRITORIES_TL·↳ HZ_PARTIES·Explore CSC module →
-
View of HZ_PARTIES, HZ_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self party relationship details (Fetches data from the new Relationships model)
APPS.CSC_HZ_PARTIES_SELF_NEW_V·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CSC module →
-
Contains Relationship information, Subject (Caller) and Object (Person/Group/Organization) information
APPS.CSC_CUSTOMER_RESPONSE_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore CSC module →
-
View: CSC_HZ_PARTIES_SELF_V 12.1.1
View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self party relationship details
APPS.CSC_HZ_PARTIES_SELF_V·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore CSC module →
-
View: JTF_PARTIES_V 12.2.2
Party (Organization or Group or Person) and relationship information
APPS.JTF_PARTIES_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore JTF module →
-
View: JTF_PARTIES_V 12.1.1
Party (Organization or Group or Person) and relationship information
APPS.JTF_PARTIES_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore JTF module →
-
View: CSC_HZ_PARTIES_REL_V 12.2.2
Gives Customer Party, Contact Party and Relationship Party information
APPS.CSC_HZ_PARTIES_REL_V·↳ AR_LOOKUPS·↳ FND_TERRITORIES_TL·↳ HZ_PARTIES·Explore CSC module →
-
View: CSC_HZ_PARTIES_REL_V 12.1.1
Gives Customer Party, Contact Party and Relationship Party information
APPS.CSC_HZ_PARTIES_REL_V·↳ AR_LOOKUPS·↳ FND_TERRITORIES_TL·↳ HZ_PARTIES·Explore CSC module →
-
VIEW: APPS.CSD_HZ_REL_V 12.1.1