View: AR_CUSTOMER_ALT_NAMES_V

Product:	AR - Receivables
Description:	Alternate customer names for lockbox name matching
Implementation/DBA Data:	APPS.AR_CUSTOMER_ALT_NAMES_V

View Text

SELECT AL.ROWID
, AL.ALT_NAME_ID
, AL.ALT_NAME
, CUST_ACCT.CUST_ACCOUNT_ID
, CUST_ACCT.ACCOUNT_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ORGANIZATION_NAME_PHONETIC
, NULL) /*CUSTOMER_NAME_PHONETIC*/
, RS.SITE_USE_ID
, RS.LOCATION
, RT.TERM_ID
, RT.NAME
, AL.CREATED_BY
, AL.CREATION_DATE
, AL.LAST_UPDATE_DATE
, AL.LAST_UPDATE_LOGIN
, AL.LAST_UPDATED_BY
, CUST_ACCT.ACCOUNT_NAME
, RS.ORG_ID
FROM AR_CUSTOMER_ALT_NAMES AL
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES_ALL RS
, RA_TERMS RT
WHERE AL.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND AL.SITE_USE_ID = RS.SITE_USE_ID(+)
AND AL.TERM_ID = RT.TERM_ID(+)

Columns