View: EGO_VENDOR_V

Product:	EGO - Advanced Product Catalog
Description:	This view is used to store the vendor ids against supplier contacts
Implementation/DBA Data:	APPS.EGO_VENDOR_V

View Text

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

Columns