Product: | IGS - Student System |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGS_PE_CONTACTS_DETAILS_V |
SELECT CP.ROWID ROW_ID
, CP.CONTACT_POINT_ID
, CP.LOCATION_VENUE_ADDR_ID
, CP.CONTACT_POINT_TYPE
, CP.STATUS
, L1.MEANING STATUS_MEANING
, CP.PRIMARY_FLAG
, CP.LAST_UPDATE_DATE
, CP.LAST_UPDATED_BY
, CP.CREATION_DATE
, CP.CREATED_BY
, CP.LAST_UPDATE_LOGIN
, CP.REQUEST_ID
, CP.PROGRAM_APPLICATION_ID
, CP.PROGRAM_ID
, CP.PROGRAM_UPDATE_DATE
, L3.MEANING EMAIL_FORMAT_MEANING
, CP.EMAIL_FORMAT
, CP.EMAIL_ADDRESS
, CP.TELEPHONE_TYPE
, 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.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
FROM IGS_PE_CONTACT_DTLS 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