View: PER_EVENTS_V2

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_EVENTS_V2

View Text

SELECT PE.ROWID ROW_ID
, PE.EVENT_ID
, PE.BUSINESS_GROUP_ID
, HR.MEANING
, HLTL.LOCATION_CODE
, HR.LOOKUP_TYPE
, HOTL.NAME
, PAP.FULL_NAME
, NVL(PAP.EMPLOYEE_NUMBER
, PAP.NPW_NUMBER) EMPLOYEE_NUMBER
, 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
FROM PER_EVENTS PE
, PER_ALL_PEOPLE_F PAP
, HR_LOOKUPS HR
, HR_LOCATIONS_ALL_TL HLTL
, HR_LOCATIONS_NO_JOIN HL
, HR_ALL_ORGANIZATION_UNITS HO
, HR_ALL_ORGANIZATION_UNITS_TL HOTL
WHERE HO.ORGANIZATION_ID = HOTL.ORGANIZATION_ID (+)
AND PE.ORGANIZATION_RUN_BY_ID = HO.ORGANIZATION_ID (+)
AND PE.EVENT_OR_INTERVIEW = 'E'
AND PE.TYPE = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = DECODE(PE.EMP_OR_APL
, 'E'
, 'EMP_EVENT_TYPE'
, 'A'
, 'APL_EVENT_TYPE')
AND PE.LOCATION_ID = HL.LOCATION_ID (+)
AND PE.INTERNAL_CONTACT_PERSON_ID = PAP.PERSON_ID (+)
AND PE.DATE_START BETWEEN NVL(PAP.EFFECTIVE_START_DATE
, PE.DATE_START) AND NVL(PAP.EFFECTIVE_END_DATE
, PE.DATE_START)
AND DECODE (HOTL.ORGANIZATION_ID
, NULL
, '1'
, HOTL.LANGUAGE) = DECODE( HOTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND HL.LOCATION_ID = HLTL.LOCATION_ID (+)
AND DECODE (HLTL.LOCATION_ID
, NULL
, '1'
, HLTL.LANGUAGE) = DECODE(HLTL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))

Columns