View: RA_CUSTOMER_BILL_VIEW

Product:	AR - Receivables
Description:	Information about customer who is billed
Implementation/DBA Data:	APPS.RA_CUSTOMER_BILL_VIEW

View Text

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

Columns