VIEW: APPS.PER_EVENTS_V3

Source

View Text - Preformatted

SELECT INTERVIEW_TYPE.MEANING INTERVIEW_TYPE , LOCATION.LOCATION_CODE LOCATION , EVENT.ROWID ROW_ID , EVENT.EVENT_ID , EVENT.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , EVENT.LOCATION_ID , EVENT.INTERNAL_CONTACT_PERSON_ID , EVENT.ORGANIZATION_RUN_BY_ID , EVENT.ASSIGNMENT_ID , EVENT.DATE_START , EVENT.TYPE , EVENT.COMMENTS , EVENT.CONTACT_TELEPHONE_NUMBER , EVENT.DATE_END , EVENT.EMP_OR_APL , EVENT.EVENT_OR_INTERVIEW , EVENT.EXTERNAL_CONTACT , TO_DATE (EVENT.TIME_END, 'HH24:MI') TIME_END , TO_DATE (EVENT.TIME_START, 'HH24:MI') TIME_START , EVENT.REQUEST_ID , EVENT.PROGRAM_APPLICATION_ID , EVENT.PROGRAM_ID , EVENT.PROGRAM_UPDATE_DATE , EVENT.ATTRIBUTE_CATEGORY , EVENT.ATTRIBUTE1 , EVENT.ATTRIBUTE2 , EVENT.ATTRIBUTE3 , EVENT.ATTRIBUTE4 , EVENT.ATTRIBUTE5 , EVENT.ATTRIBUTE6 , EVENT.ATTRIBUTE7 , EVENT.ATTRIBUTE8 , EVENT.ATTRIBUTE9 , EVENT.ATTRIBUTE10 , EVENT.ATTRIBUTE11 , EVENT.ATTRIBUTE12 , EVENT.ATTRIBUTE13 , EVENT.ATTRIBUTE14 , EVENT.ATTRIBUTE15 , EVENT.ATTRIBUTE16 , EVENT.ATTRIBUTE17 , EVENT.ATTRIBUTE18 , EVENT.ATTRIBUTE19 , EVENT.ATTRIBUTE20 , EVENT.LAST_UPDATE_DATE , EVENT.LAST_UPDATED_BY , EVENT.LAST_UPDATE_LOGIN , EVENT.CREATED_BY , EVENT.CREATION_DATE , STATUS.ASSIGNMENT_STATUS_TYPE_ID , STATUSTL.USER_STATUS STATUS_AFTER_INTERVIEW , LOCATION.TIMEZONE_CODE FROM PER_EVENTS EVENT, PER_ASSIGNMENT_STATUS_TYPES STATUS, PER_ASSIGNMENT_STATUS_TYPES_TL STATUSTL, PER_ALL_ASSIGNMENTS_F ASSIGNMENT, HR_LOOKUPS INTERVIEW_TYPE, HR_LOCATIONS LOCATION WHERE ASSIGNMENT.ASSIGNMENT_STATUS_TYPE_ID = STATUS.ASSIGNMENT_STATUS_TYPE_ID AND EVENT.EVENT_OR_INTERVIEW = 'I' AND EVENT.LOCATION_ID = LOCATION.LOCATION_ID (+) AND EVENT.ASSIGNMENT_ID = ASSIGNMENT.ASSIGNMENT_ID AND (INTERVIEW_TYPE.LOOKUP_CODE = EVENT.TYPE AND INTERVIEW_TYPE.LOOKUP_TYPE = 'APL_INTERVIEW_TYPE') AND EVENT.DATE_START BETWEEN ASSIGNMENT.EFFECTIVE_START_DATE AND ASSIGNMENT.EFFECTIVE_END_DATE AND STATUS.assignment_status_type_id = STATUSTL.assignment_status_type_id AND STATUSTL.language = userenv('LANG')

View Text - HTML Formatted

SELECT INTERVIEW_TYPE.MEANING INTERVIEW_TYPE
, LOCATION.LOCATION_CODE LOCATION
, EVENT.ROWID ROW_ID
, EVENT.EVENT_ID
, EVENT.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, EVENT.LOCATION_ID
, EVENT.INTERNAL_CONTACT_PERSON_ID
, EVENT.ORGANIZATION_RUN_BY_ID
, EVENT.ASSIGNMENT_ID
, EVENT.DATE_START
, EVENT.TYPE
, EVENT.COMMENTS
, EVENT.CONTACT_TELEPHONE_NUMBER
, EVENT.DATE_END
, EVENT.EMP_OR_APL
, EVENT.EVENT_OR_INTERVIEW
, EVENT.EXTERNAL_CONTACT
, TO_DATE (EVENT.TIME_END
, 'HH24:MI') TIME_END
, TO_DATE (EVENT.TIME_START
, 'HH24:MI') TIME_START
, EVENT.REQUEST_ID
, EVENT.PROGRAM_APPLICATION_ID
, EVENT.PROGRAM_ID
, EVENT.PROGRAM_UPDATE_DATE
, EVENT.ATTRIBUTE_CATEGORY
, EVENT.ATTRIBUTE1
, EVENT.ATTRIBUTE2
, EVENT.ATTRIBUTE3
, EVENT.ATTRIBUTE4
, EVENT.ATTRIBUTE5
, EVENT.ATTRIBUTE6
, EVENT.ATTRIBUTE7
, EVENT.ATTRIBUTE8
, EVENT.ATTRIBUTE9
, EVENT.ATTRIBUTE10
, EVENT.ATTRIBUTE11
, EVENT.ATTRIBUTE12
, EVENT.ATTRIBUTE13
, EVENT.ATTRIBUTE14
, EVENT.ATTRIBUTE15
, EVENT.ATTRIBUTE16
, EVENT.ATTRIBUTE17
, EVENT.ATTRIBUTE18
, EVENT.ATTRIBUTE19
, EVENT.ATTRIBUTE20
, EVENT.LAST_UPDATE_DATE
, EVENT.LAST_UPDATED_BY
, EVENT.LAST_UPDATE_LOGIN
, EVENT.CREATED_BY
, EVENT.CREATION_DATE
, STATUS.ASSIGNMENT_STATUS_TYPE_ID
, STATUSTL.USER_STATUS STATUS_AFTER_INTERVIEW
, LOCATION.TIMEZONE_CODE
FROM PER_EVENTS EVENT
, PER_ASSIGNMENT_STATUS_TYPES STATUS
, PER_ASSIGNMENT_STATUS_TYPES_TL STATUSTL
, PER_ALL_ASSIGNMENTS_F ASSIGNMENT
, HR_LOOKUPS INTERVIEW_TYPE
, HR_LOCATIONS LOCATION
WHERE ASSIGNMENT.ASSIGNMENT_STATUS_TYPE_ID = STATUS.ASSIGNMENT_STATUS_TYPE_ID
AND EVENT.EVENT_OR_INTERVIEW = 'I'
AND EVENT.LOCATION_ID = LOCATION.LOCATION_ID (+)
AND EVENT.ASSIGNMENT_ID = ASSIGNMENT.ASSIGNMENT_ID
AND (INTERVIEW_TYPE.LOOKUP_CODE = EVENT.TYPE
AND INTERVIEW_TYPE.LOOKUP_TYPE = 'APL_INTERVIEW_TYPE')
AND EVENT.DATE_START BETWEEN ASSIGNMENT.EFFECTIVE_START_DATE
AND ASSIGNMENT.EFFECTIVE_END_DATE
AND STATUS.ASSIGNMENT_STATUS_TYPE_ID = STATUSTL.ASSIGNMENT_STATUS_TYPE_ID
AND STATUSTL.LANGUAGE = USERENV('LANG')