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: HZ_CUSTOMER_PARTY_SITE_FIND_V

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

View Text

SELECT CA.CUST_ACCOUNT_ID
, ' '||HP.PARTY_NAME||' '
, 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
, CA.CUSTOMER_TYPE
, HP.CATEGORY_CODE
, CA.CUSTOMER_CLASS_CODE
, 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
, HP.PERSON_PRE_NAME_ADJUNCT
, HP.PERSON_MIDDLE_NAME
, HP.PERSON_NAME_SUFFIX
, HP.ORGANIZATION_NAME_PHONETIC
, CA.ACCOUNT_NAME
, HPS.IDENTIFYING_ADDRESS_FLAG
FROM HZ_CUST_ACCOUNTS CA
, HZ_PARTIES HP
, HZ_CUST_ACCT_SITES HCS
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, FND_TERRITORIES_TL TER
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 NVL(TER.LANGUAGE
, USERENV('LANG')) = USERENV('LANG') UNION SELECT -1
, HP.PARTY_NAME
, HP.PARTY_NAME
, HP.PERSON_FIRST_NAME
, HP.PERSON_LAST_NAME
, HP.ADDRESS1
, HP.CITY
, HP.STATE
, HP.POSTAL_CODE
, TER.DESCRIPTION COUNTRY
, HP.COUNTRY COUNTRY_CODE
, NULL
, HP.PARTY_NUMBER
, HP.STATUS
, HP.TAX_REFERENCE
, HP.JGZZ_FISCAL_CODE TAXPAYER_ID
, HP.ORIG_SYSTEM_REFERENCE
, NULL
, HP.CATEGORY_CODE
, NULL
, HP.SIC_CODE
, NULL
, HP.ADDRESS2
, HP.ADDRESS3
, HP.ADDRESS4
, HP.COUNTY
, HP.PROVINCE
, HP.CUSTOMER_KEY
, NULL
, HP.PARTY_TYPE
, -1
, HP.PARTY_ID
, HP.PERSON_PRE_NAME_ADJUNCT
, HP.PERSON_MIDDLE_NAME
, HP.PERSON_NAME_SUFFIX
, HP.ORGANIZATION_NAME_PHONETIC
, NULL
, 'Y'
FROM HZ_PARTIES HP
, FND_TERRITORIES_TL TER
WHERE HP.COUNTRY = TER.TERRITORY_CODE (+)
AND NVL(TER.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')

Columns

Name
CUSTOMER_ID
CUSTOMER_NAME
DUMMY_NAME
FIRST_NAME
LAST_NAME
ADDRESS1
CITY
STATE
POSTAL_CODE
COUNTRY
COUNTRY_CODE
CUSTOMER_NUMBER
ORG_PER_NUMBER
STATUS
TAX_REG_NUMBER
TAXPAYER_ID
REFERENCE
TYPE
CATEGORY
CLASS
SIC_CODE
PARTY_SITE_NUMBER
ADDRESS2
ADDRESS3
ADDRESS4
COUNTY
PROVINCE
CUSTOMER_KEY
ADDRESS_KEY
CUSTOMER_TYPE
ADDRESS_ID
PARTY_ID
PERSON_PRE_NAME_ADJUNCT
PERSON_MIDDLE_NAME
PERSON_NAME_SUFFIX
ORGANIZATION_NAME_PHONETIC
ACCOUNT_NAME
IDENTIFYING_FLAG