Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CP.ROWID ROW_ID
, CP.CONTACT_POINT_ID
, CP.CONTACT_POINT_TYPE
, CP.STATUS
, L1.MEANING STATUS_MEANING
, CP.OWNER_TABLE_NAME
, CP.OWNER_TABLE_ID
, CP.PRIMARY_FLAG
, CP.ORIG_SYSTEM_REFERENCE
, CP.LAST_UPDATE_DATE
, CP.LAST_UPDATED_BY
, CP.CREATION_DATE
, CP.CREATED_BY
, CP.LAST_UPDATE_LOGIN
, TO_DATE(NULL) WH_UPDATE_DATE
, CP.REQUEST_ID
, CP.PROGRAM_APPLICATION_ID
, CP.PROGRAM_ID
, CP.PROGRAM_UPDATE_DATE
, CP.ATTRIBUTE_CATEGORY
, CP.ATTRIBUTE1
, CP.ATTRIBUTE2
, CP.ATTRIBUTE3
, CP.ATTRIBUTE4
, CP.ATTRIBUTE5
, CP.ATTRIBUTE6
, CP.ATTRIBUTE7
, CP.ATTRIBUTE8
, CP.ATTRIBUTE9
, CP.ATTRIBUTE10
, CP.ATTRIBUTE11
, CP.ATTRIBUTE12
, CP.ATTRIBUTE13
, CP.ATTRIBUTE14
, CP.ATTRIBUTE15
, CP.ATTRIBUTE16
, CP.ATTRIBUTE17
, CP.ATTRIBUTE18
, CP.ATTRIBUTE19
, CP.ATTRIBUTE20
, CP.EDI_TRANSACTION_HANDLING
, CP.EDI_ID_NUMBER
, CP.EDI_PAYMENT_METHOD
, CP.EDI_PAYMENT_FORMAT
, CP.EDI_REMITTANCE_METHOD
, CP.EDI_REMITTANCE_INSTRUCTION
, CP.EDI_TP_HEADER_ID
, CP.EDI_ECE_TP_LOCATION_CODE
, L3.MEANING EMAIL_FORMAT_MEANING
, CP.EMAIL_FORMAT
, CP.EMAIL_ADDRESS
, CP.BEST_TIME_TO_CONTACT_START
, CP.BEST_TIME_TO_CONTACT_END
, CP.PHONE_CALLING_CALENDAR
, CP.CONTACT_ATTEMPTS
, CP.CONTACTS
, CP.DECLARED_BUSINESS_PHONE_FLAG
, CP.DO_NOT_USE_FLAG
, CP.DO_NOT_USE_REASON
, CP.LAST_CONTACT_DT_TIME
, CP.PHONE_PREFERRED_ORDER
, CP.PRIORITY_OF_USE_CODE
, CP.TELEPHONE_TYPE
, CP.TIME_ZONE
, CP.PHONE_TOUCH_TONE_TYPE_FLAG
, CP.PHONE_AREA_CODE
, CP.PHONE_COUNTRY_CODE
, CP.PHONE_NUMBER
, CP.PHONE_EXTENSION
, CP.PHONE_LINE_TYPE
, L2.MEANING PHONE_LINE_TYPE_MEANING
, CP.TELEX_NUMBER
, CP.WEB_TYPE
, CP.URL
, CP.CONTENT_SOURCE_TYPE
, CP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM HZ_CONTACT_POINTS CP
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, FND_LOOKUP_VALUES L3
WHERE CP.STATUS = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'REGISTRY_STATUS'
AND L1.LANGUAGE (+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID (+) = 222
AND L1.SECURITY_GROUP_ID (+) = 0
AND CP.PHONE_LINE_TYPE = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE (+) = 'PHONE_LINE_TYPE'
AND L2.LANGUAGE (+) = USERENV('LANG')
AND L2.VIEW_APPLICATION_ID (+) = 222
AND L2.SECURITY_GROUP_ID (+) = 0
AND CP.EMAIL_FORMAT = L3.LOOKUP_CODE (+)
AND L3.LOOKUP_TYPE (+) = 'EMAIL_FORMAT'
AND L3.LANGUAGE (+) = USERENV('LANG')
AND L3.VIEW_APPLICATION_ID (+) = 222
AND L3.SECURITY_GROUP_ID (+) = 0