eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AR_PARTY_FIND_V

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

View Text

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 (+)

Columns

Name
PARTY_ID
PARTY_NAME
LAST_NAME
FIRST_NAME
ADDRESS1
CITY
STATE
POSTAL_CODE
COUNTRY
COUNTRY_CODE
ORG_PER_NUMBER
STATUS
ADDRESS2
ADDRESS3
ADDRESS4
COUNTY
PROVINCE
PARTY_TYPE
CUSTOMER_KEY
ADDRESS_KEY
TAX_REFERENCE
TAXPAYER_ID
PERSON_PRE_NAME_ADJUNCT
PERSON_MIDDLE_NAME
PERSON_NAME_SUFFIX
CUSTOMER_NAME_PHONETIC