ZCA_ROLLUP_LINKED_PARTIES_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: HZ
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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' |