ZCH_EXP_LINKED_PARTIES_V

Details

• Schema: FUSION

• Object owner: ZCH

• Object type: VIEW

Columns

Name

DEDUP_LINK_ID LINK_NAME DEDUP_LINK_NUMBER DEDUP_LINK_STATUS DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN LAST_UPDATE_DATE LAST_UPDATED_BY OBJECT_VERSION_NUMBER OBJ_NAME MASTER_FLAG DEDUP_HEADER_ID DEDUP_LINK_MEMBER_ID PARTY_ID PARTY_NAME PARTY_NUMBER EFFECTIVE_END_DATE EFFECTIVE_START_DATE ORIG_SYSTEM ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REF_ID EMAIL_ADDRESS URL PRIMARY_PHONE_NUMBER ADDRESS1 ADDRESS2 ADDRESS3 ADDRESS4 CITY COUNTRY COUNTY PROVINCE STATE

Query

SQL_Statement

select DedupLinksB.DEDUP_LINK_ID, DedupLinksTL.LINK_NAME , DedupLinksB.DEDUP_LINK_NUMBER , DedupLinksB.DEDUP_LINK_STATUS , DedupLinksTL.DESCRIPTION, DedupLinksB.CREATED_BY, DedupLinksB.CREATION_DATE, DedupLinksB.LAST_UPDATE_LOGIN, DedupLinksB.LAST_UPDATE_DATE , DedupLinksB.LAST_UPDATED_BY , DedupLinksB.OBJECT_VERSION_NUMBER , DedupLinksB.OBJ_NAME , DedupLinkMembers.MASTER_FLAG, DedupLinksB.DEDUP_HEADER_ID, DedupLinkMembers.DEDUP_LINK_MEMBER_ID, Parties.PARTY_ID, Parties.PARTY_NAME, Parties.PARTY_NUMBER, DedupLinkMembers.EFFECTIVE_END_DATE, DedupLinkMembers.EFFECTIVE_START_DATE, OrigSysReferences.ORIG_SYSTEM, OrigSysReferences.ORIG_SYSTEM_REFERENCE, OrigSysReferences.ORIG_SYSTEM_REF_ID, Parties.EMAIL_ADDRESS, Parties.URL, Parties.PRIMARY_PHONE_NUMBER, Parties.ADDRESS1, Parties.ADDRESS2, Parties.ADDRESS3, Parties.ADDRESS4, Parties.CITY, Parties.COUNTRY, Parties.COUNTY, Parties.PROVINCE, Parties.STATE from ZCH_DEDUP_LINKS_B DedupLinksB, ZCH_DEDUP_LINKS_TL DedupLinksTL , ZCH_DATA_MGMT_MEMBERS DataMgmtMembers, ZCH_DEDUP_LINK_MEMBERS DedupLinkMembers, HZ_PARTIES Parties, HZ_ORIG_SYS_REFERENCES OrigSysReferences where DedupLinksB.DEDUP_LINK_ID = DedupLinksTL.DEDUP_LINK_ID AND DedupLinksTL.LANGUAGE = USERENV('LANG') AND (((DedupLinkMembers.DATA_MGMT_MEMBER_ID = DataMgmtMembers.DATA_MGMT_MEMBER_ID) AND (DedupLinksB.DEDUP_LINK_ID = DedupLinkMembers.DEDUP_LINK_ID)) AND (DataMgmtMembers.RECORD_ID = Parties.PARTY_ID)) AND (Parties.PARTY_ID = OrigSysReferences.OWNER_TABLE_ID(+)) and ( OrigSysReferences.OWNER_TABLE_NAME (+) = 'HZ_PARTIES' ) AND (Parties.STATUS = 'A') and (OrigSysReferences.STATUS(+) = 'A')