1. Tables and Views for Procurement
  2. POZ_ALL_CONTACTS_V

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)