Search Results party_role_code

Overview

The CS_HZ_SR_CONTACT_POINTS_V view is an APPS-owned database object within the Service (CS) product family of Oracle E-Business Suite. It is documented as a backward-compatibility view created for the CS_HZ_SR_CONTACT_POINTS table. In the EBS 12.1.1 and 12.2.2 data models, Service Request contact point data was migrated into the Trading Community Architecture (TCA) / HZ (Oracle Customers Online) schema. Rather than exposing the raw HZ-backed structure to existing Service forms, reports, and integrations, Oracle retained this view as a stable interface so that pre-existing customizations and dependent code continue to resolve without modification.

The view is registered in APPS with a VALID status, confirming it is a synonym-backed access path rather than a physically distinct datastore. Its primary purpose is to present Service Request / party contact point relationships in the legacy column layout expected by historical Service reporting and integration code.

Underlying Base Objects

The documented ETRM metadata identifies a single referenced base object: the synonym CS_HZ_SR_CONTACT_POINTS. The view text performs a direct projection from that object, with two important filters applied at the view definition level:

PARTY_ROLE_CODE = 'CONTACT' — restricts returned rows to records whose party role is the standard contact role.
An effective-dating filter using START_DATE_ACTIVE and END_DATE_ACTIVE, compared against TRUNC(SYSDATE) with NVL defaults so that null start and end dates are treated as open-ended.

Because the view is a straightforward select over the base synonym with row-level filters, it inherits the base object's columns without transformation. Any DML against the view is controlled by the updatability of the underlying synonym, and administrators should treat the view as read-oriented for reporting purposes.

Key Columns

SR_CONTACT_POINT_ID — Primary identifier for the Service Request contact point record.
PARTY_ID — The TCA party associated with the contact point.
INCIDENT_ID — The Service Request (incident) to which the contact point is linked.
CONTACT_POINT_TYPE / CONTACT_TYPE — Classify the contact point (for example, phone, email, or web), supporting communication routing and channel analysis.
CONTACT_POINT_ID — Identifier of the underlying contact point in TCA; note the distinction from the SR-level SR_CONTACT_POINT_ID.
PRIMARY_FLAG — Indicates whether the contact point is the preferred one for the party/incident combination.
PARTY_ROLE_CODE — The party role for the relationship; the view consistently returns 'CONTACT' given its filter.
START_DATE_ACTIVE / END_DATE_ACTIVE — Effective dating window used by the view's date predicate.
Standard WHO/audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — plus concurrent program context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) and SECURITY_GROUP_ID.

Common Use Cases and Queries

The view is typically queried to enumerate active contact points for a Service Request or party, to identify the primary contact, and to join Service Request data with TCA party information in custom reports and extracts.

Example — active contact points for a given incident:

SELECT sr_contact_point_id, party_id, contact_point_type, contact_type, primary_flag FROM apps.cs_hz_sr_contact_points_v WHERE incident_id = :incident_id;

Example — primary contacts by party:

SELECT party_id, contact_point_id, contact_type FROM apps.cs_hz_sr_contact_points_v WHERE party_id = :party_id AND primary_flag = 'Y';

Because the effective-dating predicate is embedded in the view, callers do not need to add date filters for point-in-time "active now" queries. When the search term involves party_role_code, note that this column will always evaluate to 'CONTACT' when queried through the view; use the base CS_HZ_SR_CONTACT_POINTS object if other role codes must be retrieved.

View: CS_HZ_SR_CONTACT_POINTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_HZ_SR_CONTACT_POINTS_V, object_name:CS_HZ_SR_CONTACT_POINTS_V, status:VALID, product: CS - Service , description: This view is created for backward compatibility for CS_HZ_SR_CONTACT_POINTS table. , implementation_dba_data: APPS.CS_HZ_SR_CONTACT_POINTS_V ,
View: CS_HZ_SR_CONTACT_POINTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_HZ_SR_CONTACT_POINTS_V, object_name:CS_HZ_SR_CONTACT_POINTS_V, status:VALID, product: CS - Service , description: This view is created for backward compatibility for CS_HZ_SR_CONTACT_POINTS table. , implementation_dba_data: APPS.CS_HZ_SR_CONTACT_POINTS_V ,
Table: CS_PARTY_ROLES_TL 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_PARTY_ROLES_TL, object_name:CS_PARTY_ROLES_TL, status:VALID, product: CS - Service , description: This is a MLS table and stores party roles definition. , implementation_dba_data: CS.CS_PARTY_ROLES_TL ,
Table: CS_PARTY_ROLES_TL 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_PARTY_ROLES_TL, object_name:CS_PARTY_ROLES_TL, status:VALID, product: CS - Service , description: This is a MLS table and stores party roles definition. , implementation_dba_data: CS.CS_PARTY_ROLES_TL ,
View: CS_PR_OCV 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_PR_OCV, object_name:CS_PR_OCV, status:VALID, product: CS - Service , description: This view will read the object classifications (Party Role) for extensible attributes. , implementation_dba_data: APPS.CS_PR_OCV ,
Table: CS_PARTY_ROLES_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_PARTY_ROLES_B, object_name:CS_PARTY_ROLES_B, status:VALID, product: CS - Service , description: This is the base table for storing all the party role definitions. , implementation_dba_data: CS.CS_PARTY_ROLES_B ,
View: CS_PR_OCV 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_PR_OCV, object_name:CS_PR_OCV, status:VALID, product: CS - Service , description: This view will read the object classifications (Party Role) for extensible attributes. , implementation_dba_data: APPS.CS_PR_OCV ,
Table: CS_PARTY_ROLES_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_PARTY_ROLES_B, object_name:CS_PARTY_ROLES_B, status:VALID, product: CS - Service , description: This is the base table for storing all the party role definitions. , implementation_dba_data: CS.CS_PARTY_ROLES_B ,
View: CS_PARTY_ROLES_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_PARTY_ROLES_VL, object_name:CS_PARTY_ROLES_VL, status:VALID, product: CS - Service , description: This is a _VL view. This view is based on table cs_party_roles_b and _tl table. , implementation_dba_data: APPS.CS_PARTY_ROLES_VL ,
View: CS_PARTY_ROLES_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_PARTY_ROLES_VL, object_name:CS_PARTY_ROLES_VL, status:VALID, product: CS - Service , description: This is a _VL view. This view is based on table cs_party_roles_b and _tl table. , implementation_dba_data: APPS.CS_PARTY_ROLES_VL ,
View: CS_SR_SEARCH_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_SEARCH_V, object_name:CS_SR_SEARCH_V, status:VALID, product: CS - Service , description: This view is used in the SR find window on Bali spread table , implementation_dba_data: APPS.CS_SR_SEARCH_V ,
View: CS_SR_SEARCH_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_SEARCH_V, object_name:CS_SR_SEARCH_V, status:VALID, product: CS - Service , description: This view is used in the SR find window on Bali spread table , implementation_dba_data: APPS.CS_SR_SEARCH_V ,