View: AR_SITE_USE_V

Product:	AR - Receivables
Description:	(Release 11.5 Only)
Implementation/DBA Data:	APPS.AR_SITE_USE_V

View Text

SELECT ACCT_SITE.CUST_ACCOUNT_ID
, S.LOCATION
, LOC.ADDRESS1|| DECODE(LOC.ADDRESS2
, NULL
, ''
, '
, ')||LOC.ADDRESS2|| DECODE(LOC.ADDRESS3
, NULL
, ''
, '
, ')||LOC.ADDRESS3|| DECODE(LOC.ADDRESS4
, NULL
, ''
, '
, ')||LOC.ADDRESS4|| DECODE(LOC.CITY
, NULL
, ''
, '
, ')||LOC.CITY|| DECODE(LOC.STATE
, NULL
, ''
, '
, ')||LOC.STATE ADDRESS
, S.SITE_USE_ID
, L.MEANING PRIMARY
FROM HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_SITE_USES S
, AR_LOOKUPS L
WHERE ACCT_SITE.CUST_ACCT_SITE_ID = S.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND S.SITE_USE_CODE = 'BILL_TO'
AND L.LOOKUP_TYPE = 'YES/NO'
AND L.LOOKUP_CODE = S.PRIMARY_FLAG

Columns