VIEW: APPS.EGO_VENDOR_V

Source

View Text - Preformatted

SELECT DISTINCT fu.user_name as USER_NAME, fu.user_id as USER_ID, asa.vendor_id as VENDOR_ID FROM fnd_user fu, ap_supplier_contacts ac, ap_suppliers asa, hz_relationships hr WHERE fu.person_party_id = ac.per_party_id AND hr.relationship_id = ac.relationship_id AND hr.object_id = asa.party_id

View Text - HTML Formatted

SELECT DISTINCT FU.USER_NAME AS USER_NAME
, FU.USER_ID AS USER_ID
, ASA.VENDOR_ID AS VENDOR_ID
FROM FND_USER FU
, AP_SUPPLIER_CONTACTS AC
, AP_SUPPLIERS ASA
, HZ_RELATIONSHIPS HR
WHERE FU.PERSON_PARTY_ID = AC.PER_PARTY_ID
AND HR.RELATIONSHIP_ID = AC.RELATIONSHIP_ID
AND HR.OBJECT_ID = ASA.PARTY_ID