1. Tables and Views for Procurement
  2. POZ_SUPPLIER_USERS_V

POZ_SUPPLIER_USERS_V

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: VIEW

Columns

Name

USER_ID

USER_NAME

USER_END_DATE

PERSON_PARTY_ID

VENDOR_PARTY_ID

VENDOR_ID

RELATIONSHIP_ID

END_DATE

SUPPLIER_NAME

PERSON_NAME

Query

SQL_Statement

SELECT

pu.user_guid user_id,

pu.username user_name,

pu.end_date user_end_date,

pu.party_id person_party_id,

sup.party_id vendor_party_id,

sup.vendor_id,

hzr.relationship_id,

hzr.end_date,

supplier_party.party_name supplier_name,

user_party.party_name person_name

FROM

poz_suppliers sup,

hz_parties user_party,

per_users pu,

hz_relationships hzr,

hz_parties supplier_party

WHERE

pu.party_id = user_party.party_id

AND hzr.relationship_type = 'CONTACT'

AND hzr.relationship_code = 'CONTACT_OF'

AND hzr.subject_id = user_party.party_id

AND hzr.subject_type = 'PERSON'

AND hzr.subject_table_name = 'HZ_PARTIES'

AND hzr.object_type = 'ORGANIZATION'

AND hzr.object_table_name = 'HZ_PARTIES'

AND hzr.object_id = sup.party_id

AND hzr.status = 'A'

AND supplier_party.party_id = sup.party_id