View: HZ_PARTY_CONTACT_POINTS_V

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

View Text

SELECT A.CONTACT_POINT_ID
, A.CONTACT_POINT_TYPE
, A.STATUS
, A.PRIMARY_FLAG
, A.ORIG_SYSTEM_REFERENCE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.WH_UPDATE_DATE
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.GLOBAL_ATTRIBUTE_CATEGORY
, A.GLOBAL_ATTRIBUTE1
, A.GLOBAL_ATTRIBUTE2
, A.GLOBAL_ATTRIBUTE3
, A.GLOBAL_ATTRIBUTE4
, A.GLOBAL_ATTRIBUTE5
, A.GLOBAL_ATTRIBUTE6
, A.GLOBAL_ATTRIBUTE7
, A.GLOBAL_ATTRIBUTE8
, A.GLOBAL_ATTRIBUTE9
, A.GLOBAL_ATTRIBUTE10
, A.GLOBAL_ATTRIBUTE11
, A.GLOBAL_ATTRIBUTE12
, A.GLOBAL_ATTRIBUTE13
, A.GLOBAL_ATTRIBUTE14
, A.GLOBAL_ATTRIBUTE15
, A.GLOBAL_ATTRIBUTE16
, A.GLOBAL_ATTRIBUTE17
, A.GLOBAL_ATTRIBUTE18
, A.GLOBAL_ATTRIBUTE19
, A.GLOBAL_ATTRIBUTE20
, A.EDI_TRANSACTION_HANDLING
, A.EDI_ID_NUMBER
, A.EDI_PAYMENT_METHOD
, A.EDI_PAYMENT_FORMAT
, A.EDI_REMITTANCE_METHOD
, A.EDI_REMITTANCE_INSTRUCTION
, A.EDI_TP_HEADER_ID
, A.EDI_ECE_TP_LOCATION_CODE
, A.EMAIL_FORMAT
, A.EMAIL_ADDRESS
, A.BEST_TIME_TO_CONTACT_START
, A.BEST_TIME_TO_CONTACT_END
, A.PHONE_CALLING_CALENDAR
, A.CONTACT_ATTEMPTS
, A.CONTACTS
, A.DECLARED_BUSINESS_PHONE_FLAG
, A.DO_NOT_USE_FLAG
, A.DO_NOT_USE_REASON
, A.LAST_CONTACT_DT_TIME
, A.PHONE_PREFERRED_ORDER
, A.PRIORITY_OF_USE_CODE
, A.TELEPHONE_TYPE
, A.TIME_ZONE
, A.PHONE_TOUCH_TONE_TYPE_FLAG
, A.PHONE_AREA_CODE
, A.PHONE_COUNTRY_CODE
, A.PHONE_NUMBER
, A.PHONE_EXTENSION
, A.PHONE_LINE_TYPE
, A.TELEX_NUMBER
, A.WEB_TYPE
, A.URL
, A.CONTENT_SOURCE_TYPE
, C.PARTY_NUMBER
, C.PARTY_NAME
, C.PARTY_TYPE
, C.SIC_CODE
, C.HQ_BRANCH_IND
, C.CUSTOMER_KEY
, C.TAX_REFERENCE
, C.JGZZ_FISCAL_CODE
, C.DUNS_NUMBER
, C.TAX_NAME
, C.PERSON_PRE_NAME_ADJUNCT
, C.PERSON_FIRST_NAME
, C.PERSON_MIDDLE_NAME
, C.PERSON_LAST_NAME
, C.PERSON_NAME_SUFFIX
, C.PERSON_TITLE
, C.PERSON_ACADEMIC_TITLE
, C.PERSON_PREVIOUS_LAST_NAME
, C.KNOWN_AS
, C.PERSON_IDEN_TYPE
, C.PERSON_IDENTIFIER
, C.GROUP_TYPE
, C.COUNTRY
, C.ADDRESS1
, C.ADDRESS2
, C.ADDRESS3
, C.ADDRESS4
, C.CITY
, C.POSTAL_CODE
, C.STATE
, C.PROVINCE
, C.COUNTY
, C.SIC_CODE_TYPE
, C.TOTAL_NUM_OF_ORDERS
, C.TOTAL_ORDERED_AMOUNT
, C.LAST_ORDERED_DATE
, C.DO_NOT_MAIL_FLAG
, C.ANALYSIS_FY
, C.FISCAL_YEAREND_MONTH
, C.EMPLOYEES_TOTAL
, C.CURR_FY_POTENTIAL_REVENUE
, C.NEXT_FY_POTENTIAL_REVENUE
, C.YEAR_ESTABLISHED
, C.GSA_INDICATOR_FLAG
, C.MISSION_STATEMENT
, C.ORGANIZATION_NAME_PHONETIC
, C.PERSON_FIRST_NAME_PHONETIC
, C.PERSON_LAST_NAME_PHONETIC
, C.LANGUAGE_NAME
, C.CATEGORY_CODE
, C.REFERENCE_USE_FLAG
, C.THIRD_PARTY_FLAG
, C.COMPETITOR_FLAG
, C.SALUTATION
, C.KNOWN_AS2
, C.KNOWN_AS3
, C.KNOWN_AS4
, C.KNOWN_AS5
, C.PARTY_ID
FROM HZ_PARTIES C
, HZ_CONTACT_POINTS A
WHERE (C.PARTY_ID = A.OWNER_TABLE_ID)
AND (A.OWNER_TABLE_NAME = 'HZ_PARTIES')

Columns