ZCA_ROLLUP_LINKED_PARTIES

Details

Name
MASTER_FLAG CONTEXT_PARTY_ID LINKED_PARTY_ID LAST_UPDATE_DATE

Name

MASTER_FLAG

CONTEXT_PARTY_ID

LINKED_PARTY_ID

LAST_UPDATE_DATE

SQL_Statement
SELECT lm.master_flag, dl.master_id context_party_id, lm.record_id linked_party_id, dl.last_update_date FROM zch_dedup_links_b dl, zch_dedup_link_members lm WHERE dl.dedup_link_status ='A' and lm.dedup_link_id = dl.dedup_link_id and lm.effective_start_date <= trunc(SYSDATE+1) and (lm.effective_end_date >= trunc(SYSDATE) or lm.effective_end_date is null) and lm.restore_flag ='N' and dl.dedup_link_type = lm.dedup_link_type and lm.dedup_link_type='B2F_EQUIV' and dl.data_set_uuid = lm.data_set_uuid and lm.data_set_uuid='47343de0-77e4-36b5-9697-dd51a77826c2'

SQL_Statement

SELECT

lm.master_flag,

dl.master_id context_party_id,

lm.record_id linked_party_id,

dl.last_update_date

FROM zch_dedup_links_b dl,

zch_dedup_link_members lm

WHERE dl.dedup_link_status ='A'

and lm.dedup_link_id = dl.dedup_link_id

and lm.effective_start_date <= trunc(SYSDATE+1)

and (lm.effective_end_date >= trunc(SYSDATE) or lm.effective_end_date is null)

and lm.restore_flag ='N'

and dl.dedup_link_type = lm.dedup_link_type

and lm.dedup_link_type='B2F_EQUIV'

and dl.data_set_uuid = lm.data_set_uuid

and lm.data_set_uuid='47343de0-77e4-36b5-9697-dd51a77826c2'