View: CLN_RN_UTIL_FROM_ROLE_V

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

View Text

SELECT ORG.ORGANIZATION_ID
, ORG.NAME
, NULL
, LOC.TELEPHONE_NUMBER_1
, LOC.TELEPHONE_NUMBER_2
, LOC.ECE_TP_LOCATION_CODE
FROM HR_LOCATIONS_ALL LOC
, HR_ALL_ORGANIZATION_UNITS_VL ORG
WHERE ORG.LOCATION_ID = LOC.LOCATION_ID

Columns