VIEW: APPS.AR_SITE_USE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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