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

HZ_PARTY_LINKS_V

Details

  • Schema: FUSION

  • Object owner: ZCH

  • Object type: VIEW

Columns

Name

LINK_TYPE

PARTY_ID

OBJECT_CODE

RELATED_PARTY_ID

LINK_CHANGE_DATE

LINK_REMOVED_FLAG

Query

SQL_Statement

select

lm.dedup_link_type link_type,

lp.party_id party_id,

lm.object_code object_code,

lm.record_id related_party_id,

lm.last_update_date link_change_date,

lm.restore_flag link_removed_flag

from

hz_parties lp,

zch_dedup_link_members lm

where exists (

select 1 from zch_dedup_link_members clm

where clm.data_set_uuid = lm.data_set_uuid

and clm.dedup_link_type = lm.dedup_link_type

and clm.dedup_link_id = lm.dedup_link_id

and clm.record_id = lp.party_id)

and lm.object_code is not null

and lm.data_set_uuid in (

nvl(sys_context('zch_link_res', 'data_set_uuid_1'), '47343de0-77e4-36b5-9697-dd51a77826c2'),

nvl(sys_context('zch_link_res', 'data_set_uuid_2'), '8e8ffdf7-0e40-34b3-a1f7-9179c9215f21'))

and lm.dedup_link_type in (

nvl(sys_context('zch_link_res', 'link_type_1'), lm.dedup_link_type),

nvl(sys_context('zch_link_res', 'link_type_2'), lm.dedup_link_type))