View: CS_RA_ADDR_INSTALL_RG_V

View Text

SELECT SU.LOCATION INSTALL_LOCATION
, SU.SITE_USE_ID
, LU.MEANING ADDRESS_USAGE
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, A.ADDRESS1||'
, '||' '|| A.ADDRESS2 ADDRESS_LINE_1
, A.ADDRESS3||DECODE(A.ADDRESS3
, ''
, ''
, '
, '||' ')|| A.ADDRESS4 ADDRESS_LINE_2
, SUBSTR(A.CITY||DECODE(A.CITY
, ''
, ''
, '
, '||' ')|| A.STATE|| DECODE(A.POSTAL_CODE
, ''
, ''
, ' ')|| A.POSTAL_CODE|| DECODE(A.COUNTRY
, ''
, ''
, '
, '||' ')|| A.COUNTRY
, 1
, 240) CITY_STATE_ZIP
, A.ADDRESS1
, A.ADDRESS2
, A.ADDRESS3
, A.ADDRESS4
, A.CITY CITY
, A.STATE STATE
, A.POSTAL_CODE
, A.COUNTRY
, A.CUSTOMER_ID
, A.ADDRESS1||'
, '||' '|| A.ADDRESS2 ||'
, ' || ' ' || A.ADDRESS3||DECODE(A.ADDRESS3
, ''
, ''
, '
, '||' ')|| A.ADDRESS4 ||'
, '||' '|| SUBSTR(A.CITY||DECODE(A.CITY
, ''
, ''
, '
, '||' ')|| A.STATE|| DECODE(A.POSTAL_CODE
, ''
, ''
, ' ')|| A.POSTAL_CODE|| DECODE(A.COUNTRY
, ''
, ''
, '
, '||' ')|| A.COUNTRY
, 1
, 240) FULL_ADDRESS
FROM RA_ADDRESSES A
, RA_SITE_USES SU
, AR_LOOKUPS LU
, RA_CUSTOMERS CUST
WHERE CUST.CUSTOMER_ID = A.CUSTOMER_ID
AND SU.ADDRESS_ID = A.ADDRESS_ID
AND SU.SITE_USE_CODE = LU.LOOKUP_CODE
AND CUST.STATUS = 'A'
AND A.STATUS = 'A'
AND LU.LOOKUP_TYPE = 'SITE_USE_CODE'

Columns