View: SO_SHIP_TO_LOCATIONS_ACTIVE_V

View Text

SELECT RSU.SITE_USE_ID
, RSU.LOCATION
, RSU.GSA_INDICATOR
, RAC.CUSTOMER_ID
, RAC.CUSTOMER_NAME
, RAC.CUSTOMER_NUMBER
, RA.ADDRESS_ID
, RA.ADDRESS1
, RA.ADDRESS2
, RA.ADDRESS3
, RA.ADDRESS4
, RA.CITY||'
, '||RA.STATE||' '||RA.POSTAL_CODE ADDRESS5
, RA.CITY
, RA.STATE
, RA.POSTAL_CODE
FROM RA_ADDRESSES RA
, RA_SITE_USES RSU
, RA_CUSTOMERS RAC
WHERE RA.STATUS = 'A'
AND RA.ADDRESS_ID = RSU.ADDRESS_ID
AND RSU.STATUS = 'A'
AND RSU.SITE_USE_CODE = 'SHIP_TO'
AND RAC.CUSTOMER_ID = RA.CUSTOMER_ID
AND RAC.STATUS = 'A'
AND NVL(RAC.CUSTOMER_PROSPECT_CODE
, 'CUSTOMER') = 'CUSTOMER'

Columns