HZ_CONSUMER_PROFILES_V

Details

• Schema: FUSION

• Object owner: HZ

• Object type: VIEW

Columns

Name
PERSON_PROFILE_ID PARTY_ID PARTY_NUMBER CONSUMER_PROFILE_ID

Query

SQL_Statement
SELECT A.PERSON_PROFILE_ID, A.PARTY_ID, A.PARTY_NUMBER, B.CONSUMER_PROFILE_ID FROM fusion.HZ_PERSON_PROFILES A, fusion.HZ_CONSUMER_PROFILES B WHERE A.PERSON_PROFILE_ID = B.CONSUMER_PROFILE_ID