View: ARI_CUSTOMER_SEARCH_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.ARI_CUSTOMER_SEARCH_V

View Text

SELECT CUST.CUST_ACCOUNT_ID CUSTOMER_ID
, 'ADDR' DETAILS_LEVEL
, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER
, PARTY.PARTY_NAME CUSTOMER_NAME
, ADDR.CUST_ACCT_SITE_ID ADDRESS_ID
, ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.COUNTY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, TERR.TERRITORY_SHORT_NAME) CONCATENATED_ADDRESS
, TO_CHAR(NULL) CONTACT_NAME
, TO_CHAR(NULL) CONTACT_PHONE
, -1 BILL_TO_SITE_USE_ID
, TO_CHAR(NULL) SITE_USES
, ADDR.ORG_ID
FROM HZ_CUST_ACCOUNTS CUST
, HZ_PARTIES PARTY
, HZ_CUST_ACCT_SITES ADDR
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, FND_TERRITORIES_TL TERR
WHERE ADDR.CUST_ACCOUNT_ID = CUST.CUST_ACCOUNT_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID
AND ADDR.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG') UNION SELECT CUST.CUST_ACCOUNT_ID CUSTOMER_ID
, 'CUST' DETAILS_LEVEL
, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER
, PARTY.PARTY_NAME CUSTOMER_NAME
, -1 ADDRESS_ID
, 'ALL_LOCATIONS' CONCATENATED_ADDRESS
, TO_CHAR(NULL) CONTACT_NAME
, TO_CHAR(NULL) CONTACT_PHONE
, -1 BILL_TO_SITE_USE_ID
, TO_CHAR(NULL) SITE_USES
, -1 ORG_ID
FROM HZ_CUST_ACCOUNTS CUST
, HZ_PARTIES PARTY
WHERE CUST.PARTY_ID = PARTY.PARTY_ID

Columns