VIEW: APPS.CSC_CC_CONTACT_POINTS_V

Source

View Text - Preformatted

SELECT CONT_POINT.ROWID , CONT_POINT.CONTACT_POINT_ID , CONT_POINT.OWNER_TABLE_ID , CONT_POINT.LAST_UPDATE_DATE , CONT_POINT.OBJECT_VERSION_NUMBER , CONT_POINT.CONTACT_POINT_PURPOSE , CONT_POINT.LAST_UPDATED_BY , CONT_POINT.CREATION_DATE , CONT_POINT.CREATED_BY , CONT_POINT.PHONE_NUMBER , CONT_POINT.STATUS , CONT_POINT.TELEPHONE_TYPE , CONT_POINT.CONTACT_POINT_TYPE , AR.MEANING , CONT_POINT.PHONE_LINE_TYPE , AR1.MEANING , 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.EMAIL_FORMAT , CONT_POINT.EMAIL_ADDRESS , CONT_POINT.TIME_ZONE , CONT_POINT.EDI_ID_NUMBER , CONT_POINT.URL , CONT_POINT.WEB_TYPE , CONT_POINT.TIMEZONE_ID , TZ.NAME , DECODE(CONT_POINT.CONTACT_POINT_TYPE, 'PHONE', CONT_POINT.PHONE_COUNTRY_CODE, NULL) VALUE1 , DECODE(CONT_POINT.CONTACT_POINT_TYPE, 'PHONE', CONT_POINT.PHONE_AREA_CODE, NULL) VALUE2 , DECODE(CONT_POINT.CONTACT_POINT_TYPE, 'PHONE', CONT_POINT.PHONE_NUMBER, 'EMAIL', CONT_POINT.EMAIL_ADDRESS, 'WEB', CONT_POINT.URL, 'EDI', CONT_POINT.EDI_ID_NUMBER, 'TELEX', CONT_POINT.TELEX_NUMBER, 'TLX', CONT_POINT.TELEX_NUMBER, NULL) VALUE3 ,CONT_POINT.OWNER_TABLE_NAME ,CONT_POINT.ATTRIBUTE1 FROM HZ_CONTACT_POINTS CONT_POINT, AR_LOOKUPS AR, AR_LOOKUPS AR1, FND_TIMEZONES_VL TZ WHERE AR.lookup_type = 'COMMUNICATION_TYPE' AND AR.lookup_code(+) = CONT_POINT.CONTACT_POINT_TYPE AND AR1.lookup_type(+) = 'PHONE_LINE_TYPE' AND AR1.lookup_code(+) = CONT_POINT.PHONE_LINE_TYPE AND TZ.UPGRADE_TZ_ID(+) = CONT_POINT.TIMEZONE_ID

View Text - HTML Formatted

SELECT CONT_POINT.ROWID
, CONT_POINT.CONTACT_POINT_ID
, CONT_POINT.OWNER_TABLE_ID
, CONT_POINT.LAST_UPDATE_DATE
, CONT_POINT.OBJECT_VERSION_NUMBER
, CONT_POINT.CONTACT_POINT_PURPOSE
, CONT_POINT.LAST_UPDATED_BY
, CONT_POINT.CREATION_DATE
, CONT_POINT.CREATED_BY
, CONT_POINT.PHONE_NUMBER
, CONT_POINT.STATUS
, CONT_POINT.TELEPHONE_TYPE
, CONT_POINT.CONTACT_POINT_TYPE
, AR.MEANING
, CONT_POINT.PHONE_LINE_TYPE
, AR1.MEANING
, 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.EMAIL_FORMAT
, CONT_POINT.EMAIL_ADDRESS
, CONT_POINT.TIME_ZONE
, CONT_POINT.EDI_ID_NUMBER
, CONT_POINT.URL
, CONT_POINT.WEB_TYPE
, CONT_POINT.TIMEZONE_ID
, TZ.NAME
, DECODE(CONT_POINT.CONTACT_POINT_TYPE
, 'PHONE'
, CONT_POINT.PHONE_COUNTRY_CODE
, NULL) VALUE1
, DECODE(CONT_POINT.CONTACT_POINT_TYPE
, 'PHONE'
, CONT_POINT.PHONE_AREA_CODE
, NULL) VALUE2
, DECODE(CONT_POINT.CONTACT_POINT_TYPE
, 'PHONE'
, CONT_POINT.PHONE_NUMBER
, 'EMAIL'
, CONT_POINT.EMAIL_ADDRESS
, 'WEB'
, CONT_POINT.URL
, 'EDI'
, CONT_POINT.EDI_ID_NUMBER
, 'TELEX'
, CONT_POINT.TELEX_NUMBER
, 'TLX'
, CONT_POINT.TELEX_NUMBER
, NULL) VALUE3
, CONT_POINT.OWNER_TABLE_NAME
, CONT_POINT.ATTRIBUTE1
FROM HZ_CONTACT_POINTS CONT_POINT
, AR_LOOKUPS AR
, AR_LOOKUPS AR1
, FND_TIMEZONES_VL TZ
WHERE AR.LOOKUP_TYPE = 'COMMUNICATION_TYPE'
AND AR.LOOKUP_CODE(+) = CONT_POINT.CONTACT_POINT_TYPE
AND AR1.LOOKUP_TYPE(+) = 'PHONE_LINE_TYPE'
AND AR1.LOOKUP_CODE(+) = CONT_POINT.PHONE_LINE_TYPE
AND TZ.UPGRADE_TZ_ID(+) = CONT_POINT.TIMEZONE_ID