HZ_PARTY_LINKS_V

Details

• Schema: FUSION

• Object owner: ZCH

• Object type: VIEW

Columns

Name
LINK_TYPE MAIN_PARTY_ID LINK_CHANGE_DATE

Query

SQL_Statement

select dl.dedup_link_type link_type, dl.master_id main_party_id, dl.last_update_date link_change_date from zch_dedup_links_b dl where dl.dedup_link_status = 'A' and dl.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 dl.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'))