View: PA_CUSTOMER_SITES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CUSTOMER_SITES_V

View Text

SELECT DISTINCT LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4||DECODE(LOC.ADDRESS4
, NULL
, NULL
, '
, ')||LOC.CITY||'
, '||NVL(LOC.STATE
, LOC.PROVINCE)||'
, '||LOC.COUNTY
, ACCT_SITE.CUST_ACCT_SITE_ID
, ACCT_SITE.CUST_ACCOUNT_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, SU.SITE_USE_CODE
, LOC.ADDRESS1||' '||LOC.ADDRESS2||' '||LOC.ADDRESS3||' '||LOC.ADDRESS4||DECODE(LOC.ADDRESS4
, NULL
, NULL
, '
, ')||LOC.CITY||'
, '||NVL(LOC.STATE
, LOC.PROVINCE)||'
, '||LOC.COUNTY
, CUST_ACCT.ACCOUNT_NUMBER
FROM HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_CUST_SITE_USES SU
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
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 ACCT_SITE.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND NVL(SU.STATUS
, 'A') = 'A'
AND (SU.SITE_USE_CODE = 'BILL_TO'OR SU.SITE_USE_CODE = 'SHIP_TO') ORDER BY LOC.ADDRESS1

Columns