View: RA_CUSTOMER_SHIP_VIEW

Product:	AR - Receivables
Description:	Information about customer who gets the shipments
Implementation/DBA Data:	APPS.RA_CUSTOMER_SHIP_VIEW

View Text

SELECT ACCT_SITE.CUST_ACCOUNT_ID CUSTOMER_ID
, SU.SITE_USE_ID
, SU.TERRITORY_ID
, LOC.ADDRESS1
, LOC.CITY
, LOC.STATE
, LOC.POSTAL_CODE
, ACCT_SITE.STATUS
FROM HZ_CUST_SITE_USES_ALL SU
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
WHERE ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND SU.SITE_USE_CODE = 'SHIP_TO'

Columns