View: AR_CUSTOMER_FIND_V

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

View Text

SELECT CA.CUST_ACCOUNT_ID
, HP.PARTY_NAME
, HP.PERSON_FIRST_NAME
, HP.PERSON_LAST_NAME
, HL.ADDRESS1
, HL.CITY
, HL.STATE
, HL.POSTAL_CODE
, TER.DESCRIPTION COUNTRY
, HL.COUNTRY COUNTRY_CODE
, CA.ACCOUNT_NUMBER
, HP.PARTY_NUMBER
, CA.STATUS
, HP.TAX_REFERENCE
, HP.JGZZ_FISCAL_CODE TAXPAYER_ID
, CA.ORIG_SYSTEM_REFERENCE
, L_TYPE.MEANING CUSTOMER_TYPE_MEANING
, L_CAT.MEANING CUSTOMER_CATEGORY_MEANING
, L_CLASS.MEANING CUSTOMER_CLASS_MEANING
, HP.SIC_CODE
, HPS.PARTY_SITE_NUMBER
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.COUNTY
, HL.PROVINCE
, HP.CUSTOMER_KEY
, HL.ADDRESS_KEY
, HP.PARTY_TYPE
, HCS.CUST_ACCT_SITE_ID
, HP.PARTY_ID
FROM HZ_CUST_ACCOUNTS CA
, HZ_PARTIES HP
, HZ_CUST_ACCT_SITES_ALL HCS
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, FND_TERRITORIES_VL TER
, AR_LOOKUPS L_TYPE
, AR_LOOKUPS L_CAT
, AR_LOOKUPS L_CLASS
WHERE CA.PARTY_ID = HP.PARTY_ID
AND CA.CUST_ACCOUNT_ID = HCS.CUST_ACCOUNT_ID (+)
AND HCS.PARTY_SITE_ID = HPS.PARTY_SITE_ID (+)
AND HPS.LOCATION_ID = HL.LOCATION_ID (+)
AND HL.COUNTRY = TER.TERRITORY_CODE (+)
AND CA.CUSTOMER_TYPE = L_TYPE.LOOKUP_CODE (+)
AND L_TYPE.LOOKUP_TYPE(+) = 'CUSTOMER_TYPE'
AND HP.CATEGORY_CODE = L_CAT.LOOKUP_CODE (+)
AND L_CAT.LOOKUP_TYPE(+) = 'CUSTOMER_CATEGORY'
AND CA.CUSTOMER_CLASS_CODE = L_CLASS.LOOKUP_CODE (+)
AND L_CLASS.LOOKUP_TYPE(+) = 'CUSTOMER CLASS'

Columns