VIEW: APPS.AST_CONTACT_POINTS_V

Source

View Text - Preformatted

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 , DECODE(ltrim(rtrim(TM.NAME||' (GMT '||rtrim(tz_offset(TM.TIMEZONE_CODE),chr(0))||') ')),'(GMT )', NULL,TM.NAME||' (GMT '||rtrim(tz_offset(TM.TIMEZONE_CODE),chr(0))||') '), 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')

View Text - HTML Formatted

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
, DECODE(LTRIM(RTRIM(TM.NAME||' (GMT '||RTRIM(TZ_OFFSET(TM.TIMEZONE_CODE)
, CHR(0))||') '))
, '(GMT )'
, NULL
, TM.NAME||' (GMT '||RTRIM(TZ_OFFSET(TM.TIMEZONE_CODE)
, CHR(0))||') ')
, 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')