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