1. Tables and Views for Sales, Fusion Service, and Field Service
  2. HZ_RELATIONSHIP_TYPES_V

HZ_RELATIONSHIP_TYPES_V

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: VIEW

Columns

Name

RELATIONSHIP_TYPE_ID

TYPE_MEANING

TYPE_DESCRIPTION

FORWARD_REL_MEANING

FORWARD_REL_DESCRIPTION

BACKWARD_REL_MEANING

BACKWARD_REL_DESCRIPTION

ROLE_MEANING

ROLE_DESCRIPTION

LANGUAGE

SOURCE_LANG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

r.relationship_type_id,

l1.meaning type_meaning,

l1.description type_description,

l2.meaning forward_rel_meaning,

l2.description forward_rel_description,

l3.meaning backward_rel_meaning,

l3.description backward_rel_description,

l4.meaning role_meaning,

l4.description role_description,

l1.language,

l1.source_lang,

r.created_by,

r.creation_date,

r.last_updated_by,

r.last_update_date,

r.last_update_login,

r.object_version_number

FROM

hz_relationship_types r,

fnd_lookup_values_tl l1,

fnd_lookup_values_tl l2,

fnd_lookup_values_tl l3,

fnd_lookup_values_tl l4

WHERE

r.relationship_type = l1.lookup_code

AND l1.lookup_type = 'HZ_RELATIONSHIP_TYPE'

AND r.forward_rel_code = l2.lookup_code

AND l2.lookup_type = 'PARTY_RELATIONS_TYPE'

AND r.backward_rel_code = l3.lookup_code

AND l3.lookup_type = 'PARTY_RELATIONS_TYPE'

AND r.role = l4.lookup_code

AND l4.lookup_type = 'HZ_RELATIONSHIP_ROLE'

AND l1.language = l2.language

AND l1.language = l3.language

AND l1.language = l4.language

AND l1.source_lang = l2.source_lang

AND l1.source_lang = l3.source_lang

AND l1.source_lang = l4.source_lang