VIEW: APPS.AR_CUSTOMER_FIND_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'