CN_SRP_PARTICIPANT_NAME_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
PARTICIPANT_ID PARTY_ID START_DATE END_DATE ACTIVE_FLAG PARTICIPANT_TYPE ORG_ID PARTY_NAME PARTICIPANT_NAME EMAIL_ADDRESS

Query

SQL_Statement
SELECT csp.participant_id, csp.party_id, csp.start_date, csp.end_date, csp.active_flag, csp.participant_type, csp.org_id, hzp.party_name, hzp.party_name participant_name, hzp.email_address FROM cn_srp_participants_all csp, hz_parties hzp WHERE csp.party_id = hzp.party_id