VIEW: APPS.OE_CUSTOMER_ADDRESSES_V

Source

View Text - Preformatted

SELECT LOC.ADDRESS1, SITE.LOCATION, PARTY.PARTY_NAME CUSTOMER_NAME, SITE.SITE_USE_ID , SITE.LOCATION LOCATION_CODE, LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , decode(LOC.CITY,null, null, LOC.CITY|| ', ') ||decode(LOC.state, null, loc.Province|| ', ', LOC.state || ', ') || decode(LOC.postal_code,null, null, LOC.postal_code || ', ') || decode(LOC.country, null, null, LOC.country) , CUST_ACCT.CUST_ACCOUNT_ID , cust_acct.account_number , acct_site.status , cust_acct.status , site.status , site.site_use_code, acct_site.cust_acct_site_id, acct_site.org_id FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_PARTY_SITES PARTY_SITE, HZ_LOCATIONS LOC, HZ_CUST_SITE_USES_ALL SITE, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT WHERE SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID AND ACCT_SITE.CUST_ACCOUNT_ID=CUST_ACCT.CUST_ACCOUNT_ID AND CUST_ACCT.PARTY_ID=PARTY.PARTY_ID AND SITE.ORG_ID = ACCT_SITE.org_id

View Text - HTML Formatted

SELECT LOC.ADDRESS1
, SITE.LOCATION
, PARTY.PARTY_NAME CUSTOMER_NAME
, SITE.SITE_USE_ID
, SITE.LOCATION LOCATION_CODE
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, DECODE(LOC.CITY
, NULL
, NULL
, LOC.CITY|| '
, ') ||DECODE(LOC.STATE
, NULL
, LOC.PROVINCE|| '
, '
, LOC.STATE || '
, ') || DECODE(LOC.POSTAL_CODE
, NULL
, NULL
, LOC.POSTAL_CODE || '
, ') || DECODE(LOC.COUNTRY
, NULL
, NULL
, LOC.COUNTRY)
, CUST_ACCT.CUST_ACCOUNT_ID
, CUST_ACCT.ACCOUNT_NUMBER
, ACCT_SITE.STATUS
, CUST_ACCT.STATUS
, SITE.STATUS
, SITE.SITE_USE_CODE
, ACCT_SITE.CUST_ACCT_SITE_ID
, ACCT_SITE.ORG_ID
FROM HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_SITE_USES_ALL SITE
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
AND ACCT_SITE.CUST_ACCOUNT_ID=CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID=PARTY.PARTY_ID
AND SITE.ORG_ID = ACCT_SITE.ORG_ID