VIEW: APPS.IGS_OR_PHONES_V

Source

View Text - Preformatted

SELECT CONT_POINT.ROWID, CONT_POINT.CONTACT_POINT_ID, CONT_POINT.LAST_UPDATE_DATE, CONT_POINT.LAST_UPDATED_BY, CONT_POINT.CREATION_DATE, CONT_POINT.CREATED_BY, DECODE(CONT_POINT.CONTACT_POINT_TYPE, 'TLX',CONT_POINT.TELEX_NUMBER, CONT_POINT.PHONE_NUMBER), CONT_POINT.STATUS, NVL(CONT_POINT.PHONE_LINE_TYPE, CONT_POINT.CONTACT_POINT_TYPE), CONT_POINT.LAST_UPDATE_LOGIN, CONT_POINT.PHONE_COUNTRY_CODE, CONT_POINT.PHONE_AREA_CODE, CONT_POINT.PHONE_EXTENSION, CONT_POINT.PRIMARY_FLAG, CONT_POINT.ORIG_SYSTEM_REFERENCE, CONT_POINT.ATTRIBUTE_CATEGORY, CONT_POINT.ATTRIBUTE1, CONT_POINT.ATTRIBUTE2, CONT_POINT.ATTRIBUTE3, CONT_POINT.ATTRIBUTE4, CONT_POINT.ATTRIBUTE5, CONT_POINT.ATTRIBUTE6, CONT_POINT.ATTRIBUTE7, CONT_POINT.ATTRIBUTE8, CONT_POINT.ATTRIBUTE9, CONT_POINT.ATTRIBUTE10, CONT_POINT.ATTRIBUTE11, CONT_POINT.ATTRIBUTE12, CONT_POINT.ATTRIBUTE13, CONT_POINT.ATTRIBUTE14, CONT_POINT.ATTRIBUTE15, CONT_POINT.ATTRIBUTE16, CONT_POINT.ATTRIBUTE17, CONT_POINT.ATTRIBUTE18, CONT_POINT.ATTRIBUTE19, CONT_POINT.ATTRIBUTE20, CONT_POINT.CONTACT_POINT_TYPE, CONT_POINT.OWNER_TABLE_NAME, CONT_POINT.OWNER_TABLE_ID, CONT_POINT.TELEPHONE_TYPE, CONT_POINT.TIME_ZONE, CONT_POINT.PHONE_TOUCH_TONE_TYPE_FLAG, CONT_POINT.TELEX_NUMBER, CONT_POINT.WEB_TYPE, CONT_POINT.CONTACT_POINT_ID, CONT_POINT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM HZ_CONTACT_POINTS CONT_POINT WHERE CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES' AND CONT_POINT.CONTACT_POINT_TYPE NOT IN ('EDI','EMAIL','WEB')

View Text - HTML Formatted

SELECT CONT_POINT.ROWID
, CONT_POINT.CONTACT_POINT_ID
, CONT_POINT.LAST_UPDATE_DATE
, CONT_POINT.LAST_UPDATED_BY
, CONT_POINT.CREATION_DATE
, CONT_POINT.CREATED_BY
, DECODE(CONT_POINT.CONTACT_POINT_TYPE
, 'TLX'
, CONT_POINT.TELEX_NUMBER
, CONT_POINT.PHONE_NUMBER)
, CONT_POINT.STATUS
, NVL(CONT_POINT.PHONE_LINE_TYPE
, CONT_POINT.CONTACT_POINT_TYPE)
, CONT_POINT.LAST_UPDATE_LOGIN
, CONT_POINT.PHONE_COUNTRY_CODE
, CONT_POINT.PHONE_AREA_CODE
, CONT_POINT.PHONE_EXTENSION
, CONT_POINT.PRIMARY_FLAG
, CONT_POINT.ORIG_SYSTEM_REFERENCE
, CONT_POINT.ATTRIBUTE_CATEGORY
, CONT_POINT.ATTRIBUTE1
, CONT_POINT.ATTRIBUTE2
, CONT_POINT.ATTRIBUTE3
, CONT_POINT.ATTRIBUTE4
, CONT_POINT.ATTRIBUTE5
, CONT_POINT.ATTRIBUTE6
, CONT_POINT.ATTRIBUTE7
, CONT_POINT.ATTRIBUTE8
, CONT_POINT.ATTRIBUTE9
, CONT_POINT.ATTRIBUTE10
, CONT_POINT.ATTRIBUTE11
, CONT_POINT.ATTRIBUTE12
, CONT_POINT.ATTRIBUTE13
, CONT_POINT.ATTRIBUTE14
, CONT_POINT.ATTRIBUTE15
, CONT_POINT.ATTRIBUTE16
, CONT_POINT.ATTRIBUTE17
, CONT_POINT.ATTRIBUTE18
, CONT_POINT.ATTRIBUTE19
, CONT_POINT.ATTRIBUTE20
, CONT_POINT.CONTACT_POINT_TYPE
, CONT_POINT.OWNER_TABLE_NAME
, CONT_POINT.OWNER_TABLE_ID
, CONT_POINT.TELEPHONE_TYPE
, CONT_POINT.TIME_ZONE
, CONT_POINT.PHONE_TOUCH_TONE_TYPE_FLAG
, CONT_POINT.TELEX_NUMBER
, CONT_POINT.WEB_TYPE
, CONT_POINT.CONTACT_POINT_ID
, CONT_POINT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM HZ_CONTACT_POINTS CONT_POINT
WHERE CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND CONT_POINT.CONTACT_POINT_TYPE NOT IN ('EDI'
, 'EMAIL'
, 'WEB')