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