VIEW: APPS.AMS_P_FAX_V

Source

View Text - Preformatted

SELECT A.CONTACT_POINT_ID AMS_FAX_ID ,A.CONTACT_POINT_TYPE ,A.STATUS ,A.OWNER_TABLE_NAME ,A.OWNER_TABLE_ID PARTY_ID ,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.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 FROM HZ_CONTACT_POINTS A WHERE A.PRIMARY_FLAG = 'Y' AND A.OWNER_TABLE_NAME = 'HZ_PARTIES' AND A.CONTACT_POINT_TYPE='PHONE' AND A.PHONE_LINE_TYPE='FAX' AND A.CONTENT_SOURCE_TYPE='USER_ENTERED' AND A.STATUS='A'

View Text - HTML Formatted

SELECT A.CONTACT_POINT_ID AMS_FAX_ID
, A.CONTACT_POINT_TYPE
, A.STATUS
, A.OWNER_TABLE_NAME
, A.OWNER_TABLE_ID PARTY_ID
, 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.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
FROM HZ_CONTACT_POINTS A
WHERE A.PRIMARY_FLAG = 'Y'
AND A.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND A.CONTACT_POINT_TYPE='PHONE'
AND A.PHONE_LINE_TYPE='FAX'
AND A.CONTENT_SOURCE_TYPE='USER_ENTERED'
AND A.STATUS='A'