VIEW: APPS.ASO_I_CONTACT_POINTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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