[Home] [Help]
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
Name |
TP_ID |
TP_SITE_ID |
CONTACT_NAME |
CONTACT_EMAIL |
CONTACT_TELEPHONE |
CONTACT_FAX |
EDI_LOCATION_CODE |