View: CLN_RN_UTIL_TO_ROLE_CUST_SUP_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	To populate the cusomer/supplier info in xml
Implementation/DBA Data:	APPS.CLN_RN_UTIL_TO_ROLE_CUST_SUP_V

View Text

SELECT 'C'
, TP_ID
, TP_SITE_ID
, CONTACT_NAME
, CONTACT_EMAIL
, CONTACT_TELEPHONE
, CONTACT_FAX
, EDI_LOCATION_CODE
FROM CLN_RN_UTIL_TO_ROLE_CUSTOMER_V UNION SELECT 'S'
, TP_ID
, TP_SITE_ID
, CONTACT_NAME
, CONTACT_EMAIL
, CONTACT_TELEPHONE
, CONTACT_FAX
, EDI_LOCATION_CODE
FROM CLN_RN_UTIL_TO_ROLE_SUPPLIER_V

Columns