1. Tables and Views for Sales and Fusion Service
  2. HZ_PARTY_LINK_MEMBERS_V

HZ_PARTY_LINK_MEMBERS_V

Details

  • Schema: FUSION

  • Object owner: ZCH

  • Object type: VIEW

Columns

Name

LINK_TYPE

MAIN_PARTY_ID

PARTY_ID

Query

SQL_Statement

select

lm.dedup_link_type link_type,

dl.master_id main_party_id,

lm.record_id party_id

from

zch_dedup_links_b dl,

zch_dedup_link_members lm

where lm.data_set_uuid = dl.data_set_uuid

and lm.dedup_link_type = dl.dedup_link_type

and lm.dedup_link_id = dl.dedup_link_id

and lm.restore_flag = 'N'

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'), 'B2F_EQUIV'),

nvl(sys_context('zch_link_res', 'link_type_2'), 'DQ_IDENTITY'))