View: CLN_RN_UTIL_TO_ROLE_SUPPLIER_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View to get To Role Supplier information for RosetaNet outbound XGMs
Implementation/DBA Data:	APPS.CLN_RN_UTIL_TO_ROLE_SUPPLIER_V

View Text

SELECT PV.VENDOR_ID
, PVSA.VENDOR_SITE_ID
, PV.VENDOR_NAME
, PVSA.EMAIL_ADDRESS
, PVSA.AREA_CODE || ' ' || PVSA.PHONE
, PVSA.FAX_AREA_CODE || ' ' || PVSA.FAX
, PVSA.ECE_TP_LOCATION_CODE
FROM PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVSA
WHERE PV.VENDOR_ID = PVSA.VENDOR_ID

Columns