HZ_PARTY_LINK_MEMBERS_V

Details

• Schema: FUSION

• Object owner: ZCH

• Object type: VIEW

Columns

Name
LINK_TYPE PARTY_ID OBJECT_CODES LINK_CHANGE_DATE LINK_REMOVED_FLAG

Query

SQL_Statement

select ls.dedup_link_type link_type, lp.party_id party_id, (select listagg(distinct lm.object_code, ',') within group (order by lm.object_code) from zch_dedup_link_members lm where lm.data_set_uuid = ls.data_set_uuid and lm.dedup_link_type = ls.dedup_link_type and lm.dedup_link_id = ls.dedup_link_id and lm.record_id = lp.party_id) object_codes, ls.last_update_date link_change_date, decode(ls.dedup_link_status, 'A', 'N', 'Y') link_removed_flag from hz_parties lp, zch_dedup_links_b ls where exists ( select 1 from zch_dedup_link_members lm where lm.data_set_uuid = ls.data_set_uuid and lm.dedup_link_type = ls.dedup_link_type and lm.dedup_link_id = ls.dedup_link_id and lm.record_id = lp.party_id) and ls.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 ls.dedup_link_type in ( nvl(sys_context('zch_link_res', 'link_type_1'), ls.dedup_link_type), nvl(sys_context('zch_link_res', 'link_type_2'), ls.dedup_link_type))