[Home] [Help]
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
Name |
CUSTOMER_ID |
BILL_ID |
TERRITORY_ID |
ADDRESS1 |
CITY |
STATE |
POSTAL_CODE |
STATUS |