VIEW: APPS.PER_CONTACT_EXTRA_INFO

Source

View Text - Preformatted

SELECT contact_extra_info_id, effective_start_date, effective_end_date, contact_relationship_id, information_type, cei_information_category, cei_information1, cei_information2, cei_information3, cei_information4, cei_information5, cei_information6, cei_information7, cei_information8, cei_information9, cei_information10, cei_information11, cei_information12, cei_information13, cei_information14, cei_information15, cei_information16, cei_information17, cei_information18, cei_information19, cei_information20, cei_information21, cei_information22, cei_information23, cei_information24, cei_information25, cei_information26, cei_information27, cei_information28, cei_information29, cei_information30, cei_attribute_category, cei_attribute1, cei_attribute2, cei_attribute3, cei_attribute4, cei_attribute5, cei_attribute6, cei_attribute7, cei_attribute8, cei_attribute9, cei_attribute10, cei_attribute11, cei_attribute12, cei_attribute13, cei_attribute14, cei_attribute15, cei_attribute16, cei_attribute17, cei_attribute18, cei_attribute19, cei_attribute20, object_version_number, last_update_date, last_updated_by, last_update_login, created_by, creation_date, request_id, program_application_id, program_id, program_update_date FROM per_contact_extra_info_f WHERE effective_start_date <= (SELECT ss.effective_date FROM fnd_sessions ss WHERE ss.session_id = USERENV('sessionid')) AND effective_end_date >= (SELECT ss.effective_date FROM fnd_sessions ss WHERE ss.session_id = USERENV('sessionid'))

View Text - HTML Formatted

SELECT CONTACT_EXTRA_INFO_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, CONTACT_RELATIONSHIP_ID
, INFORMATION_TYPE
, CEI_INFORMATION_CATEGORY
, CEI_INFORMATION1
, CEI_INFORMATION2
, CEI_INFORMATION3
, CEI_INFORMATION4
, CEI_INFORMATION5
, CEI_INFORMATION6
, CEI_INFORMATION7
, CEI_INFORMATION8
, CEI_INFORMATION9
, CEI_INFORMATION10
, CEI_INFORMATION11
, CEI_INFORMATION12
, CEI_INFORMATION13
, CEI_INFORMATION14
, CEI_INFORMATION15
, CEI_INFORMATION16
, CEI_INFORMATION17
, CEI_INFORMATION18
, CEI_INFORMATION19
, CEI_INFORMATION20
, CEI_INFORMATION21
, CEI_INFORMATION22
, CEI_INFORMATION23
, CEI_INFORMATION24
, CEI_INFORMATION25
, CEI_INFORMATION26
, CEI_INFORMATION27
, CEI_INFORMATION28
, CEI_INFORMATION29
, CEI_INFORMATION30
, CEI_ATTRIBUTE_CATEGORY
, CEI_ATTRIBUTE1
, CEI_ATTRIBUTE2
, CEI_ATTRIBUTE3
, CEI_ATTRIBUTE4
, CEI_ATTRIBUTE5
, CEI_ATTRIBUTE6
, CEI_ATTRIBUTE7
, CEI_ATTRIBUTE8
, CEI_ATTRIBUTE9
, CEI_ATTRIBUTE10
, CEI_ATTRIBUTE11
, CEI_ATTRIBUTE12
, CEI_ATTRIBUTE13
, CEI_ATTRIBUTE14
, CEI_ATTRIBUTE15
, CEI_ATTRIBUTE16
, CEI_ATTRIBUTE17
, CEI_ATTRIBUTE18
, CEI_ATTRIBUTE19
, CEI_ATTRIBUTE20
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM PER_CONTACT_EXTRA_INFO_F
WHERE EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))