View: CLN_RN_UTIL_TO_ROLE_CUSTOMER_V

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

View Text

SELECT HP.PARTY_ID
, HPS.PARTY_SITE_ID
, NULL
, NULL
, NULL
, HP.PARTY_NAME
, HCAS.ECE_TP_LOCATION_CODE
FROM HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_PARTY_SITES HPS
, HZ_PARTIES HP
WHERE HP.PARTY_ID = HPS.PARTY_ID
AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID

Columns