VIEW: APPS.IGS_PE_CONTACTS_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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