POZ_ALL_CONTACTS_V
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: VIEW
Columns
Name |
---|
PARTY_ID FULL_NAME |
Query
SQL_Statement |
---|
SELECT hp.Party_id, poz_util.format_name(hp.party_id) AS FULL_NAME FROM hz_parties hp, poz_suppliers supp, hz_relationships hrel WHERE (hp.PARTY_ID = hrel.SUBJECT_ID AND hrel.RELATIONSHIP_TYPE = 'CONTACT' AND hrel.RELATIONSHIP_CODE = 'CONTACT_OF' AND hrel.SUBJECT_TYPE = 'PERSON' AND hrel.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND hrel.OBJECT_TYPE = 'ORGANIZATION' AND hrel.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND hrel.OBJECT_ID= supp.PARTY_ID) |