View: OE_CUSTOMER_ADDRESSES_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_CUSTOMER_ADDRESSES_V

View Text

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

Columns