POZ_ALL_CONTACTS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: POZ
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PARTY_ID FULL_NAME |
問合せ
| 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) |