Skip to content FND Design Data [Home] [Help]

View: VEH_TRANSLATOR_ADDR_V

Product: VEH - Automotive Integration Kit (Obsolete)
Description: - Retrofitted
Implementation/DBA Data: Not implemented in this database
View Text

SELECT CUSTOMER_NUMBER CUSTOMER_NUMBER
, TO_CHAR(RAD.ADDRESS_ID) ADDRESS_ID
, RAD.ADDRESS1 ADDRESS
, 'INTERNAL' INT_EXT_CODE
FROM RA_ADDRESSES RAD
, RA_CUSTOMERS RAC
WHERE RAD.CUSTOMER_ID = RAC.CUSTOMER_ID UNION SELECT DISTINCT TO_CHAR(TP_GROUP_ID) CUSTOMER_NUMBER
, TP_REFERENCE_EXT2 ADDRESS_ID
, TP_REFERENCE_EXT2 ADDRESS
, 'EXTERNAL' INT_EXT_CODE
FROM ECE_TP_HEADERS ETH

Columns

Name
CUSTOMER_NUMBER
ADDRESS_ID
ADDRESS
INT_EXT_CODE