VIEW: APPS.PER_EVENTS_V

Source

View Text - Preformatted

SELECT PE.ROWID ROW_ID , PE.EVENT_ID , PE.BUSINESS_GROUP_ID , HR.MEANING , HL.LOCATION_CODE , PE.LOCATION_ID , PE.INTERNAL_CONTACT_PERSON_ID , PE.ORGANIZATION_RUN_BY_ID , PE.ASSIGNMENT_ID , PE.DATE_START , PE.TYPE , PE.COMMENTS , PE.CONTACT_TELEPHONE_NUMBER , PE.DATE_END , PE.EMP_OR_APL , PE.EVENT_OR_INTERVIEW , PE.EXTERNAL_CONTACT , PE.TIME_END , PE.TIME_START , PE.REQUEST_ID , PE.PROGRAM_APPLICATION_ID , PE.PROGRAM_ID , PE.PROGRAM_UPDATE_DATE , PE.ATTRIBUTE_CATEGORY , PE.ATTRIBUTE1 , PE.ATTRIBUTE2 , PE.ATTRIBUTE3 , PE.ATTRIBUTE4 , PE.ATTRIBUTE5 , PE.ATTRIBUTE6 , PE.ATTRIBUTE7 , PE.ATTRIBUTE8 , PE.ATTRIBUTE9 , PE.ATTRIBUTE10 , PE.ATTRIBUTE11 , PE.ATTRIBUTE12 , PE.ATTRIBUTE13 , PE.ATTRIBUTE14 , PE.ATTRIBUTE15 , PE.ATTRIBUTE16 , PE.ATTRIBUTE17 , PE.ATTRIBUTE18 , PE.ATTRIBUTE19 , PE.ATTRIBUTE20 , PE.LAST_UPDATE_DATE , PE.LAST_UPDATED_BY , PE.LAST_UPDATE_LOGIN , PE.CREATED_BY , PE.CREATION_DATE , HL.TIMEZONE_CODE FROM PER_EVENTS PE, HR_LOOKUPS HR, HR_LOCATIONS HL WHERE PE.EVENT_OR_INTERVIEW = 'I' AND PE.LOCATION_ID = HL.LOCATION_ID (+) AND PE.TYPE = HR.LOOKUP_CODE AND HR.LOOKUP_TYPE = 'EMP_INTERVIEW_TYPE'

View Text - HTML Formatted

SELECT PE.ROWID ROW_ID
, PE.EVENT_ID
, PE.BUSINESS_GROUP_ID
, HR.MEANING
, HL.LOCATION_CODE
, PE.LOCATION_ID
, PE.INTERNAL_CONTACT_PERSON_ID
, PE.ORGANIZATION_RUN_BY_ID
, PE.ASSIGNMENT_ID
, PE.DATE_START
, PE.TYPE
, PE.COMMENTS
, PE.CONTACT_TELEPHONE_NUMBER
, PE.DATE_END
, PE.EMP_OR_APL
, PE.EVENT_OR_INTERVIEW
, PE.EXTERNAL_CONTACT
, PE.TIME_END
, PE.TIME_START
, PE.REQUEST_ID
, PE.PROGRAM_APPLICATION_ID
, PE.PROGRAM_ID
, PE.PROGRAM_UPDATE_DATE
, PE.ATTRIBUTE_CATEGORY
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.ATTRIBUTE11
, PE.ATTRIBUTE12
, PE.ATTRIBUTE13
, PE.ATTRIBUTE14
, PE.ATTRIBUTE15
, PE.ATTRIBUTE16
, PE.ATTRIBUTE17
, PE.ATTRIBUTE18
, PE.ATTRIBUTE19
, PE.ATTRIBUTE20
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_LOGIN
, PE.CREATED_BY
, PE.CREATION_DATE
, HL.TIMEZONE_CODE
FROM PER_EVENTS PE
, HR_LOOKUPS HR
, HR_LOCATIONS HL
WHERE PE.EVENT_OR_INTERVIEW = 'I'
AND PE.LOCATION_ID = HL.LOCATION_ID (+)
AND PE.TYPE = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = 'EMP_INTERVIEW_TYPE'