Product: | ASO - Order Capture |
---|---|
Description: | view based on hz_contact_points |
Implementation/DBA Data: | APPS.ASO_I_CONTACT_POINTS_V |
SELECT CONTACT_POINT_ID
, CONTACT_POINT_TYPE
, STATUS
, OWNER_TABLE_NAME
, OWNER_TABLE_ID
, PRIMARY_FLAG
, EMAIL_FORMAT
, EMAIL_ADDRESS
, BEST_TIME_TO_CONTACT_START
, BEST_TIME_TO_CONTACT_END
, DO_NOT_USE_FLAG
, DO_NOT_USE_REASON
, LAST_CONTACT_DT_TIME
, TELEPHONE_TYPE
, PHONE_TOUCH_TONE_TYPE_FLAG
, PHONE_AREA_CODE
, PHONE_COUNTRY_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, PHONE_LINE_TYPE
, TELEX_NUMBER
, WEB_TYPE
, URL
, ORIG_SYSTEM_REFERENCE
, ROWID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
FROM HZ_CONTACT_POINTS