VIEW: APPS.PA_CUSTOMER_SITES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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