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