[Home] [Help]
| Product: | CS - Service |
|---|---|
| Description: | Customer product locations |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SU.LOCATION
, SU.SITE_USE_ID
, SU.SITE_USE_CODE
, LU.MEANING USAGE
, CUST.CUSTOMER_NAME CUSTOMER
, CUST.CUSTOMER_NUMBER CUSTOMER_NUMBER
, CUST.CUSTOMER_ID
, A.ADDRESS_ID
, A.ADDRESS1||'
, '|| A.ADDRESS2 ADDR1_ADDR2
, A.ADDRESS3||DECODE(A.ADDRESS3
, ''
, ''
, '
, ')|| A.ADDRESS4 ADDR3_ADDR4
, SUBSTR(A.CITY||DECODE(A.CITY
, ''
, ''
, '
, ')|| A.STATE|| DECODE(A.POSTAL_CODE
, ''
, ''
, ' ')|| A.POSTAL_CODE|| DECODE(A.COUNTRY
, ''
, ''
, '
, ')|| A.COUNTRY
, 1
, 240) CITY_STATE_CODE_CTRY
, A.ADDRESS1
, A.ADDRESS2
, A.ADDRESS3
, A.ADDRESS4
, A.CITY CITY
, A.STATE STATE
, A.POSTAL_CODE POSTAL_CODE
, A.COUNTRY COUNTRY
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 SU.STATUS = 'A'
AND LU.LOOKUP_TYPE = 'SITE_USE_CODE'