Product: | EC - e-Commerce Gateway |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT RAD.ADDRESS_ID ADDRESS_ID
, RAD.CUSTOMER_ID CUSTOMER_ID
, ETH.TP_HEADER_ID TP_HEADER_ID
, RAD.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, RAD.ADDRESS1 ADDRESS1
, RAD.ADDRESS2 ADDRESS2
, RAD.ADDRESS3 ADDRESS3
, RAD.ADDRESS4 ADDRESS4
, RAD.CITY CITY
, RAD.POSTAL_CODE POSTAL_CODE
, RAD.COUNTRY COUNTRY
, RAD.STATE STATE
, RAD.PROVINCE PROVINCE
, RAD.COUNTY COUNTY
, RAD.ECE_TP_LOCATION_CODE TP_LOCATION_CODE_EXT
, ETH.TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, ETH.TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
FROM RA_ADDRESSES_ALL RAD
, ECE_TP_HEADERS ETH
WHERE RAD.TP_HEADER_ID = ETH.TP_HEADER_ID (+)