HZ_LINKED_PARTIES_V
Details
-
Schema: FUSION
-
Object owner: ZCH
-
Object type: VIEW
Columns
Name |
---|
LINK_TYPE PARTY_ID RELATED_PARTY_ID LINK_CHANGE_DATE LINK_REMOVED_FLAG |
Query
SQL_Statement |
---|
select lm.dedup_link_type link_type, lm.record_id party_id, dl.master_id related_party_id, lm.last_update_date link_change_date, lm.restore_flag link_removed_flag 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.master_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')) and lm.restore_flag in ( nvl(sys_context('zch_link_res', 'link_removed_flag'), 'Y'), nvl(sys_context('zch_link_res', 'link_removed_flag'), 'N')) |