[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 |