VIEW: APPS.AR_PARTY_FIND_V

Source

View Text - Preformatted

SELECT hp.party_id, hp.party_name, hp.person_last_name last_name, hp.person_first_name first_name, hl.address1, hl.city, hl.state, hl.postal_code, ter.description country, hl.country country_code, hp.party_number org_per_number, hp.status, hl.address2, hl.address3, hl.address4, hl.county, hl.province, hp.party_type, hp.customer_key, hl.address_key, hp.tax_reference, hp.jgzz_fiscal_code taxpayer_id, hp.person_pre_name_adjunct, hp.person_middle_name, hp.person_name_suffix, hp.organization_name_phonetic FROM hz_parties hp, hz_party_sites hps, hz_locations hl, fnd_territories_vl ter WHERE hp.party_id = hps.party_id (+) and hps.location_id = hl.location_id (+) and hl.country = ter.territory_code (+)

View Text - HTML Formatted

SELECT HP.PARTY_ID
, HP.PARTY_NAME
, HP.PERSON_LAST_NAME LAST_NAME
, HP.PERSON_FIRST_NAME FIRST_NAME
, HL.ADDRESS1
, HL.CITY
, HL.STATE
, HL.POSTAL_CODE
, TER.DESCRIPTION COUNTRY
, HL.COUNTRY COUNTRY_CODE
, HP.PARTY_NUMBER ORG_PER_NUMBER
, HP.STATUS
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.COUNTY
, HL.PROVINCE
, HP.PARTY_TYPE
, HP.CUSTOMER_KEY
, HL.ADDRESS_KEY
, HP.TAX_REFERENCE
, HP.JGZZ_FISCAL_CODE TAXPAYER_ID
, HP.PERSON_PRE_NAME_ADJUNCT
, HP.PERSON_MIDDLE_NAME
, HP.PERSON_NAME_SUFFIX
, HP.ORGANIZATION_NAME_PHONETIC
FROM HZ_PARTIES HP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, FND_TERRITORIES_VL TER
WHERE HP.PARTY_ID = HPS.PARTY_ID (+)
AND HPS.LOCATION_ID = HL.LOCATION_ID (+)
AND HL.COUNTRY = TER.TERRITORY_CODE (+)