[Home] [Help]
View: CLN_RN_UTIL_TO_ROLE_INTERNAL_V
Product: | CLN - Supply Chain Trading Connector for RosettaNet |
Description: | View to get To Role Internal information for RosetaNet outbound XGMs |
Implementation/DBA Data: |
APPS.CLN_RN_UTIL_TO_ROLE_INTERNAL_V
|
View Text
SELECT HRL.LOCATION_ID TP_ID
, HRL.LOCATION_ID TP_SITE_ID
, HRL.LOCATION_CODE
, NULL
, HRL.TELEPHONE_NUMBER_1
, NULL
, HRL.ECE_TP_LOCATION_CODE
FROM HR_LOCATIONS HRL
Columns
Name |
TP_ID |
TP_SITE_ID |
CONTACT_NAME |
CONTACT_EMAIL |
CONTACT_TELEPHONE |
CONTACT_FAX |
EDI_LOCATION_CODE |