View: AST_CONTACT_POINTS_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_CONTACT_POINTS_V

View Text

SELECT HZ.ROWID
, HZ.CONTACT_POINT_ID
, HZ.CONTACT_POINT_TYPE
, LKUP1.MEANING
, HZ.STATUS
, HZ.OWNER_TABLE_NAME
, HZ.OWNER_TABLE_ID
, HZ.PRIMARY_FLAG
, HZ.ORIG_SYSTEM_REFERENCE
, HZ.LAST_UPDATE_DATE
, HZ.LAST_UPDATED_BY
, HZ.CREATION_DATE
, HZ.CREATED_BY
, HZ.LAST_UPDATE_LOGIN
, HZ.REQUEST_ID
, HZ.PROGRAM_APPLICATION_ID
, HZ.PROGRAM_ID
, HZ.PROGRAM_UPDATE_DATE
, HZ.ATTRIBUTE_CATEGORY
, HZ.ATTRIBUTE1
, HZ.ATTRIBUTE2
, HZ.ATTRIBUTE3
, HZ.ATTRIBUTE4
, HZ.ATTRIBUTE5
, HZ.ATTRIBUTE6
, HZ.ATTRIBUTE7
, HZ.ATTRIBUTE8
, HZ.ATTRIBUTE9
, HZ.ATTRIBUTE10
, HZ.ATTRIBUTE11
, HZ.ATTRIBUTE12
, HZ.ATTRIBUTE13
, HZ.ATTRIBUTE14
, HZ.ATTRIBUTE15
, HZ.ATTRIBUTE16
, HZ.ATTRIBUTE17
, HZ.ATTRIBUTE18
, HZ.ATTRIBUTE19
, HZ.ATTRIBUTE20
, HZ.EDI_TRANSACTION_HANDLING
, HZ.EDI_ID_NUMBER
, HZ.EDI_PAYMENT_METHOD
, HZ.EDI_PAYMENT_FORMAT
, HZ.EDI_REMITTANCE_METHOD
, HZ.EDI_REMITTANCE_INSTRUCTION
, HZ.EDI_TP_HEADER_ID
, HZ.EDI_ECE_TP_LOCATION_CODE
, HZ.EMAIL_FORMAT
, HZ.EMAIL_ADDRESS
, HZ.PHONE_CALLING_CALENDAR
, HZ.LAST_CONTACT_DT_TIME
, HZ.TELEPHONE_TYPE
, HZ.PHONE_AREA_CODE
, HZ.PHONE_COUNTRY_CODE
, HZ.PHONE_NUMBER
, HZ.PHONE_EXTENSION
, HZ.PHONE_LINE_TYPE
, LKUP2.MEANING
, HZ.TELEX_NUMBER
, HZ.WEB_TYPE
, HZ.URL
, HZ.CONTENT_SOURCE_TYPE
, HZ.CONTACT_POINT_PURPOSE
, DECODE(HZ.CONTACT_POINT_TYPE
, 'WEB'
, LKUP5.MEANING
, LKUP4.MEANING) CONTACT_POINT_PURPOSE_MEANING
, HZ.OBJECT_VERSION_NUMBER
, HZ.CREATED_BY_MODULE
, HZ.APPLICATION_ID
, TM.NAME
, TM.NAME
, TM.UPGRADE_TZ_ID
, HZ.DO_NOT_USE_FLAG
, HZ.DO_NOT_USE_REASON
, HZ.BEST_TIME_TO_CONTACT_START
, HZ.BEST_TIME_TO_CONTACT_END
, NULL WH_UPDATE_DATE
FROM HZ_CONTACT_POINTS HZ
, AR_LOOKUPS LKUP1
, AR_LOOKUPS LKUP2
, AR_LOOKUPS LKUP4
, AR_LOOKUPS LKUP5
, FND_TIMEZONES_VL TM
WHERE HZ.CONTACT_POINT_TYPE = LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE(+) = 'COMMUNICATION_TYPE'
AND HZ.PHONE_LINE_TYPE = LKUP2.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE(+) = 'PHONE_LINE_TYPE'
AND HZ.CONTACT_POINT_PURPOSE = LKUP4.LOOKUP_CODE(+)
AND LKUP4.LOOKUP_TYPE(+) = 'CONTACT_POINT_PURPOSE'
AND HZ.CONTACT_POINT_PURPOSE = LKUP5.LOOKUP_CODE(+)
AND LKUP5.LOOKUP_TYPE(+) = 'CONTACT_POINT_PURPOSE_WEB'
AND TM.UPGRADE_TZ_ID(+) = HZ.TIMEZONE_ID
AND HZ.STATUS IN ('A'
, 'I')

Columns