View: WSH_ADDRESS_TP_V

View Text

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 (+)
AND 'THIS VIEW IS OBSOLETE
FROM PATCHSET I ONWARDS' = 'TRUE'

Columns